PREVIEW / stock_1hour / 2021-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-05.parquet
  size:    1.4 MB
  rows:    65,042
  symbols: 2,823

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-08-05 04:00:00	AAPL	Stock	146.9	146.93	146.79	146.83	10965.0
2021-08-05 05:00:00	AAPL	Stock	146.83	147.06	146.82	147.06	4082.0
2021-08-05 06:00:00	AAPL	Stock	147.0	147.08	146.98	147.01	2752.0
2021-08-05 07:00:00	AAPL	Stock	147.03	147.25	147.01	147.22	36807.0
2021-08-05 08:00:00	AAPL	Stock	147.0699	147.4	147.02	147.1901	147725.0
2021-08-05 09:00:00	AAPL	Stock	147.19	147.24	146.17	147.055	8311782.0
2021-08-05 10:00:00	AAPL	Stock	147.06	147.585	146.7906	147.49	7406794.0
2021-08-05 11:00:00	AAPL	Stock	147.4899	147.84	147.3	147.46	4918159.0
2021-08-05 12:00:00	AAPL	Stock	147.465	147.545	147.17	147.2576	3356630.0
2021-08-05 13:00:00	AAPL	Stock	147.25	147.38	147.11	147.353	2498727.0
2021-08-05 14:00:00	AAPL	Stock	147.36	147.46	147.0419	147.0545	3482335.0
2021-08-05 15:00:00	AAPL	Stock	147.055	147.19	146.73	147.06	6601041.0
2021-08-05 16:00:00	AAPL	Stock	147.06	147.1	146.92	146.96	3391861.0
2021-08-05 17:00:00	AAPL	Stock	146.95	147.06	146.92	146.94	35789.0
2021-08-05 18:00:00	AAPL	Stock	146.93	146.97	146.9001	146.91	20380.0
2021-08-05 19:00:00	AAPL	Stock	146.92	146.96	146.86	146.9	28179.0
2021-08-05 04:00:00	MSFT	Stock	287.14	287.14	286.5	286.5	433.0
2021-08-05 05:00:00	MSFT	Stock	286.15	286.51	286.15	286.42	1045.0
2021-08-05 06:00:00	MSFT	Stock	286.75	287.0	286.75	287.0	470.0
2021-08-05 07:00:00	MSFT	Stock	287.0	287.25	286.66	287.15	7981.0
2021-08-05 08:00:00	MSFT	Stock	286.955	287.2001	286.6001	286.73	14359.0
2021-08-05 09:00:00	MSFT	Stock	286.79	287.8299	286.1	287.7239	1356212.0
2021-08-05 10:00:00	MSFT	Stock	287.7	288.61	287.57	288.4465	1674443.0
2021-08-05 11:00:00	MSFT	Stock	288.4584	288.82	288.0	288.2	1289156.0
2021-08-05 12:00:00	MSFT	Stock	288.21	288.49	287.95	288.12	844570.0
2021-08-05 13:00:00	MSFT	Stock	288.115	288.71	288.04	288.6	792791.0
2021-08-05 14:00:00	MSFT	Stock	288.6	289.06	288.59	288.95	989718.0
2021-08-05 15:00:00	MSFT	Stock	288.96	289.63	288.64	289.55	1889698.0
2021-08-05 16:00:00	MSFT	Stock	289.52	289.66	289.4	289.6	1947506.0
2021-08-05 17:00:00	MSFT	Stock	289.6	289.74	289.56	289.6	8048.0
2021-08-05 18:00:00	MSFT	Stock	289.6	289.73	289.42	289.5	1782.0
2021-08-05 19:00:00	MSFT	Stock	289.5	289.6	289.31	289.34	2981.0
2021-08-05 04:00:00	NVDA	Stock	20.284	20.365	20.284	20.365	14970.0
2021-08-05 05:00:00	NVDA	Stock	20.36	20.423	20.35	20.422	56030.0
2021-08-05 06:00:00	NVDA	Stock	20.421	20.421	20.369	20.373	48770.0
2021-08-05 07:00:00	NVDA	Stock	20.386	20.45	20.313	20.4	437460.0
2021-08-05 08:00:00	NVDA	Stock	20.376	20.472	20.343	20.46	650000.0
2021-08-05 09:00:00	NVDA	Stock	20.464	20.733	20.457	20.64	37814670.0
2021-08-05 10:00:00	NVDA	Stock	20.644	20.667	20.342	20.5495	29497740.0
2021-08-05 11:00:00	NVDA	Stock	20.551	20.6161	20.4785	20.513	20625360.0
2021-08-05 12:00:00	NVDA	Stock	20.525	20.65	20.5065	20.5895	13983050.0
2021-08-05 13:00:00	NVDA	Stock	20.587	20.65	20.55	20.6297	12547660.0
2021-08-05 14:00:00	NVDA	Stock	20.6285	20.638	20.56	20.633	11586470.0
2021-08-05 15:00:00	NVDA	Stock	20.634	20.652	20.538	20.637	23153850.0
2021-08-05 16:00:00	NVDA	Stock	20.637	20.648	20.59	20.626	11880430.0
2021-08-05 17:00:00	NVDA	Stock	20.63	20.685	20.626	20.68	271760.0
2021-08-05 18:00:00	NVDA	Stock	20.685	20.685	20.631	20.631	79620.0
2021-08-05 19:00:00	NVDA	Stock	20.63	20.66	20.595	20.613	224320.0
2021-08-05 06:00:00	AMZN	Stock	168.131	168.131	168.131	168.131	2000.0
2021-08-05 07:00:00	AMZN	Stock	168.05	168.05	167.9125	168.0455	19380.0

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

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