PREVIEW / stock_1hour / 2021-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-27.parquet
  size:    1.4 MB
  rows:    64,685
  symbols: 2,844

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-27 04:00:00	AAPL	Stock	148.5	148.71	148.03	148.7	29843.0
2021-07-27 05:00:00	AAPL	Stock	148.61	148.95	148.3	148.95	24174.0
2021-07-27 06:00:00	AAPL	Stock	148.82	149.1	148.82	149.05	15699.0
2021-07-27 07:00:00	AAPL	Stock	149.07	149.53	149.05	149.27	210409.0
2021-07-27 08:00:00	AAPL	Stock	149.27	149.5	148.618	149.3399	450944.0
2021-07-27 09:00:00	AAPL	Stock	149.3399	149.3501	148.25	148.65	10115644.0
2021-07-27 10:00:00	AAPL	Stock	148.645	148.73	146.6	147.42	15064358.0
2021-07-27 11:00:00	AAPL	Stock	147.41	147.66	146.17	146.355	10520115.0
2021-07-27 12:00:00	AAPL	Stock	146.35	146.47	145.55	146.06	9495747.0
2021-07-27 13:00:00	AAPL	Stock	146.06	146.3	145.7189	145.98	7046856.0
2021-07-27 14:00:00	AAPL	Stock	145.9794	147.07	145.92	147.06	8716369.0
2021-07-27 15:00:00	AAPL	Stock	147.065	147.32	146.28	146.78	13632146.0
2021-07-27 16:00:00	AAPL	Stock	146.77	149.32	145.11	145.49	13382460.0
2021-07-27 17:00:00	AAPL	Stock	145.48	146.77	142.5	144.42	2508249.0
2021-07-27 18:00:00	AAPL	Stock	144.4	145.1	144.11	144.25	892328.0
2021-07-27 19:00:00	AAPL	Stock	144.22	144.44	143.54	143.7	548352.0
2021-07-27 04:00:00	MSFT	Stock	288.96	289.01	288.5	288.7	2108.0
2021-07-27 05:00:00	MSFT	Stock	288.76	288.84	288.5	288.67	7110.0
2021-07-27 06:00:00	MSFT	Stock	288.92	289.2	288.92	289.15	1883.0
2021-07-27 07:00:00	MSFT	Stock	289.33	289.85	289.3	289.65	29757.0
2021-07-27 08:00:00	MSFT	Stock	289.4	289.9	289.05	289.66	41169.0
2021-07-27 09:00:00	MSFT	Stock	289.67	289.79	287.7183	288.67	2128417.0
2021-07-27 10:00:00	MSFT	Stock	288.64	288.77	284.71	285.45	3129599.0
2021-07-27 11:00:00	MSFT	Stock	285.42	286.0	283.805	285.1	4012915.0
2021-07-27 12:00:00	MSFT	Stock	285.075	285.41	284.11	284.32	2037066.0
2021-07-27 13:00:00	MSFT	Stock	284.32	284.79	282.95	283.62	2188694.0
2021-07-27 14:00:00	MSFT	Stock	283.62	286.27	283.4834	286.24	2075091.0
2021-07-27 15:00:00	MSFT	Stock	286.26	287.15	285.51	287.0	3642367.0
2021-07-27 16:00:00	MSFT	Stock	286.54	292.0	276.69	278.75	4397106.0
2021-07-27 17:00:00	MSFT	Stock	278.9699	279.75	278.01	279.4	219710.0
2021-07-27 18:00:00	MSFT	Stock	279.49	291.73	278.6	288.75	1134297.0
2021-07-27 19:00:00	MSFT	Stock	288.88	289.05	287.0	287.0	139739.0
2021-07-27 04:00:00	NVDA	Stock	19.188	19.188	19.074	19.1	67780.0
2021-07-27 05:00:00	NVDA	Stock	19.068	19.157	19.058	19.157	40420.0
2021-07-27 06:00:00	NVDA	Stock	19.167	19.199	19.099	19.199	81990.0
2021-07-27 07:00:00	NVDA	Stock	19.198	19.227	19.155	19.171	172730.0
2021-07-27 08:00:00	NVDA	Stock	19.1602	19.3422	19.15	19.2	359020.0
2021-07-27 09:00:00	NVDA	Stock	19.2	19.622	19.153	19.307	33147930.0
2021-07-27 10:00:00	NVDA	Stock	19.3011	19.309	18.944	19.09	36842650.0
2021-07-27 11:00:00	NVDA	Stock	19.087	19.14	18.874	18.947	24462590.0
2021-07-27 12:00:00	NVDA	Stock	18.944	18.9763	18.777	18.891	17409120.0
2021-07-27 13:00:00	NVDA	Stock	18.8882	18.911	18.741	18.829	15441530.0
2021-07-27 14:00:00	NVDA	Stock	18.832	19.107	18.827	19.096	18068080.0
2021-07-27 15:00:00	NVDA	Stock	19.1	19.214	19.0725	19.21	25707000.0
2021-07-27 16:00:00	NVDA	Stock	19.208	19.244	19.018	19.075	13777090.0
2021-07-27 17:00:00	NVDA	Stock	19.09	19.095	19.015	19.02	168120.0
2021-07-27 18:00:00	NVDA	Stock	19.024	19.12	19.016	19.1	303460.0
2021-07-27 19:00:00	NVDA	Stock	19.117	19.169	19.085	19.12	180460.0
2021-07-27 04:00:00	AMZN	Stock	184.5	184.5	184.5	184.5	2000.0
2021-07-27 07:00:00	AMZN	Stock	184.7995	185.1185	184.763	185.1	43280.0

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

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