PREVIEW / stock_1hour / 2021-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-06.parquet
  size:    1.4 MB
  rows:    65,074
  symbols: 2,690

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-06 04:00:00	AAPL	Stock	139.48	139.5	138.97	139.1	64108.0
2021-10-06 05:00:00	AAPL	Stock	139.08	139.14	138.75	138.85	43181.0
2021-10-06 06:00:00	AAPL	Stock	138.85	139.01	138.68	138.99	36533.0
2021-10-06 07:00:00	AAPL	Stock	138.92	139.49	138.89	139.45	266898.0
2021-10-06 08:00:00	AAPL	Stock	139.1296	141.1495	138.9	141.1495	404531.0
2021-10-06 09:00:00	AAPL	Stock	139.499	140.18	138.96	139.12	11797200.0
2021-10-06 10:00:00	AAPL	Stock	139.12	140.68	138.37	140.3	14457198.0
2021-10-06 11:00:00	AAPL	Stock	140.285	140.455	139.585	140.3901	8055431.0
2021-10-06 12:00:00	AAPL	Stock	140.39	140.415	139.715	139.85	6844211.0
2021-10-06 13:00:00	AAPL	Stock	139.85	140.92	139.56	140.9111	8246051.0
2021-10-06 14:00:00	AAPL	Stock	140.91	141.66	140.72	141.165	7090029.0
2021-10-06 15:00:00	AAPL	Stock	141.15	142.15	141.09	141.97	9813990.0
2021-10-06 16:00:00	AAPL	Stock	141.98	142.17	141.86	142.14	6341527.0
2021-10-06 17:00:00	AAPL	Stock	142.13	142.19	142.0	142.13	172764.0
2021-10-06 18:00:00	AAPL	Stock	142.15	142.5	142.13	142.49	61015.0
2021-10-06 19:00:00	AAPL	Stock	142.5	142.77	142.4	142.49	136026.0
2021-10-06 04:00:00	MSFT	Stock	285.11	285.33	284.25	284.6	11433.0
2021-10-06 05:00:00	MSFT	Stock	284.67	284.67	283.69	284.0	10777.0
2021-10-06 06:00:00	MSFT	Stock	284.13	284.59	283.92	283.92	10432.0
2021-10-06 07:00:00	MSFT	Stock	284.35	285.44	284.15	285.39	55676.0
2021-10-06 08:00:00	MSFT	Stock	284.3501	286.61	284.35	286.35	58328.0
2021-10-06 09:00:00	MSFT	Stock	286.4	288.4886	285.5093	286.935	2316988.0
2021-10-06 10:00:00	MSFT	Stock	286.93	290.88	285.91	289.85	3451442.0
2021-10-06 11:00:00	MSFT	Stock	289.87	290.08	288.51	289.81	1714633.0
2021-10-06 12:00:00	MSFT	Stock	289.81	289.83	288.58	289.14	1233188.0
2021-10-06 13:00:00	MSFT	Stock	289.13	291.98	288.46	291.7099	2181126.0
2021-10-06 14:00:00	MSFT	Stock	291.72	292.85	291.25	291.9	2215309.0
2021-10-06 15:00:00	MSFT	Stock	291.87	293.63	291.47	293.07	3313987.0
2021-10-06 16:00:00	MSFT	Stock	293.11	293.69	293.05	293.69	3695419.0
2021-10-06 17:00:00	MSFT	Stock	293.52	293.74	293.11	293.55	49648.0
2021-10-06 18:00:00	MSFT	Stock	293.5	294.49	293.4	294.03	11721.0
2021-10-06 19:00:00	MSFT	Stock	294.27	295.0	294.23	294.5	12274.0
2021-10-06 04:00:00	NVDA	Stock	20.063	20.1	20.001	20.024	155540.0
2021-10-06 05:00:00	NVDA	Stock	20.022	20.022	19.855	19.887	97600.0
2021-10-06 06:00:00	NVDA	Stock	19.919	19.981	19.9	19.91	86050.0
2021-10-06 07:00:00	NVDA	Stock	19.939	20.046	19.908	20.044	457780.0
2021-10-06 08:00:00	NVDA	Stock	20.021	20.13	19.928	20.104	1543250.0
2021-10-06 09:00:00	NVDA	Stock	20.0765	20.56	20.0765	20.32	35223190.0
2021-10-06 10:00:00	NVDA	Stock	20.322	20.68	20.19	20.5683	47027090.0
2021-10-06 11:00:00	NVDA	Stock	20.567	20.632	20.375	20.629	25367480.0
2021-10-06 12:00:00	NVDA	Stock	20.631	20.6336	20.429	20.46	16674010.0
2021-10-06 13:00:00	NVDA	Stock	20.463	20.617	20.3649	20.564	20724880.0
2021-10-06 14:00:00	NVDA	Stock	20.565	20.695	20.539	20.582	21611390.0
2021-10-06 15:00:00	NVDA	Stock	20.585	20.72	20.498	20.7	27857210.0
2021-10-06 16:00:00	NVDA	Stock	20.7	20.753	20.65	20.74	22001150.0
2021-10-06 17:00:00	NVDA	Stock	20.745	20.814	20.7	20.793	761130.0
2021-10-06 18:00:00	NVDA	Stock	20.797	20.938	20.797	20.913	309980.0
2021-10-06 19:00:00	NVDA	Stock	20.915	20.945	20.82	20.88	320720.0
2021-10-06 04:00:00	AMZN	Stock	159.2275	159.45	159.2275	159.25	8000.0
2021-10-06 06:00:00	AMZN	Stock	159.0055	159.0055	159.0025	159.0025	4000.0

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

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