PREVIEW / stock_1hour / 2021-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-29.parquet
  size:    1.4 MB
  rows:    64,637
  symbols: 2,638

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-29 04:00:00	AAPL	Stock	179.85	180.1	179.55	179.68	19462.0
2021-12-29 05:00:00	AAPL	Stock	179.72	179.72	179.45	179.5	6439.0
2021-12-29 06:00:00	AAPL	Stock	179.48	179.5	179.25	179.29	6401.0
2021-12-29 07:00:00	AAPL	Stock	179.47	179.63	179.2	179.42	103201.0
2021-12-29 08:00:00	AAPL	Stock	179.4399	179.738	179.02	179.27	312709.0
2021-12-29 09:00:00	AAPL	Stock	179.27	180.63	179.25	180.32	8550496.0
2021-12-29 10:00:00	AAPL	Stock	180.31	180.37	178.14	179.825	11650746.0
2021-12-29 11:00:00	AAPL	Stock	179.82	179.94	178.85	179.075	6846673.0
2021-12-29 12:00:00	AAPL	Stock	179.0769	179.3672	178.675	179.325	4254373.0
2021-12-29 13:00:00	AAPL	Stock	179.33	179.4745	179.01	179.13	3866621.0
2021-12-29 14:00:00	AAPL	Stock	179.12	179.6434	178.98	179.57	4409490.0
2021-12-29 15:00:00	AAPL	Stock	179.56	179.8	179.35	179.38	8536551.0
2021-12-29 16:00:00	AAPL	Stock	179.38	179.52	179.2	179.26	4813696.0
2021-12-29 17:00:00	AAPL	Stock	179.26	179.26	179.16	179.1701	23849.0
2021-12-29 18:00:00	AAPL	Stock	179.25	179.28	179.01	179.01	33270.0
2021-12-29 19:00:00	AAPL	Stock	179.01	179.05	178.87	178.88	43773.0
2021-12-29 04:00:00	MSFT	Stock	342.8	342.8	340.5	342.05	2706.0
2021-12-29 05:00:00	MSFT	Stock	342.07	342.53	342.05	342.14	3143.0
2021-12-29 06:00:00	MSFT	Stock	342.11	342.11	341.95	342.04	463.0
2021-12-29 07:00:00	MSFT	Stock	341.93	341.93	341.52	341.65	4331.0
2021-12-29 08:00:00	MSFT	Stock	341.6553	342.1599	340.99	341.25	11565.0
2021-12-29 09:00:00	MSFT	Stock	341.3	344.3	341.25	343.865	2217345.0
2021-12-29 10:00:00	MSFT	Stock	343.9096	343.9669	340.94	341.925	1801142.0
2021-12-29 11:00:00	MSFT	Stock	341.9	342.4	340.57	340.755	1123160.0
2021-12-29 12:00:00	MSFT	Stock	340.78	340.81	339.68	340.72	903543.0
2021-12-29 13:00:00	MSFT	Stock	340.7	341.27	340.5398	341.1773	638151.0
2021-12-29 14:00:00	MSFT	Stock	341.17	341.93	340.79	341.789	779921.0
2021-12-29 15:00:00	MSFT	Stock	341.78	342.81	341.47	341.96	1842096.0
2021-12-29 16:00:00	MSFT	Stock	341.95	342.2674	341.29	341.29	1966785.0
2021-12-29 17:00:00	MSFT	Stock	341.62	341.67	341.41	341.51	2429.0
2021-12-29 18:00:00	MSFT	Stock	341.51	341.88	341.1	341.26	6943.0
2021-12-29 19:00:00	MSFT	Stock	341.16	341.65	340.54	341.65	5445.0
2021-12-29 04:00:00	NVDA	Stock	30.549	30.637	30.528	30.558	90950.0
2021-12-29 05:00:00	NVDA	Stock	30.54	30.576	30.529	30.553	104200.0
2021-12-29 06:00:00	NVDA	Stock	30.52	30.52	30.423	30.453	130890.0
2021-12-29 07:00:00	NVDA	Stock	30.422	30.46	30.203	30.242	549560.0
2021-12-29 08:00:00	NVDA	Stock	30.45	30.46	30.062	30.175	1097620.0
2021-12-29 09:00:00	NVDA	Stock	30.165	30.548	29.768	29.88	43692130.0
2021-12-29 10:00:00	NVDA	Stock	29.8735	29.899	29.366	29.7395	59997250.0
2021-12-29 11:00:00	NVDA	Stock	29.7438	29.929	29.644	29.6855	36902840.0
2021-12-29 12:00:00	NVDA	Stock	29.691	29.791	29.626	29.745	19029900.0
2021-12-29 13:00:00	NVDA	Stock	29.7453	29.91	29.719	29.872	22650730.0
2021-12-29 14:00:00	NVDA	Stock	29.877	30.078	29.845	30.062	26406320.0
2021-12-29 15:00:00	NVDA	Stock	30.062	30.1	29.927	29.997	33183650.0
2021-12-29 16:00:00	NVDA	Stock	29.997	30.029	29.7835	29.909	15993660.0
2021-12-29 17:00:00	NVDA	Stock	29.915	29.947	29.881	29.901	225320.0
2021-12-29 18:00:00	NVDA	Stock	29.945	29.95	29.821	29.83	230660.0
2021-12-29 19:00:00	NVDA	Stock	29.82	29.82	29.701	29.75	358650.0
2021-12-29 07:00:00	AMZN	Stock	171.0	171.0	171.0	171.0	5560.0
2021-12-29 08:00:00	AMZN	Stock	170.997	170.997	170.4555	170.4555	47140.0

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

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