PREVIEW / stock_1hour / 2021-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-01.parquet
  size:    1.5 MB
  rows:    70,256
  symbols: 2,864

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-03-01 04:00:00	AAPL	Stock	124.3	124.6	123.7	124.18	95794.0
2021-03-01 05:00:00	AAPL	Stock	124.11	124.34	123.9	124.0	68405.0
2021-03-01 06:00:00	AAPL	Stock	124.0	124.16	123.43	123.63	77949.0
2021-03-01 07:00:00	AAPL	Stock	123.6	123.76	123.17	123.52	416949.0
2021-03-01 08:00:00	AAPL	Stock	123.59	123.7	121.563	123.65	640257.0
2021-03-01 09:00:00	AAPL	Stock	123.6599	124.84	122.79	124.8101	16505445.0
2021-03-01 10:00:00	AAPL	Stock	124.82	125.72	124.5001	125.6122	15454561.0
2021-03-01 11:00:00	AAPL	Stock	125.63	126.6	125.425	126.54	12496378.0
2021-03-01 12:00:00	AAPL	Stock	126.54	126.62	125.83	126.1601	8924656.0
2021-03-01 13:00:00	AAPL	Stock	126.17	126.555	125.67	126.35	7301578.0
2021-03-01 14:00:00	AAPL	Stock	126.36	127.75	126.2701	127.575	11700302.0
2021-03-01 15:00:00	AAPL	Stock	127.585	127.93	127.27	127.79	15438053.0
2021-03-01 16:00:00	AAPL	Stock	127.79	128.69	127.79	128.36	10779165.0
2021-03-01 17:00:00	AAPL	Stock	128.34	128.62	128.25	128.44	136198.0
2021-03-01 18:00:00	AAPL	Stock	128.46	128.68	127.79	128.4	210754.0
2021-03-01 19:00:00	AAPL	Stock	128.4	128.75	128.3	128.75	177487.0
2021-03-01 04:00:00	MSFT	Stock	235.87	236.17	235.54	235.7	6354.0
2021-03-01 05:00:00	MSFT	Stock	235.89	236.24	235.76	235.76	3883.0
2021-03-01 06:00:00	MSFT	Stock	235.8	235.9	234.73	234.78	10914.0
2021-03-01 07:00:00	MSFT	Stock	235.25	235.64	234.75	234.8	26301.0
2021-03-01 08:00:00	MSFT	Stock	235.3	235.6514	231.8	235.15	45890.0
2021-03-01 09:00:00	MSFT	Stock	235.39	236.3	233.15	235.54	2851613.0
2021-03-01 10:00:00	MSFT	Stock	235.59	236.67	234.8	236.5794	2851477.0
2021-03-01 11:00:00	MSFT	Stock	236.58	237.25	236.17	236.94	1834858.0
2021-03-01 12:00:00	MSFT	Stock	236.95	237.135	236.13	236.28	1415626.0
2021-03-01 13:00:00	MSFT	Stock	236.3	236.76	236.06	236.55	1327416.0
2021-03-01 14:00:00	MSFT	Stock	236.58	237.17	236.44	236.97	1737783.0
2021-03-01 15:00:00	MSFT	Stock	236.98	237.47	236.25	236.94	3472061.0
2021-03-01 16:00:00	MSFT	Stock	236.94	237.39	236.94	237.2	4323046.0
2021-03-01 17:00:00	MSFT	Stock	237.12	237.21	236.94	237.04	27142.0
2021-03-01 18:00:00	MSFT	Stock	237.1	237.4	237.04	237.29	3482.0
2021-03-01 19:00:00	MSFT	Stock	237.35	237.35	237.14	237.2	2388.0
2021-03-01 04:00:00	NVDA	Stock	13.927	13.975	13.927	13.95	105720.0
2021-03-01 05:00:00	NVDA	Stock	13.955	13.9592	13.9375	13.9375	106600.0
2021-03-01 06:00:00	NVDA	Stock	13.925	13.925	13.8888	13.8998	47240.0
2021-03-01 07:00:00	NVDA	Stock	13.8878	13.9235	13.8625	13.8925	371200.0
2021-03-01 08:00:00	NVDA	Stock	13.8875	13.915	13.8155	13.8928	964440.0
2021-03-01 09:00:00	NVDA	Stock	13.875	13.925	13.613	13.6881	40183640.0
2021-03-01 10:00:00	NVDA	Stock	13.6932	13.7042	13.5532	13.6553	41315240.0
2021-03-01 11:00:00	NVDA	Stock	13.6585	13.8147	13.6194	13.7668	30229040.0
2021-03-01 12:00:00	NVDA	Stock	13.7692	13.7735	13.5925	13.655	21633560.0
2021-03-01 13:00:00	NVDA	Stock	13.6602	13.6902	13.625	13.6551	13404280.0
2021-03-01 14:00:00	NVDA	Stock	13.6562	13.7625	13.645	13.7331	18872480.0
2021-03-01 15:00:00	NVDA	Stock	13.737	13.8548	13.706	13.8442	32983000.0
2021-03-01 16:00:00	NVDA	Stock	13.8418	13.8735	13.815	13.8592	25999120.0
2021-03-01 17:00:00	NVDA	Stock	13.8252	13.85	13.813	13.813	110920.0
2021-03-01 18:00:00	NVDA	Stock	13.8363	13.8655	13.8142	13.8513	200360.0
2021-03-01 19:00:00	NVDA	Stock	13.865	13.8998	13.865	13.8998	527120.0
2021-03-01 04:00:00	AMZN	Stock	157.001	157.001	156.85	156.85	6840.0
2021-03-01 05:00:00	AMZN	Stock	157.249	157.2495	157.249	157.2495	4000.0

> showing 50 of 70,256 rows — these rows as CSV

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