PREVIEW / stock_1hour / 2021-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-21.parquet
  size:    1.4 MB
  rows:    65,557
  symbols: 2,608

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-12-21 04:00:00	AAPL	Stock	171.84	171.84	170.93	171.0	38323.0
2021-12-21 05:00:00	AAPL	Stock	170.97	171.18	170.64	170.85	42505.0
2021-12-21 06:00:00	AAPL	Stock	170.85	171.74	170.85	171.52	43915.0
2021-12-21 07:00:00	AAPL	Stock	171.51	172.33	171.4	172.15	165222.0
2021-12-21 08:00:00	AAPL	Stock	171.5201	172.49	169.75	169.75	573094.0
2021-12-21 09:00:00	AAPL	Stock	172.43	172.5	170.02	170.3311	11088504.0
2021-12-21 10:00:00	AAPL	Stock	170.34	170.96	169.12	169.85	12010771.0
2021-12-21 11:00:00	AAPL	Stock	169.84	171.25	169.82	170.735	9644221.0
2021-12-21 12:00:00	AAPL	Stock	170.74	171.54	170.46	170.995	7621303.0
2021-12-21 13:00:00	AAPL	Stock	171.0	171.315	170.66	171.24	6510738.0
2021-12-21 14:00:00	AAPL	Stock	171.25	173.03	171.1901	172.9382	9712098.0
2021-12-21 15:00:00	AAPL	Stock	172.94	173.2	172.191	172.98	11703818.0
2021-12-21 16:00:00	AAPL	Stock	172.975	173.14	170.82	172.92	7551909.0
2021-12-21 17:00:00	AAPL	Stock	172.96	173.08	172.89	173.03	34551.0
2021-12-21 18:00:00	AAPL	Stock	172.98	172.98	172.6	172.6	30388.0
2021-12-21 19:00:00	AAPL	Stock	172.6	172.72	172.53	172.58	30420.0
2021-12-21 04:00:00	MSFT	Stock	322.62	323.55	322.07	322.07	13062.0
2021-12-21 05:00:00	MSFT	Stock	322.6	322.7	322.25	322.3	4574.0
2021-12-21 06:00:00	MSFT	Stock	322.7	323.58	322.7	323.36	6953.0
2021-12-21 07:00:00	MSFT	Stock	323.4	323.42	323.01	323.42	15013.0
2021-12-21 08:00:00	MSFT	Stock	323.0016	323.51	320.709	323.4	55569.0
2021-12-21 09:00:00	MSFT	Stock	323.34	324.47	321.36	322.14	2018052.0
2021-12-21 10:00:00	MSFT	Stock	322.18	322.6199	319.8	321.23	2144606.0
2021-12-21 11:00:00	MSFT	Stock	321.23	324.03	321.08	323.325	1970698.0
2021-12-21 12:00:00	MSFT	Stock	323.31	325.95	322.995	325.78	1713796.0
2021-12-21 13:00:00	MSFT	Stock	325.81	326.24	325.25	325.86	1461466.0
2021-12-21 14:00:00	MSFT	Stock	325.9	327.69	325.66	327.675	1761423.0
2021-12-21 15:00:00	MSFT	Stock	327.68	327.73	325.68	327.37	3074024.0
2021-12-21 16:00:00	MSFT	Stock	327.29	327.97	324.7962	327.48	3906538.0
2021-12-21 17:00:00	MSFT	Stock	327.6	327.69	327.29	327.46	3873.0
2021-12-21 18:00:00	MSFT	Stock	327.33	327.4499	327.0	327.1	4376.0
2021-12-21 19:00:00	MSFT	Stock	327.22	327.25	326.65	326.75	11212.0
2021-12-21 04:00:00	NVDA	Stock	28.375	28.468	28.25	28.346	284560.0
2021-12-21 05:00:00	NVDA	Stock	28.271	28.425	28.271	28.42	65290.0
2021-12-21 06:00:00	NVDA	Stock	28.4	28.542	28.385	28.489	108690.0
2021-12-21 07:00:00	NVDA	Stock	28.466	28.578	28.44	28.557	652540.0
2021-12-21 08:00:00	NVDA	Stock	28.557	28.65	27.719	27.719	2316820.0
2021-12-21 09:00:00	NVDA	Stock	28.569	28.625	27.9172	27.924	50823210.0
2021-12-21 10:00:00	NVDA	Stock	27.924	28.052	27.401	27.711	61489990.0
2021-12-21 11:00:00	NVDA	Stock	27.705	28.171	27.651	28.095	44458550.0
2021-12-21 12:00:00	NVDA	Stock	28.1055	28.564	27.981	28.5145	52887180.0
2021-12-21 13:00:00	NVDA	Stock	28.522	28.868	28.382	28.805	46544540.0
2021-12-21 14:00:00	NVDA	Stock	28.815	29.0769	28.727	28.9755	58009340.0
2021-12-21 15:00:00	NVDA	Stock	28.977	29.12	28.787	29.086	61856170.0
2021-12-21 16:00:00	NVDA	Stock	29.086	29.149	29.073	29.125	21273830.0
2021-12-21 17:00:00	NVDA	Stock	29.125	29.175	29.115	29.175	373030.0
2021-12-21 18:00:00	NVDA	Stock	29.183	29.199	29.11	29.11	691870.0
2021-12-21 19:00:00	NVDA	Stock	29.117	29.129	28.9	29.0	592210.0
2021-12-21 04:00:00	AMZN	Stock	168.55	168.55	168.55	168.55	2000.0
2021-12-21 05:00:00	AMZN	Stock	168.251	168.251	168.251	168.251	2000.0

> showing 50 of 65,557 rows — these rows as CSV

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