PREVIEW / stock_1hour / 2021-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-21.parquet
  size:    1.4 MB
  rows:    66,281
  symbols: 2,694

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-01-21 04:00:00	AAPL	Stock	133.2	133.66	133.0	133.56	41692.0
2021-01-21 05:00:00	AAPL	Stock	133.56	133.65	133.24	133.5	36601.0
2021-01-21 06:00:00	AAPL	Stock	133.51	133.89	133.51	133.61	60800.0
2021-01-21 07:00:00	AAPL	Stock	133.68	134.09	133.57	134.05	411049.0
2021-01-21 08:00:00	AAPL	Stock	133.95	134.31	133.5	133.64	951234.0
2021-01-21 09:00:00	AAPL	Stock	133.63	135.08	133.55	134.878	20677152.0
2021-01-21 10:00:00	AAPL	Stock	134.86	136.35	134.8	135.985	20415819.0
2021-01-21 11:00:00	AAPL	Stock	135.985	136.38	135.56	136.07	11889265.0
2021-01-21 12:00:00	AAPL	Stock	136.08	136.2	135.21	136.165	9238770.0
2021-01-21 13:00:00	AAPL	Stock	136.17	136.48	135.913	136.125	7196169.0
2021-01-21 14:00:00	AAPL	Stock	136.13	136.7	136.095	136.535	7522818.0
2021-01-21 15:00:00	AAPL	Stock	136.535	139.67	136.45	136.87	15953458.0
2021-01-21 16:00:00	AAPL	Stock	136.86	137.36	136.7	137.3	10140552.0
2021-01-21 17:00:00	AAPL	Stock	137.3	137.5	136.99	137.07	310123.0
2021-01-21 18:00:00	AAPL	Stock	137.1	137.15	136.4	136.46	283504.0
2021-01-21 19:00:00	AAPL	Stock	136.49	136.78	136.32	136.38	207040.0
2021-01-21 04:00:00	MSFT	Stock	224.88	224.88	223.3	223.3	22182.0
2021-01-21 05:00:00	MSFT	Stock	223.3	223.8	223.3	223.8	10123.0
2021-01-21 06:00:00	MSFT	Stock	223.8	224.2	223.51	224.2	11846.0
2021-01-21 07:00:00	MSFT	Stock	224.2	224.8	224.02	224.4	43664.0
2021-01-21 08:00:00	MSFT	Stock	224.67	225.0	223.76	224.5	116793.0
2021-01-21 09:00:00	MSFT	Stock	224.5	226.0	222.42	223.213	3867558.0
2021-01-21 10:00:00	MSFT	Stock	223.21	225.05	222.72	224.533	3570095.0
2021-01-21 11:00:00	MSFT	Stock	224.53	225.54	224.32	225.145	2255843.0
2021-01-21 12:00:00	MSFT	Stock	225.134	226.25	224.76	226.21	1963225.0
2021-01-21 13:00:00	MSFT	Stock	226.204	226.3	225.18	225.41	1751871.0
2021-01-21 14:00:00	MSFT	Stock	225.4	226.04	225.31	225.9	1368865.0
2021-01-21 15:00:00	MSFT	Stock	225.9	226.2	224.63	224.9	3017773.0
2021-01-21 16:00:00	MSFT	Stock	224.97	225.15	224.0	225.0	5317163.0
2021-01-21 17:00:00	MSFT	Stock	225.04	225.3	224.85	225.0	18555.0
2021-01-21 18:00:00	MSFT	Stock	224.94	225.7	224.86	225.48	30112.0
2021-01-21 19:00:00	MSFT	Stock	225.38	225.45	224.89	225.2	15987.0
2021-01-21 04:00:00	NVDA	Stock	13.45	13.45	13.45	13.45	5560.0
2021-01-21 05:00:00	NVDA	Stock	13.4375	13.472	13.425	13.425	17280.0
2021-01-21 06:00:00	NVDA	Stock	13.4165	13.4165	13.383	13.4	35600.0
2021-01-21 07:00:00	NVDA	Stock	13.3975	13.4375	13.394	13.4	383920.0
2021-01-21 08:00:00	NVDA	Stock	13.4162	13.4375	13.3265	13.3673	1123040.0
2021-01-21 09:00:00	NVDA	Stock	13.3673	13.5303	13.253	13.5129	41234520.0
2021-01-21 10:00:00	NVDA	Stock	13.5162	13.5998	13.4818	13.579	39698120.0
2021-01-21 11:00:00	NVDA	Stock	13.579	13.6695	13.5402	13.6138	33384560.0
2021-01-21 12:00:00	NVDA	Stock	13.6181	13.624	13.5025	13.5865	20392120.0
2021-01-21 13:00:00	NVDA	Stock	13.5872	13.667	13.5782	13.6433	17459880.0
2021-01-21 14:00:00	NVDA	Stock	13.6393	13.6935	13.6299	13.6891	14749040.0
2021-01-21 15:00:00	NVDA	Stock	13.6895	13.9994	13.6775	13.8675	89159280.0
2021-01-21 16:00:00	NVDA	Stock	13.8608	13.875	13.765	13.8005	19410760.0
2021-01-21 17:00:00	NVDA	Stock	13.8	13.8363	13.775	13.7992	1003400.0
2021-01-21 18:00:00	NVDA	Stock	13.8175	13.8175	13.7402	13.7625	976360.0
2021-01-21 19:00:00	NVDA	Stock	13.7625	13.796	13.75	13.7675	195400.0
2021-01-21 04:00:00	AMZN	Stock	164.05	164.05	163.854	163.854	10900.0
2021-01-21 05:00:00	AMZN	Stock	163.8	163.8	163.65	163.65	10900.0

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

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