PREVIEW / stock_1hour / 2021-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-13.parquet
  size:    1.4 MB
  rows:    66,124
  symbols: 2,993

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2021-05-13 04:00:00	AAPL	Stock	122.1	122.3	121.68	122.05	55536.0
2021-05-13 05:00:00	AAPL	Stock	122.13	122.63	122.02	122.1	21055.0
2021-05-13 06:00:00	AAPL	Stock	122.14	122.47	121.88	122.25	29720.0
2021-05-13 07:00:00	AAPL	Stock	122.19	123.56	122.14	123.25	429793.0
2021-05-13 08:00:00	AAPL	Stock	122.2001	123.91	122.12	123.57	800125.0
2021-05-13 09:00:00	AAPL	Stock	123.6	125.84	123.57	125.35	17143482.0
2021-05-13 10:00:00	AAPL	Stock	125.34	126.15	125.16	126.0101	15161976.0
2021-05-13 11:00:00	AAPL	Stock	126.015	126.11	124.59	124.895	12449688.0
2021-05-13 12:00:00	AAPL	Stock	124.9	125.76	124.84	125.03	9078718.0
2021-05-13 13:00:00	AAPL	Stock	125.03	125.315	124.26	124.69	10189963.0
2021-05-13 14:00:00	AAPL	Stock	124.69	125.6701	124.68	125.39	8690575.0
2021-05-13 15:00:00	AAPL	Stock	125.4	125.79	124.9	124.94	12045046.0
2021-05-13 16:00:00	AAPL	Stock	124.97	125.25	124.5	124.82	8100477.0
2021-05-13 17:00:00	AAPL	Stock	124.8	124.86	124.71	124.84	46832.0
2021-05-13 18:00:00	AAPL	Stock	124.8399	124.97	124.76	124.79	45511.0
2021-05-13 19:00:00	AAPL	Stock	124.78	125.11	124.6	125.03	65223.0
2021-05-13 04:00:00	MSFT	Stock	238.52	239.0	238.0	238.2	10700.0
2021-05-13 05:00:00	MSFT	Stock	238.2	238.89	238.2	238.75	3809.0
2021-05-13 06:00:00	MSFT	Stock	238.4	238.9	238.18	238.89	5292.0
2021-05-13 07:00:00	MSFT	Stock	238.73	240.8	238.73	240.31	53446.0
2021-05-13 08:00:00	MSFT	Stock	240.38	241.7	238.8	241.29	476351.0
2021-05-13 09:00:00	MSFT	Stock	241.15	243.69	241.0	243.28	3360141.0
2021-05-13 10:00:00	MSFT	Stock	243.305	245.6	243.305	245.18	3513056.0
2021-05-13 11:00:00	MSFT	Stock	245.2	245.25	242.15	243.01	2883725.0
2021-05-13 12:00:00	MSFT	Stock	243.0	244.18	242.69	242.84	1988528.0
2021-05-13 13:00:00	MSFT	Stock	242.85	243.25	241.49	242.2843	2122196.0
2021-05-13 14:00:00	MSFT	Stock	242.29	244.31	242.23	243.93	2071777.0
2021-05-13 15:00:00	MSFT	Stock	243.92	244.83	242.83	242.98	3586981.0
2021-05-13 16:00:00	MSFT	Stock	243.03	243.07	242.5	242.85	3369579.0
2021-05-13 17:00:00	MSFT	Stock	242.85	243.0	242.67	242.75	9923.0
2021-05-13 18:00:00	MSFT	Stock	242.8	243.1	242.75	243.0	11196.0
2021-05-13 19:00:00	MSFT	Stock	242.9	243.45	242.55	243.3	16920.0
2021-05-13 05:00:00	NVDA	Stock	13.725	13.725	13.725	13.725	4000.0
2021-05-13 06:00:00	NVDA	Stock	13.719	13.719	13.675	13.675	33400.0
2021-05-13 07:00:00	NVDA	Stock	13.6922	13.9495	13.6922	13.875	670960.0
2021-05-13 08:00:00	NVDA	Stock	13.7	14.0192	13.6975	13.9625	971520.0
2021-05-13 09:00:00	NVDA	Stock	13.975	14.0808	13.8448	13.9598	28056680.0
2021-05-13 10:00:00	NVDA	Stock	13.9608	13.992	13.8301	13.8822	20408200.0
2021-05-13 11:00:00	NVDA	Stock	13.8843	13.8843	13.6115	13.6403	21286720.0
2021-05-13 12:00:00	NVDA	Stock	13.6433	13.75	13.588	13.588	16027040.0
2021-05-13 13:00:00	NVDA	Stock	13.5878	13.65	13.459	13.5465	20558360.0
2021-05-13 14:00:00	NVDA	Stock	13.5568	13.7132	13.555	13.6418	13646240.0
2021-05-13 15:00:00	NVDA	Stock	13.6482	13.754	13.6161	13.6575	26702320.0
2021-05-13 16:00:00	NVDA	Stock	13.6652	13.7556	13.62	13.6408	20725600.0
2021-05-13 17:00:00	NVDA	Stock	13.6652	13.6652	13.6358	13.6493	53720.0
2021-05-13 18:00:00	NVDA	Stock	13.6525	13.665	13.645	13.65	127240.0
2021-05-13 19:00:00	NVDA	Stock	13.6378	13.675	13.6378	13.675	74800.0
2021-05-13 05:00:00	AMZN	Stock	157.4305	157.49	157.4305	157.49	4980.0
2021-05-13 06:00:00	AMZN	Stock	157.55	157.55	157.55	157.55	11880.0
2021-05-13 07:00:00	AMZN	Stock	157.5105	159.0	157.375	158.7505	71160.0

> showing 50 of 66,124 rows — these rows as CSV

> unlock the full archive -- $79 one-time