PREVIEW / stock_1hour / 2022-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-17.parquet
  size:    1.4 MB
  rows:    63,935
  symbols: 2,480

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
2022-03-17 04:00:00	AAPL	Stock	159.83	160.1	159.26	159.36	33788.0
2022-03-17 05:00:00	AAPL	Stock	159.31	159.31	158.85	159.2	22488.0
2022-03-17 06:00:00	AAPL	Stock	159.2	159.2	158.23	159.19	28463.0
2022-03-17 07:00:00	AAPL	Stock	159.23	159.24	158.5	158.89	65027.0
2022-03-17 08:00:00	AAPL	Stock	159.0301	160.0	158.21	158.44	503337.0
2022-03-17 09:00:00	AAPL	Stock	158.43	159.54	157.73	159.4999	7981010.0
2022-03-17 10:00:00	AAPL	Stock	159.49	159.92	157.73	158.02	9209314.0
2022-03-17 11:00:00	AAPL	Stock	158.0	158.84	157.63	158.58	6528670.0
2022-03-17 12:00:00	AAPL	Stock	158.6	159.3	158.33	159.04	5942563.0
2022-03-17 13:00:00	AAPL	Stock	159.03	160.25	158.52	160.0	6990061.0
2022-03-17 14:00:00	AAPL	Stock	160.01	160.13	159.265	159.901	5875329.0
2022-03-17 15:00:00	AAPL	Stock	159.915	161.0	159.3257	160.99	11880811.0
2022-03-17 16:00:00	AAPL	Stock	160.99	160.99	159.7	159.93	9993603.0
2022-03-17 17:00:00	AAPL	Stock	159.9201	160.19	159.85	160.0	34395.0
2022-03-17 18:00:00	AAPL	Stock	160.0	160.07	159.6	159.8	58540.0
2022-03-17 19:00:00	AAPL	Stock	159.79	159.99	159.7	159.81	32656.0
2022-03-17 04:00:00	MSFT	Stock	295.7	295.7	293.58	293.75	4924.0
2022-03-17 05:00:00	MSFT	Stock	293.99	294.31	293.35	294.31	6620.0
2022-03-17 06:00:00	MSFT	Stock	294.0	294.29	291.81	294.29	4059.0
2022-03-17 07:00:00	MSFT	Stock	293.57	294.14	293.1	293.59	13975.0
2022-03-17 08:00:00	MSFT	Stock	293.6	295.75	292.07	292.32	31862.0
2022-03-17 09:00:00	MSFT	Stock	292.4	293.88	291.32	293.44	1958191.0
2022-03-17 10:00:00	MSFT	Stock	293.4499	294.51	290.0	291.07	3056229.0
2022-03-17 11:00:00	MSFT	Stock	291.04	291.52	289.37	290.731	1817853.0
2022-03-17 12:00:00	MSFT	Stock	290.76	292.235	290.36	291.9692	1816484.0
2022-03-17 13:00:00	MSFT	Stock	291.955	294.11	291.14	293.56	2342853.0
2022-03-17 14:00:00	MSFT	Stock	293.63	293.82	292.1801	293.34	1786700.0
2022-03-17 15:00:00	MSFT	Stock	293.34	295.61	292.36	295.38	3810840.0
2022-03-17 16:00:00	MSFT	Stock	295.22	295.57	293.8	293.8	4104462.0
2022-03-17 17:00:00	MSFT	Stock	293.75	294.5	293.75	294.49	6801.0
2022-03-17 18:00:00	MSFT	Stock	294.4	294.4	293.21	293.3	12896.0
2022-03-17 19:00:00	MSFT	Stock	293.35	293.75	293.31	293.5	4835.0
2022-03-17 04:00:00	NVDA	Stock	24.6	24.607	24.312	24.372	74730.0
2022-03-17 05:00:00	NVDA	Stock	24.387	24.43	24.205	24.295	178910.0
2022-03-17 06:00:00	NVDA	Stock	24.225	24.258	24.14	24.25	127120.0
2022-03-17 07:00:00	NVDA	Stock	24.268	24.325	24.205	24.28	326590.0
2022-03-17 08:00:00	NVDA	Stock	24.225	25.0	24.216	24.25	1026050.0
2022-03-17 09:00:00	NVDA	Stock	24.255	24.748	23.906	24.7425	50726000.0
2022-03-17 10:00:00	NVDA	Stock	24.7425	24.768	24.005	24.193	59929650.0
2022-03-17 11:00:00	NVDA	Stock	24.185	24.469	24.02	24.282	45592110.0
2022-03-17 12:00:00	NVDA	Stock	24.284	24.3755	24.165	24.2995	36114910.0
2022-03-17 13:00:00	NVDA	Stock	24.304	24.625	24.18	24.537	40196670.0
2022-03-17 14:00:00	NVDA	Stock	24.537	24.61	24.396	24.548	34023070.0
2022-03-17 15:00:00	NVDA	Stock	24.548	24.842	24.47	24.769	62837540.0
2022-03-17 16:00:00	NVDA	Stock	24.769	24.8	24.56	24.604	19030480.0
2022-03-17 17:00:00	NVDA	Stock	24.611	24.65	24.582	24.6	184070.0
2022-03-17 18:00:00	NVDA	Stock	24.6	24.68	24.55	24.55	290730.0
2022-03-17 19:00:00	NVDA	Stock	24.58	24.596	24.425	24.501	385070.0
2022-03-17 04:00:00	AMZN	Stock	153.0	153.0	153.0	153.0	5600.0
2022-03-17 06:00:00	AMZN	Stock	152.2525	152.2525	152.1395	152.1395	4000.0

> showing 50 of 63,935 rows — these rows as CSV

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