PREVIEW / stock_1hour / 2006-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-23.parquet
  size:    596 KB
  rows:    28,616
  symbols: 2,301

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
2006-06-23 07:00:00	AAPL	Stock	2.1329	2.1329	2.1329	2.1329	2800.0
2006-06-23 08:00:00	AAPL	Stock	2.1357	2.1425	2.1307	2.1343	1515864.0
2006-06-23 09:00:00	AAPL	Stock	2.1343	2.1489	2.1204	2.1382	110003712.0
2006-06-23 10:00:00	AAPL	Stock	2.1379	2.1382	2.1125	2.1193	135220568.0
2006-06-23 11:00:00	AAPL	Stock	2.1193	2.12	2.1021	2.1039	81306764.0
2006-06-23 12:00:00	AAPL	Stock	2.1039	2.1404	2.1021	2.1332	94054744.0
2006-06-23 13:00:00	AAPL	Stock	2.1336	2.1414	2.1254	2.1282	61524456.0
2006-06-23 14:00:00	AAPL	Stock	2.1286	2.1286	2.1061	2.1086	55081152.0
2006-06-23 15:00:00	AAPL	Stock	2.1085	2.1143	2.0979	2.0982	86748480.0
2006-06-23 16:00:00	AAPL	Stock	2.1007	2.1014	2.0943	2.0946	4625740.0
2006-06-23 17:00:00	AAPL	Stock	2.0975	2.1011	2.0975	2.0975	22721804.0
2006-06-23 18:00:00	AAPL	Stock	2.1009	2.1009	2.0993	2.1	234220.0
2006-06-23 08:00:00	MSFT	Stock	22.9	22.93	22.9	22.93	16418.0
2006-06-23 09:00:00	MSFT	Stock	22.91	22.91	22.7	22.72	5682810.0
2006-06-23 10:00:00	MSFT	Stock	22.72	22.83	22.71	22.82	4847575.0
2006-06-23 11:00:00	MSFT	Stock	22.82	22.83	22.73	22.75	6978197.0
2006-06-23 12:00:00	MSFT	Stock	22.75	22.86	22.74	22.81	9263637.0
2006-06-23 13:00:00	MSFT	Stock	22.8	22.82	22.74	22.76	5118363.0
2006-06-23 14:00:00	MSFT	Stock	22.76	22.82	22.55	22.558	10919527.0
2006-06-23 15:00:00	MSFT	Stock	22.56	22.7	22.5	22.51	15630314.0
2006-06-23 16:00:00	MSFT	Stock	22.5	22.53	22.5	22.5	144504.0
2006-06-23 17:00:00	MSFT	Stock	22.5	22.53	22.5	22.5	28004.0
2006-06-23 18:00:00	MSFT	Stock	22.53	22.53	22.53	22.53	2000.0
2006-06-23 08:00:00	NVDA	Stock	0.3383	0.3383	0.3383	0.3383	45000.0
2006-06-23 09:00:00	NVDA	Stock	0.3433	0.3438	0.3345	0.3372	25104180.0
2006-06-23 10:00:00	NVDA	Stock	0.3372	0.3408	0.3355	0.3401	61976280.0
2006-06-23 11:00:00	NVDA	Stock	0.34	0.341	0.3382	0.3388	36962460.0
2006-06-23 12:00:00	NVDA	Stock	0.3388	0.3438	0.3388	0.3438	57949200.0
2006-06-23 13:00:00	NVDA	Stock	0.3438	0.3455	0.3387	0.3438	36481860.0
2006-06-23 14:00:00	NVDA	Stock	0.3438	0.3438	0.3398	0.3402	37673040.0
2006-06-23 15:00:00	NVDA	Stock	0.3402	0.3405	0.3385	0.3385	61438920.0
2006-06-23 16:00:00	NVDA	Stock	0.3387	0.3388	0.3387	0.3387	65340.0
2006-06-23 17:00:00	NVDA	Stock	0.3385	0.3385	0.3385	0.3385	28320.0
2006-06-23 08:00:00	AMZN	Stock	1.825	1.825	1.825	1.825	2480.0
2006-06-23 09:00:00	AMZN	Stock	1.8185	1.8245	1.806	1.818	10686860.0
2006-06-23 10:00:00	AMZN	Stock	1.818	1.83	1.8125	1.826	12605120.0
2006-06-23 11:00:00	AMZN	Stock	1.8265	1.8265	1.805	1.805	10515140.0
2006-06-23 12:00:00	AMZN	Stock	1.8055	1.8245	1.801	1.821	12552660.0
2006-06-23 13:00:00	AMZN	Stock	1.821	1.826	1.817	1.821	4874060.0
2006-06-23 14:00:00	AMZN	Stock	1.82	1.825	1.8145	1.8175	6259200.0
2006-06-23 15:00:00	AMZN	Stock	1.8175	1.8325	1.815	1.8265	16749940.0
2006-06-23 16:00:00	AMZN	Stock	1.825	1.828	1.825	1.8255	13300.0
2006-06-23 17:00:00	AMZN	Stock	1.8274	1.8274	1.8274	1.8274	7540.0
2006-06-23 08:00:00	CL	Stock	30.15	30.15	30.15	30.15	23200.0
2006-06-23 09:00:00	CL	Stock	30.0	30.15	30.0	30.04	223000.0
2006-06-23 10:00:00	CL	Stock	30.045	30.14	29.98	30.14	333800.0
2006-06-23 11:00:00	CL	Stock	30.14	30.14	29.97	30.03	311600.0
2006-06-23 12:00:00	CL	Stock	30.025	30.24	30.02	30.13	317200.0
2006-06-23 13:00:00	CL	Stock	30.115	30.185	30.09	30.15	151800.0
2006-06-23 14:00:00	CL	Stock	30.14	30.155	30.0925	30.12	458200.0

> showing 50 of 28,616 rows — these rows as CSV

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