PREVIEW / stock_1hour / 2021-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-16.parquet
  size:    1.4 MB
  rows:    63,820
  symbols: 2,737

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-09-16 04:00:00	AAPL	Stock	148.97	148.98	148.56	148.67	9902.0
2021-09-16 05:00:00	AAPL	Stock	148.7	148.7	148.52	148.52	2554.0
2021-09-16 06:00:00	AAPL	Stock	148.53	148.66	148.51	148.64	7002.0
2021-09-16 07:00:00	AAPL	Stock	148.65	148.74	148.44	148.55	54204.0
2021-09-16 08:00:00	AAPL	Stock	148.6465	148.75	148.25	148.72	396052.0
2021-09-16 09:00:00	AAPL	Stock	148.74	148.97	147.71	147.9099	8976315.0
2021-09-16 10:00:00	AAPL	Stock	147.9	147.99	147.3	147.6899	10496080.0
2021-09-16 11:00:00	AAPL	Stock	147.68	147.85	147.221	147.7101	7422647.0
2021-09-16 12:00:00	AAPL	Stock	147.71	148.25	147.64	148.1	5637156.0
2021-09-16 13:00:00	AAPL	Stock	148.1	148.325	147.69	148.21	5015230.0
2021-09-16 14:00:00	AAPL	Stock	148.2082	148.4876	148.03	148.425	5650105.0
2021-09-16 15:00:00	AAPL	Stock	148.43	148.94	148.4	148.85	10161712.0
2021-09-16 16:00:00	AAPL	Stock	148.79	148.85	148.61	148.7	7033779.0
2021-09-16 17:00:00	AAPL	Stock	148.7421	148.75	148.67	148.71	15629.0
2021-09-16 18:00:00	AAPL	Stock	148.72	148.72	148.67	148.67	20159.0
2021-09-16 19:00:00	AAPL	Stock	148.67	148.7	148.58	148.6	38335.0
2021-09-16 04:00:00	MSFT	Stock	305.31	305.31	304.9	304.9	2725.0
2021-09-16 05:00:00	MSFT	Stock	304.9	304.91	304.49	304.5	2513.0
2021-09-16 06:00:00	MSFT	Stock	304.51	304.51	304.46	304.5	948.0
2021-09-16 07:00:00	MSFT	Stock	304.53	304.82	304.01	304.21	5118.0
2021-09-16 08:00:00	MSFT	Stock	304.5562	305.582	303.61	304.02	32682.0
2021-09-16 09:00:00	MSFT	Stock	304.0224	304.38	302.56	302.775	1768153.0
2021-09-16 10:00:00	MSFT	Stock	302.75	302.82	300.76	301.54	2190758.0
2021-09-16 11:00:00	MSFT	Stock	301.52	302.06	301.2	301.82	1240981.0
2021-09-16 12:00:00	MSFT	Stock	301.83	302.71	301.65	302.5	1015946.0
2021-09-16 13:00:00	MSFT	Stock	302.49	303.47	302.26	303.34	874178.0
2021-09-16 14:00:00	MSFT	Stock	303.35	304.03	303.19	303.92	964479.0
2021-09-16 15:00:00	MSFT	Stock	303.93	305.31	303.82	305.24	2876443.0
2021-09-16 16:00:00	MSFT	Stock	305.22	305.25	304.61	305.19	2688524.0
2021-09-16 17:00:00	MSFT	Stock	305.05	305.22	304.8	304.92	230812.0
2021-09-16 18:00:00	MSFT	Stock	304.92	304.94	304.56	304.94	2985.0
2021-09-16 19:00:00	MSFT	Stock	304.99	305.0	304.5	305.0	11419.0
2021-09-16 04:00:00	NVDA	Stock	22.332	22.345	22.332	22.332	15210.0
2021-09-16 05:00:00	NVDA	Stock	22.28	22.28	22.217	22.217	22210.0
2021-09-16 06:00:00	NVDA	Stock	22.22	22.232	22.22	22.232	2340.0
2021-09-16 07:00:00	NVDA	Stock	22.276	22.295	22.225	22.225	90460.0
2021-09-16 08:00:00	NVDA	Stock	22.28	22.295	22.186	22.235	411600.0
2021-09-16 09:00:00	NVDA	Stock	22.237	22.24	21.981	22.053	22219550.0
2021-09-16 10:00:00	NVDA	Stock	22.044	22.12	21.968	22.0661	21263850.0
2021-09-16 11:00:00	NVDA	Stock	22.065	22.115	21.927	21.983	14979080.0
2021-09-16 12:00:00	NVDA	Stock	21.982	22.066	21.979	22.045	9308750.0
2021-09-16 13:00:00	NVDA	Stock	22.048	22.181	22.01	22.158	11508470.0
2021-09-16 14:00:00	NVDA	Stock	22.159	22.224	22.1169	22.184	13175790.0
2021-09-16 15:00:00	NVDA	Stock	22.1865	22.277	22.18	22.243	16167340.0
2021-09-16 16:00:00	NVDA	Stock	22.242	22.242	22.2	22.22	11722520.0
2021-09-16 17:00:00	NVDA	Stock	22.22	22.242	22.2	22.203	1460920.0
2021-09-16 18:00:00	NVDA	Stock	22.225	22.225	22.203	22.214	16400.0
2021-09-16 19:00:00	NVDA	Stock	22.208	22.224	22.19	22.193	40550.0
2021-09-16 08:00:00	AMZN	Stock	173.4	173.4	172.901	173.1	115580.0
2021-09-16 09:00:00	AMZN	Stock	172.95	173.857	172.3072	172.8	3930020.0

> showing 50 of 63,820 rows — these rows as CSV

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