PREVIEW / stock_1hour / 2021-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-30.parquet
  size:    1.4 MB
  rows:    64,428
  symbols: 2,631

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-30 04:00:00	AAPL	Stock	179.4	179.88	179.36	179.77	10695.0
2021-12-30 05:00:00	AAPL	Stock	179.77	179.8	179.68	179.75	4408.0
2021-12-30 06:00:00	AAPL	Stock	179.75	180.0	179.64	179.9	11982.0
2021-12-30 07:00:00	AAPL	Stock	179.89	179.98	179.62	179.68	75554.0
2021-12-30 08:00:00	AAPL	Stock	179.6899	179.94	179.5	179.6	360638.0
2021-12-30 09:00:00	AAPL	Stock	179.61	179.928	178.89	179.5285	6954065.0
2021-12-30 10:00:00	AAPL	Stock	179.53	180.57	179.49	180.005	11076947.0
2021-12-30 11:00:00	AAPL	Stock	180.01	180.1599	179.59	179.805	5971381.0
2021-12-30 12:00:00	AAPL	Stock	179.8	179.96	179.53	179.8358	3665815.0
2021-12-30 13:00:00	AAPL	Stock	179.83	179.8599	179.16	179.285	4866287.0
2021-12-30 14:00:00	AAPL	Stock	179.28	179.3481	178.66	179.24	5539127.0
2021-12-30 15:00:00	AAPL	Stock	179.2458	179.305	178.09	178.25	9594270.0
2021-12-30 16:00:00	AAPL	Stock	178.25	178.38	178.1	178.12	3385538.0
2021-12-30 17:00:00	AAPL	Stock	178.12	178.12	177.91	177.98	49964.0
2021-12-30 18:00:00	AAPL	Stock	178.0	178.22	177.98	178.22	39932.0
2021-12-30 19:00:00	AAPL	Stock	178.22	178.25	177.12	177.65	69328.0
2021-12-30 04:00:00	MSFT	Stock	342.02	342.23	341.94	342.0	2892.0
2021-12-30 05:00:00	MSFT	Stock	342.02	342.02	342.0	342.0	434.0
2021-12-30 06:00:00	MSFT	Stock	342.0	342.3	341.9	342.26	6747.0
2021-12-30 07:00:00	MSFT	Stock	342.13	342.92	342.13	342.87	10056.0
2021-12-30 08:00:00	MSFT	Stock	342.4999	342.8	341.81	342.7	15018.0
2021-12-30 09:00:00	MSFT	Stock	342.55	342.7	340.83	341.1818	1478190.0
2021-12-30 10:00:00	MSFT	Stock	341.21	343.13	341.041	341.479	1890510.0
2021-12-30 11:00:00	MSFT	Stock	341.47	342.39	341.16	341.5	1174631.0
2021-12-30 12:00:00	MSFT	Stock	341.49	341.8	341.14	341.43	816266.0
2021-12-30 13:00:00	MSFT	Stock	341.4351	341.4351	340.65	340.88	946825.0
2021-12-30 14:00:00	MSFT	Stock	340.89	341.2	340.2319	341.13	1077815.0
2021-12-30 15:00:00	MSFT	Stock	341.15	341.16	338.82	339.32	2451354.0
2021-12-30 16:00:00	MSFT	Stock	339.32	339.6	339.16	339.24	1792373.0
2021-12-30 17:00:00	MSFT	Stock	339.28	339.28	339.05	339.05	2228.0
2021-12-30 18:00:00	MSFT	Stock	339.15	339.45	339.03	339.16	4796.0
2021-12-30 19:00:00	MSFT	Stock	339.2999	339.33	337.11	338.07	14755.0
2021-12-30 04:00:00	NVDA	Stock	29.99	30.094	29.95	30.045	62350.0
2021-12-30 05:00:00	NVDA	Stock	30.043	30.11	30.01	30.1	121290.0
2021-12-30 06:00:00	NVDA	Stock	30.044	30.155	30.044	30.117	26980.0
2021-12-30 07:00:00	NVDA	Stock	30.093	30.162	30.01	30.012	256070.0
2021-12-30 08:00:00	NVDA	Stock	30.012	30.125	29.75	29.8593	775040.0
2021-12-30 09:00:00	NVDA	Stock	29.86	30.12	29.586	30.095	38077090.0
2021-12-30 10:00:00	NVDA	Stock	30.099	30.457	30.086	30.2682	50434580.0
2021-12-30 11:00:00	NVDA	Stock	30.264	30.366	30.1877	30.284	33078900.0
2021-12-30 12:00:00	NVDA	Stock	30.2859	30.373	30.136	30.195	22353840.0
2021-12-30 13:00:00	NVDA	Stock	30.196	30.205	29.99	30.0279	18901290.0
2021-12-30 14:00:00	NVDA	Stock	30.0268	30.063	29.897	29.946	21178210.0
2021-12-30 15:00:00	NVDA	Stock	29.946	29.949	29.54	29.588	39901040.0
2021-12-30 16:00:00	NVDA	Stock	29.586	29.63	29.55	29.585	9370300.0
2021-12-30 17:00:00	NVDA	Stock	29.588	29.593	29.551	29.57	195010.0
2021-12-30 18:00:00	NVDA	Stock	29.584	29.612	29.573	29.612	224560.0
2021-12-30 19:00:00	NVDA	Stock	29.619	29.619	29.401	29.45	679640.0
2021-12-30 06:00:00	AMZN	Stock	169.8	170.0	169.8	170.0	8880.0
2021-12-30 07:00:00	AMZN	Stock	170.0	170.0	169.6	169.7	25500.0

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

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