PREVIEW / stock_1hour / 2021-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-01.parquet
  size:    1.4 MB
  rows:    65,114
  symbols: 2,781

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-01 04:00:00	AAPL	Stock	152.34	152.4	151.84	151.94	10395.0
2021-09-01 05:00:00	AAPL	Stock	151.93	152.0	151.86	152.0	6211.0
2021-09-01 06:00:00	AAPL	Stock	152.04	152.26	152.04	152.26	10857.0
2021-09-01 07:00:00	AAPL	Stock	152.25	152.59	152.07	152.53	144108.0
2021-09-01 08:00:00	AAPL	Stock	152.4302	152.68	151.451	152.5	454964.0
2021-09-01 09:00:00	AAPL	Stock	152.49	154.82	152.4	154.11	15640550.0
2021-09-01 10:00:00	AAPL	Stock	154.12	154.98	154.05	154.53	12386284.0
2021-09-01 11:00:00	AAPL	Stock	154.54	154.95	154.39	154.5	7053859.0
2021-09-01 12:00:00	AAPL	Stock	154.5001	154.62	153.65	153.665	6347517.0
2021-09-01 13:00:00	AAPL	Stock	153.66	154.005	153.55	153.795	5058580.0
2021-09-01 14:00:00	AAPL	Stock	153.7935	153.8	152.78	152.89	6736282.0
2021-09-01 15:00:00	AAPL	Stock	152.8802	153.175	152.34	152.54	11439147.0
2021-09-01 16:00:00	AAPL	Stock	152.51	152.7168	152.49	152.54	5047740.0
2021-09-01 17:00:00	AAPL	Stock	152.57	153.15	152.57	152.88	133413.0
2021-09-01 18:00:00	AAPL	Stock	152.99	153.05	152.9	152.97	68547.0
2021-09-01 19:00:00	AAPL	Stock	152.98	153.25	152.94	153.16	66598.0
2021-09-01 04:00:00	MSFT	Stock	303.1	303.17	302.79	302.99	3456.0
2021-09-01 05:00:00	MSFT	Stock	303.0	303.0	302.65	303.0	7393.0
2021-09-01 06:00:00	MSFT	Stock	303.09	303.38	303.09	303.34	4799.0
2021-09-01 07:00:00	MSFT	Stock	303.39	303.48	303.01	303.06	9819.0
2021-09-01 08:00:00	MSFT	Stock	303.2	303.3499	302.83	302.9	17691.0
2021-09-01 09:00:00	MSFT	Stock	302.88	305.06	302.6	304.59	2434166.0
2021-09-01 10:00:00	MSFT	Stock	304.6	305.19	303.3	303.57	1680087.0
2021-09-01 11:00:00	MSFT	Stock	303.6	304.15	303.26	303.38	1160961.0
2021-09-01 12:00:00	MSFT	Stock	303.36	303.63	302.72	302.73	1155723.0
2021-09-01 13:00:00	MSFT	Stock	302.72	303.42	302.6	303.26	914563.0
2021-09-01 14:00:00	MSFT	Stock	303.26	303.3617	302.46	302.755	973696.0
2021-09-01 15:00:00	MSFT	Stock	302.76	302.85	301.49	301.8538	2276881.0
2021-09-01 16:00:00	MSFT	Stock	301.85	301.85	301.59	301.59	2806716.0
2021-09-01 17:00:00	MSFT	Stock	301.63	301.7	301.5	301.62	10809.0
2021-09-01 18:00:00	MSFT	Stock	301.64	301.75	301.6	301.75	3756.0
2021-09-01 19:00:00	MSFT	Stock	301.75	301.95	301.65	301.95	10848.0
2021-09-01 04:00:00	NVDA	Stock	22.501	22.501	22.345	22.356	49280.0
2021-09-01 05:00:00	NVDA	Stock	22.37	22.441	22.37	22.415	29620.0
2021-09-01 06:00:00	NVDA	Stock	22.415	22.415	22.415	22.415	1300.0
2021-09-01 07:00:00	NVDA	Stock	22.41	22.543	22.41	22.542	248790.0
2021-09-01 08:00:00	NVDA	Stock	22.385	22.545	22.3291	22.515	556620.0
2021-09-01 09:00:00	NVDA	Stock	22.512	22.685	22.3565	22.5917	28112290.0
2021-09-01 10:00:00	NVDA	Stock	22.595	22.697	22.51	22.606	23400400.0
2021-09-01 11:00:00	NVDA	Stock	22.6079	22.642	22.447	22.4533	19798610.0
2021-09-01 12:00:00	NVDA	Stock	22.452	22.534	22.408	22.51	20097320.0
2021-09-01 13:00:00	NVDA	Stock	22.5106	22.5336	22.439	22.484	10580980.0
2021-09-01 14:00:00	NVDA	Stock	22.48	22.51	22.367	22.416	11258070.0
2021-09-01 15:00:00	NVDA	Stock	22.414	22.56	22.3891	22.442	24166660.0
2021-09-01 16:00:00	NVDA	Stock	22.441	22.461	22.407	22.407	15048320.0
2021-09-01 17:00:00	NVDA	Stock	22.408	22.415	22.4	22.41	125540.0
2021-09-01 18:00:00	NVDA	Stock	22.412	22.426	22.412	22.417	68810.0
2021-09-01 19:00:00	NVDA	Stock	22.413	22.42	22.403	22.415	96250.0
2021-09-01 05:00:00	AMZN	Stock	173.725	173.725	173.725	173.725	2000.0
2021-09-01 06:00:00	AMZN	Stock	173.725	173.99	173.725	173.99	7500.0

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

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