PREVIEW / stock_1hour / 2021-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-22.parquet
  size:    1.4 MB
  rows:    64,076
  symbols: 2,846

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-07-22 04:00:00	AAPL	Stock	145.64	145.85	145.6	145.65	6517.0
2021-07-22 05:00:00	AAPL	Stock	145.66	145.79	145.62	145.7	5005.0
2021-07-22 06:00:00	AAPL	Stock	145.66	145.7	145.51	145.7	6055.0
2021-07-22 07:00:00	AAPL	Stock	145.69	145.9	145.55	145.68	126499.0
2021-07-22 08:00:00	AAPL	Stock	145.71	146.2	145.6	146.11	424300.0
2021-07-22 09:00:00	AAPL	Stock	146.12	147.0	145.81	146.83	11374553.0
2021-07-22 10:00:00	AAPL	Stock	146.83	147.97	146.83	147.74	13124560.0
2021-07-22 11:00:00	AAPL	Stock	147.735	148.195	147.13	147.331	10076788.0
2021-07-22 12:00:00	AAPL	Stock	147.33	147.44	146.66	147.21	6533722.0
2021-07-22 13:00:00	AAPL	Stock	147.2	147.67	147.152	147.2211	4779705.0
2021-07-22 14:00:00	AAPL	Stock	147.225	147.3699	146.94	147.12	4659189.0
2021-07-22 15:00:00	AAPL	Stock	147.129	147.15	146.48	146.8	8044230.0
2021-07-22 16:00:00	AAPL	Stock	146.79	147.09	146.71	147.09	4040570.0
2021-07-22 17:00:00	AAPL	Stock	147.07	147.19	147.07	147.15	115419.0
2021-07-22 18:00:00	AAPL	Stock	147.14	147.19	147.01	147.09	25428.0
2021-07-22 19:00:00	AAPL	Stock	147.12	147.25	147.0	147.25	64578.0
2021-07-22 04:00:00	MSFT	Stock	282.0	282.58	281.6	282.5	3208.0
2021-07-22 05:00:00	MSFT	Stock	282.88	282.89	282.6	282.6	1882.0
2021-07-22 06:00:00	MSFT	Stock	282.62	282.72	282.2	282.3	3010.0
2021-07-22 07:00:00	MSFT	Stock	282.48	284.44	282.48	284.0	54868.0
2021-07-22 08:00:00	MSFT	Stock	282.65	284.48	282.3	283.68	52203.0
2021-07-22 09:00:00	MSFT	Stock	283.7	286.06	283.42	285.24	3022407.0
2021-07-22 10:00:00	MSFT	Stock	285.24	286.41	284.77	285.9163	2577487.0
2021-07-22 11:00:00	MSFT	Stock	285.919	286.32	284.8501	285.35	1833798.0
2021-07-22 12:00:00	MSFT	Stock	285.385	285.41	284.48	284.9063	1301600.0
2021-07-22 13:00:00	MSFT	Stock	284.91	285.13	284.63	284.97	992428.0
2021-07-22 14:00:00	MSFT	Stock	284.98	286.42	284.77	286.18	1794940.0
2021-07-22 15:00:00	MSFT	Stock	286.18	286.23	285.64	286.16	2958136.0
2021-07-22 16:00:00	MSFT	Stock	286.15	286.95	286.0	286.95	2931920.0
2021-07-22 17:00:00	MSFT	Stock	286.93	287.88	286.83	287.3	35004.0
2021-07-22 18:00:00	MSFT	Stock	287.42	287.85	287.35	287.8	13491.0
2021-07-22 19:00:00	MSFT	Stock	287.65	287.8	287.6	287.75	14164.0
2021-07-22 04:00:00	NVDA	Stock	19.55	19.593	19.478	19.55	163430.0
2021-07-22 05:00:00	NVDA	Stock	19.565	19.61	19.55	19.596	138680.0
2021-07-22 06:00:00	NVDA	Stock	19.589	19.589	19.541	19.56	92360.0
2021-07-22 07:00:00	NVDA	Stock	19.545	19.659	19.545	19.64	2055940.0
2021-07-22 08:00:00	NVDA	Stock	19.621	19.66	19.505	19.565	2889010.0
2021-07-22 09:00:00	NVDA	Stock	19.563	19.887	19.426	19.5615	65042900.0
2021-07-22 10:00:00	NVDA	Stock	19.566	19.645	19.393	19.442	40589000.0
2021-07-22 11:00:00	NVDA	Stock	19.4408	19.511	19.276	19.466	32513360.0
2021-07-22 12:00:00	NVDA	Stock	19.4748	19.493	19.295	19.425	23386370.0
2021-07-22 13:00:00	NVDA	Stock	19.4305	19.482	19.392	19.4155	18677830.0
2021-07-22 14:00:00	NVDA	Stock	19.413	19.534	19.369	19.5332	21720410.0
2021-07-22 15:00:00	NVDA	Stock	19.534	19.623	19.485	19.595	36423650.0
2021-07-22 16:00:00	NVDA	Stock	19.596	19.611	19.545	19.595	11328190.0
2021-07-22 17:00:00	NVDA	Stock	19.594	19.595	19.563	19.58	194040.0
2021-07-22 18:00:00	NVDA	Stock	19.579	19.59	19.575	19.576	167820.0
2021-07-22 19:00:00	NVDA	Stock	19.576	19.585	19.535	19.55	168540.0
2021-07-22 06:00:00	AMZN	Stock	179.5075	179.5075	179.5	179.5	6000.0
2021-07-22 07:00:00	AMZN	Stock	179.45	179.55	179.3255	179.4075	46980.0

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

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