PREVIEW / stock_1hour / 2021-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-05.parquet
  size:    1.4 MB
  rows:    63,678
  symbols: 2,682

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-10-05 04:00:00	AAPL	Stock	139.43	139.79	139.01	139.68	23467.0
2021-10-05 05:00:00	AAPL	Stock	139.67	139.97	139.62	139.81	24185.0
2021-10-05 06:00:00	AAPL	Stock	139.96	139.97	139.31	139.47	30558.0
2021-10-05 07:00:00	AAPL	Stock	139.52	139.81	139.33	139.55	208424.0
2021-10-05 08:00:00	AAPL	Stock	139.56	139.8	139.4	139.7	303284.0
2021-10-05 09:00:00	AAPL	Stock	139.71	140.4	139.36	139.82	9584770.0
2021-10-05 10:00:00	AAPL	Stock	139.82	140.57	139.58	140.5402	11597607.0
2021-10-05 11:00:00	AAPL	Stock	140.54	141.5499	140.49	141.535	11190268.0
2021-10-05 12:00:00	AAPL	Stock	141.5301	142.01	141.33	141.941	8246606.0
2021-10-05 13:00:00	AAPL	Stock	141.95	142.12	141.59	141.995	5918622.0
2021-10-05 14:00:00	AAPL	Stock	141.99	142.24	141.87	141.995	5278994.0
2021-10-05 15:00:00	AAPL	Stock	141.995	142.12	140.91	141.1	10517228.0
2021-10-05 16:00:00	AAPL	Stock	141.1	141.25	140.75	141.0	6934032.0
2021-10-05 17:00:00	AAPL	Stock	141.04	141.08	140.95	141.01	26388.0
2021-10-05 18:00:00	AAPL	Stock	141.05	141.14	141.05	141.14	24808.0
2021-10-05 19:00:00	AAPL	Stock	141.14	141.14	140.81	140.85	58463.0
2021-10-05 04:00:00	MSFT	Stock	283.11	283.96	282.86	283.96	4998.0
2021-10-05 05:00:00	MSFT	Stock	283.74	284.49	283.74	284.49	3257.0
2021-10-05 06:00:00	MSFT	Stock	283.95	284.0	283.3	283.5	7475.0
2021-10-05 07:00:00	MSFT	Stock	283.85	284.41	283.22	284.09	15862.0
2021-10-05 08:00:00	MSFT	Stock	283.11	284.41	283.11	284.1	38736.0
2021-10-05 09:00:00	MSFT	Stock	284.166	286.07	283.73	285.76	2530515.0
2021-10-05 10:00:00	MSFT	Stock	285.785	288.06	285.6208	287.901	2546251.0
2021-10-05 11:00:00	MSFT	Stock	287.88	289.2	287.67	289.19	2151786.0
2021-10-05 12:00:00	MSFT	Stock	289.181	289.98	288.81	289.79	1649755.0
2021-10-05 13:00:00	MSFT	Stock	289.82	290.398	289.54	290.1655	1370427.0
2021-10-05 14:00:00	MSFT	Stock	290.17	290.25	289.33	289.84	1695208.0
2021-10-05 15:00:00	MSFT	Stock	289.84	290.1498	288.47	288.75	3033721.0
2021-10-05 16:00:00	MSFT	Stock	288.75	288.9	288.17	288.59	3737774.0
2021-10-05 17:00:00	MSFT	Stock	288.78	289.1001	288.5	288.57	23319.0
2021-10-05 18:00:00	MSFT	Stock	288.7	289.08	288.7	289.0	6210.0
2021-10-05 19:00:00	MSFT	Stock	289.05	289.05	287.85	288.3	20677.0
2021-10-05 04:00:00	NVDA	Stock	19.8	19.994	19.8	19.994	37450.0
2021-10-05 05:00:00	NVDA	Stock	19.979	20.0	19.952	20.0	37960.0
2021-10-05 06:00:00	NVDA	Stock	20.01	20.01	19.885	19.9	56840.0
2021-10-05 07:00:00	NVDA	Stock	19.9	19.96	19.853	19.96	477890.0
2021-10-05 08:00:00	NVDA	Stock	19.732	19.997	19.732	19.958	831200.0
2021-10-05 09:00:00	NVDA	Stock	19.953	20.166	19.854	20.1335	36452250.0
2021-10-05 10:00:00	NVDA	Stock	20.135	20.44	20.106	20.4285	41900700.0
2021-10-05 11:00:00	NVDA	Stock	20.43	20.477	20.355	20.4725	26416390.0
2021-10-05 12:00:00	NVDA	Stock	20.474	20.616	20.4435	20.614	25900300.0
2021-10-05 13:00:00	NVDA	Stock	20.615	20.616	20.515	20.5848	14406320.0
2021-10-05 14:00:00	NVDA	Stock	20.584	20.648	20.551	20.587	14307190.0
2021-10-05 15:00:00	NVDA	Stock	20.589	20.631	20.427	20.45	28015700.0
2021-10-05 16:00:00	NVDA	Stock	20.45	20.468	20.402	20.448	19380550.0
2021-10-05 17:00:00	NVDA	Stock	20.448	20.46	20.42	20.46	74130.0
2021-10-05 18:00:00	NVDA	Stock	20.442	20.519	20.442	20.505	119060.0
2021-10-05 19:00:00	NVDA	Stock	20.519	20.525	20.426	20.443	161130.0
2021-10-05 04:00:00	AMZN	Stock	160.1	160.1	159.95	159.95	4000.0
2021-10-05 05:00:00	AMZN	Stock	160.2885	160.2885	160.2885	160.2885	2000.0

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

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