PREVIEW / stock_1hour / 2022-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-12.parquet
  size:    1.4 MB
  rows:    62,920
  symbols: 2,225

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-08-12 04:00:00	AAPL	Stock	168.81	169.69	168.81	169.2	17062.0
2022-08-12 05:00:00	AAPL	Stock	169.09	169.25	168.97	169.25	14449.0
2022-08-12 06:00:00	AAPL	Stock	169.0	169.05	168.81	168.86	5409.0
2022-08-12 07:00:00	AAPL	Stock	168.96	169.08	168.72	169.0	57091.0
2022-08-12 08:00:00	AAPL	Stock	168.99	169.55	168.069	169.5	415637.0
2022-08-12 09:00:00	AAPL	Stock	169.53	170.19	169.4	170.14	7697237.0
2022-08-12 10:00:00	AAPL	Stock	170.13	170.62	169.7	170.5001	10335781.0
2022-08-12 11:00:00	AAPL	Stock	170.51	171.11	170.43	170.9203	7690884.0
2022-08-12 12:00:00	AAPL	Stock	170.93	171.35	170.83	170.8801	4192178.0
2022-08-12 13:00:00	AAPL	Stock	170.879	171.52	170.81	171.27	4360079.0
2022-08-12 14:00:00	AAPL	Stock	171.27	171.78	171.245	171.6902	3905958.0
2022-08-12 15:00:00	AAPL	Stock	171.69	172.17	171.655	172.15	11311074.0
2022-08-12 16:00:00	AAPL	Stock	172.14	172.17	171.81	172.04	8227196.0
2022-08-12 17:00:00	AAPL	Stock	172.04	172.04	171.7	171.78	97307.0
2022-08-12 18:00:00	AAPL	Stock	171.78	171.84	171.72	171.82	39078.0
2022-08-12 19:00:00	AAPL	Stock	171.82	171.9	171.79	171.9	37627.0
2022-08-12 04:00:00	MSFT	Stock	288.02	288.8	288.02	288.6	2243.0
2022-08-12 05:00:00	MSFT	Stock	288.65	288.8	288.65	288.8	1139.0
2022-08-12 06:00:00	MSFT	Stock	288.96	288.96	288.6	288.6	700.0
2022-08-12 07:00:00	MSFT	Stock	288.57	288.59	287.65	288.0	7506.0
2022-08-12 08:00:00	MSFT	Stock	288.0	288.85	286.303	288.4	23106.0
2022-08-12 09:00:00	MSFT	Stock	288.49	288.99	287.19	287.97	1472209.0
2022-08-12 10:00:00	MSFT	Stock	287.97	289.07	286.94	288.53	1479765.0
2022-08-12 11:00:00	MSFT	Stock	288.5	289.68	288.13	288.81	1277988.0
2022-08-12 12:00:00	MSFT	Stock	288.85	289.5	288.76	289.11	626364.0
2022-08-12 13:00:00	MSFT	Stock	289.08	290.16	288.81	289.9	1082559.0
2022-08-12 14:00:00	MSFT	Stock	289.93	290.84	289.79	290.675	1083751.0
2022-08-12 15:00:00	MSFT	Stock	290.68	291.91	290.545	291.91	3123884.0
2022-08-12 16:00:00	MSFT	Stock	291.91	291.98	291.54	291.98	4113070.0
2022-08-12 17:00:00	MSFT	Stock	291.93	292.0	291.86	291.88	4584.0
2022-08-12 18:00:00	MSFT	Stock	291.98	291.98	291.76	291.98	3359.0
2022-08-12 19:00:00	MSFT	Stock	291.95	292.24	291.85	292.24	6578.0
2022-08-12 04:00:00	NVDA	Stock	18.007	18.199	18.007	18.148	229740.0
2022-08-12 05:00:00	NVDA	Stock	18.142	18.178	18.115	18.16	122570.0
2022-08-12 06:00:00	NVDA	Stock	18.122	18.122	18.049	18.063	63670.0
2022-08-12 07:00:00	NVDA	Stock	18.056	18.07	18.011	18.05	179390.0
2022-08-12 08:00:00	NVDA	Stock	18.06	18.095	17.8972	18.07	769410.0
2022-08-12 09:00:00	NVDA	Stock	18.075	18.346	17.953	18.3375	62385520.0
2022-08-12 10:00:00	NVDA	Stock	18.3375	18.562	18.212	18.453	94763630.0
2022-08-12 11:00:00	NVDA	Stock	18.454	18.527	18.38	18.383	50617480.0
2022-08-12 12:00:00	NVDA	Stock	18.3835	18.54	18.372	18.488	34474980.0
2022-08-12 13:00:00	NVDA	Stock	18.4895	18.5678	18.4816	18.5325	31921570.0
2022-08-12 14:00:00	NVDA	Stock	18.533	18.642	18.522	18.632	35920860.0
2022-08-12 15:00:00	NVDA	Stock	18.633	18.718	18.593	18.708	57079180.0
2022-08-12 16:00:00	NVDA	Stock	18.7085	18.7439	18.697	18.7321	23998170.0
2022-08-12 17:00:00	NVDA	Stock	18.7318	18.739	18.711	18.722	317280.0
2022-08-12 18:00:00	NVDA	Stock	18.716	18.74	18.716	18.739	90320.0
2022-08-12 19:00:00	NVDA	Stock	18.735	18.778	18.728	18.778	221210.0
2022-08-12 04:00:00	AMZN	Stock	141.99	141.99	141.39	141.65	9899.0
2022-08-12 05:00:00	AMZN	Stock	141.68	141.97	141.65	141.65	4765.0

> showing 50 of 62,920 rows — these rows as CSV

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