PREVIEW / stock_1hour / 2020-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-21.parquet
  size:    1.4 MB
  rows:    67,471
  symbols: 2,693

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
2020-12-21 04:00:00	AAPL	Stock	127.1	127.5	125.62	126.0	95684.0
2020-12-21 05:00:00	AAPL	Stock	125.95	125.99	124.01	124.28	177080.0
2020-12-21 06:00:00	AAPL	Stock	124.28	125.0	124.0	124.85	64622.0
2020-12-21 07:00:00	AAPL	Stock	124.75	125.48	123.84	124.69	1232076.0
2020-12-21 08:00:00	AAPL	Stock	124.7	125.45	123.85	125.15	961583.0
2020-12-21 09:00:00	AAPL	Stock	125.15	126.655	124.68	125.91	13576850.0
2020-12-21 10:00:00	AAPL	Stock	125.91	126.025	123.449	123.85	18726392.0
2020-12-21 11:00:00	AAPL	Stock	123.85	125.155	123.81	124.94	10354120.0
2020-12-21 12:00:00	AAPL	Stock	124.94	126.05	124.89	126.041	7532779.0
2020-12-21 13:00:00	AAPL	Stock	126.05	127.28	125.84	126.74	8974767.0
2020-12-21 14:00:00	AAPL	Stock	126.73	127.06	126.49	126.748	7495021.0
2020-12-21 15:00:00	AAPL	Stock	126.75	128.31	126.14	128.24	21352031.0
2020-12-21 16:00:00	AAPL	Stock	128.23	130.0	127.98	129.99	14699560.0
2020-12-21 17:00:00	AAPL	Stock	129.99	132.0	129.78	130.65	2603124.0
2020-12-21 18:00:00	AAPL	Stock	130.63	131.45	130.6	131.12	830357.0
2020-12-21 19:00:00	AAPL	Stock	131.11	131.15	130.5	130.62	460920.0
2020-12-21 04:00:00	MSFT	Stock	220.29	220.29	218.0	218.13	15740.0
2020-12-21 05:00:00	MSFT	Stock	218.05	218.05	215.55	216.0	24972.0
2020-12-21 06:00:00	MSFT	Stock	216.01	217.5	216.01	216.95	27197.0
2020-12-21 07:00:00	MSFT	Stock	217.16	217.9	216.5	217.11	85534.0
2020-12-21 08:00:00	MSFT	Stock	216.98	217.83	216.5	217.49	124291.0
2020-12-21 09:00:00	MSFT	Stock	217.6	220.24	217.1	218.57	3620443.0
2020-12-21 10:00:00	MSFT	Stock	218.55	219.24	217.28	218.604	3886791.0
2020-12-21 11:00:00	MSFT	Stock	218.605	220.438	218.55	220.14	2610227.0
2020-12-21 12:00:00	MSFT	Stock	220.14	222.72	220.0	222.712	3740799.0
2020-12-21 13:00:00	MSFT	Stock	222.73	224.0	222.44	223.91	3410954.0
2020-12-21 14:00:00	MSFT	Stock	223.91	224.0	222.85	222.96	2613763.0
2020-12-21 15:00:00	MSFT	Stock	222.96	223.12	221.85	222.57	4174687.0
2020-12-21 16:00:00	MSFT	Stock	222.57	222.75	222.38	222.45	6119924.0
2020-12-21 17:00:00	MSFT	Stock	222.5	222.95	222.41	222.87	23261.0
2020-12-21 18:00:00	MSFT	Stock	222.84	224.0	222.65	222.9	33880.0
2020-12-21 19:00:00	MSFT	Stock	223.1	223.15	222.75	222.8	15741.0
2020-12-21 04:00:00	NVDA	Stock	13.18	13.18	13.175	13.175	10560.0
2020-12-21 05:00:00	NVDA	Stock	13.15	13.15	12.975	12.9875	297200.0
2020-12-21 06:00:00	NVDA	Stock	13.025	13.0495	13.025	13.0492	38320.0
2020-12-21 07:00:00	NVDA	Stock	13.075	13.1725	13.075	13.125	846800.0
2020-12-21 08:00:00	NVDA	Stock	13.125	13.175	13.0515	13.125	1501160.0
2020-12-21 09:00:00	NVDA	Stock	13.1438	13.272	13.03	13.0606	31492480.0
2020-12-21 10:00:00	NVDA	Stock	13.0572	13.0948	12.9675	13.021	35135640.0
2020-12-21 11:00:00	NVDA	Stock	13.021	13.2152	13.015	13.1795	32515720.0
2020-12-21 12:00:00	NVDA	Stock	13.1802	13.3495	13.1798	13.3102	33865040.0
2020-12-21 13:00:00	NVDA	Stock	13.3148	13.37	13.2968	13.3464	15994400.0
2020-12-21 14:00:00	NVDA	Stock	13.3465	13.3518	13.3048	13.3225	11185840.0
2020-12-21 15:00:00	NVDA	Stock	13.325	13.336	13.2565	13.3282	33591440.0
2020-12-21 16:00:00	NVDA	Stock	13.3322	13.334	13.3	13.3158	19834920.0
2020-12-21 17:00:00	NVDA	Stock	13.3162	13.3245	13.3115	13.3245	98840.0
2020-12-21 18:00:00	NVDA	Stock	13.3262	13.3285	13.3042	13.3042	142600.0
2020-12-21 19:00:00	NVDA	Stock	13.325	13.325	13.305	13.3195	127720.0
2020-12-21 04:00:00	AMZN	Stock	161.1	161.1	160.0	160.0	17320.0
2020-12-21 05:00:00	AMZN	Stock	159.5005	159.748	159.25	159.25	21980.0

> showing 50 of 67,471 rows — these rows as CSV

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