PREVIEW / stock_1hour / 2021-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-10.parquet
  size:    1.4 MB
  rows:    64,813
  symbols: 2,805

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-08-10 04:00:00	AAPL	Stock	146.22	146.23	146.05	146.09	4009.0
2021-08-10 05:00:00	AAPL	Stock	146.09	146.09	146.05	146.05	2258.0
2021-08-10 06:00:00	AAPL	Stock	146.08	146.09	145.96	145.96	3461.0
2021-08-10 07:00:00	AAPL	Stock	146.01	149.0	146.0	146.57	228120.0
2021-08-10 08:00:00	AAPL	Stock	146.5001	146.75	145.725	146.37	110256.0
2021-08-10 09:00:00	AAPL	Stock	146.37	147.71	146.18	147.425	10047086.0
2021-08-10 10:00:00	AAPL	Stock	147.425	147.6349	145.63	145.915	11757411.0
2021-08-10 11:00:00	AAPL	Stock	145.92	145.9586	145.395	145.62	7243941.0
2021-08-10 12:00:00	AAPL	Stock	145.625	146.0057	145.545	145.6	3730210.0
2021-08-10 13:00:00	AAPL	Stock	145.6	145.76	145.495	145.6587	3062586.0
2021-08-10 14:00:00	AAPL	Stock	145.655	145.715	145.3	145.7	3610851.0
2021-08-10 15:00:00	AAPL	Stock	145.7	145.73	145.3	145.61	6758770.0
2021-08-10 16:00:00	AAPL	Stock	145.6	145.61	145.48	145.57	9261215.0
2021-08-10 17:00:00	AAPL	Stock	145.58	145.67	145.57	145.65	51806.0
2021-08-10 18:00:00	AAPL	Stock	145.63	145.67	145.57	145.58	16875.0
2021-08-10 19:00:00	AAPL	Stock	145.59	145.66	145.5	145.6	30560.0
2021-08-10 04:00:00	MSFT	Stock	288.3	288.9	288.3	288.85	3152.0
2021-08-10 05:00:00	MSFT	Stock	288.81	289.3	288.81	289.3	4410.0
2021-08-10 06:00:00	MSFT	Stock	289.21	289.5	289.2	289.2	1330.0
2021-08-10 07:00:00	MSFT	Stock	289.2	289.35	288.7	288.95	9530.0
2021-08-10 08:00:00	MSFT	Stock	289.3427	289.3427	288.8	288.9	9149.0
2021-08-10 09:00:00	MSFT	Stock	288.86	289.21	288.05	288.9	1315295.0
2021-08-10 10:00:00	MSFT	Stock	288.93	289.25	285.85	286.39	1864451.0
2021-08-10 11:00:00	MSFT	Stock	286.37	286.37	285.2	285.8301	1385550.0
2021-08-10 12:00:00	MSFT	Stock	285.83	286.5275	285.83	285.95	870924.0
2021-08-10 13:00:00	MSFT	Stock	285.9576	286.14	285.48	285.9099	1049957.0
2021-08-10 14:00:00	MSFT	Stock	285.91	286.28	285.405	286.275	908588.0
2021-08-10 15:00:00	MSFT	Stock	286.275	286.5	285.69	286.49	1655109.0
2021-08-10 16:00:00	MSFT	Stock	286.44	286.47	285.9309	286.44	3296684.0
2021-08-10 17:00:00	MSFT	Stock	286.44	286.48	286.44	286.44	2666.0
2021-08-10 18:00:00	MSFT	Stock	286.42	286.42	286.25	286.35	2992.0
2021-08-10 19:00:00	MSFT	Stock	286.37	286.6	286.25	286.6	9758.0
2021-08-10 04:00:00	NVDA	Stock	20.302	20.346	20.295	20.295	16000.0
2021-08-10 05:00:00	NVDA	Stock	20.317	20.32	20.251	20.299	26500.0
2021-08-10 06:00:00	NVDA	Stock	20.288	20.288	20.231	20.264	32100.0
2021-08-10 07:00:00	NVDA	Stock	20.267	20.31	20.263	20.28	128540.0
2021-08-10 08:00:00	NVDA	Stock	20.2583	20.33	20.2583	20.315	181450.0
2021-08-10 09:00:00	NVDA	Stock	20.329	20.43	20.177	20.344	24607310.0
2021-08-10 10:00:00	NVDA	Stock	20.3469	20.38	19.89	19.9575	32989960.0
2021-08-10 11:00:00	NVDA	Stock	19.958	20.0412	19.8345	19.974	23344440.0
2021-08-10 12:00:00	NVDA	Stock	19.974	20.093	19.974	19.99	10444200.0
2021-08-10 13:00:00	NVDA	Stock	19.993	20.049	19.906	19.9897	9253640.0
2021-08-10 14:00:00	NVDA	Stock	19.992	20.032	19.8831	20.021	9702570.0
2021-08-10 15:00:00	NVDA	Stock	20.018	20.0379	19.882	19.939	15813390.0
2021-08-10 16:00:00	NVDA	Stock	19.936	19.945	19.9	19.925	14086960.0
2021-08-10 17:00:00	NVDA	Stock	19.933	19.961	19.92	19.961	179670.0
2021-08-10 18:00:00	NVDA	Stock	19.94	19.94	19.921	19.933	88700.0
2021-08-10 19:00:00	NVDA	Stock	19.93	19.933	19.91	19.911	60310.0
2021-08-10 07:00:00	AMZN	Stock	167.215	167.215	167.2	167.2	4000.0
2021-08-10 08:00:00	AMZN	Stock	167.2	167.3	167.2	167.3	12580.0

> showing 50 of 64,813 rows — these rows as CSV

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