PREVIEW / stock_1hour / 2006-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-06.parquet
  size:    607 KB
  rows:    29,200
  symbols: 2,278

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-06 08:00:00	AAPL	Stock	2.1604	2.1632	2.155	2.1571	2021068.0
2006-06-06 09:00:00	AAPL	Stock	2.1571	2.1654	2.1268	2.1268	103075784.0
2006-06-06 10:00:00	AAPL	Stock	2.1271	2.1507	2.1218	2.13	143173044.0
2006-06-06 11:00:00	AAPL	Stock	2.13	2.1339	2.1161	2.1208	117235356.0
2006-06-06 12:00:00	AAPL	Stock	2.1211	2.1407	2.1182	2.1371	82526024.0
2006-06-06 13:00:00	AAPL	Stock	2.1368	2.1518	2.1236	2.1289	55028400.0
2006-06-06 14:00:00	AAPL	Stock	2.1289	2.1293	2.105	2.1054	85528688.0
2006-06-06 15:00:00	AAPL	Stock	2.1051	2.1339	2.1039	2.1332	127463812.0
2006-06-06 16:00:00	AAPL	Stock	2.1329	2.1429	2.1175	2.1371	2420992.0
2006-06-06 17:00:00	AAPL	Stock	2.1371	2.1379	2.1354	2.1379	145880.0
2006-06-06 18:00:00	AAPL	Stock	2.1357	2.1386	2.1346	2.1371	95060.0
2006-06-06 07:00:00	MSFT	Stock	22.5	22.55	22.5	22.55	1600.0
2006-06-06 08:00:00	MSFT	Stock	22.55	22.59	22.51	22.55	55750.0
2006-06-06 09:00:00	MSFT	Stock	22.55	22.56	22.45	22.48	6591208.0
2006-06-06 10:00:00	MSFT	Stock	22.48	22.555	22.34	22.38	14875286.0
2006-06-06 11:00:00	MSFT	Stock	22.38	22.4	22.21	22.28	15962001.0
2006-06-06 12:00:00	MSFT	Stock	22.29	22.37	22.25	22.34	11386389.0
2006-06-06 13:00:00	MSFT	Stock	22.34	22.35	22.15	22.21	14022100.0
2006-06-06 14:00:00	MSFT	Stock	22.21	22.21	22.03	22.04	22122613.0
2006-06-06 15:00:00	MSFT	Stock	22.03	22.26	21.98	22.13	35851630.0
2006-06-06 16:00:00	MSFT	Stock	22.12	22.18	22.11	22.18	1498849.0
2006-06-06 17:00:00	MSFT	Stock	22.17	22.18	22.13	22.17	10456.0
2006-06-06 18:00:00	MSFT	Stock	22.17	22.18	22.17	22.17	2300.0
2006-06-06 08:00:00	NVDA	Stock	0.3817	0.3828	0.3817	0.3828	843000.0
2006-06-06 09:00:00	NVDA	Stock	0.3828	0.3857	0.3728	0.3755	86083680.0
2006-06-06 10:00:00	NVDA	Stock	0.3755	0.3773	0.3693	0.3695	122734920.0
2006-06-06 11:00:00	NVDA	Stock	0.3695	0.3708	0.36	0.3657	216018420.0
2006-06-06 12:00:00	NVDA	Stock	0.3658	0.3757	0.3658	0.3757	103869120.0
2006-06-06 13:00:00	NVDA	Stock	0.3758	0.3772	0.37	0.3717	83406720.0
2006-06-06 14:00:00	NVDA	Stock	0.3718	0.3723	0.3667	0.37	67214760.0
2006-06-06 15:00:00	NVDA	Stock	0.37	0.3732	0.3677	0.3702	101358780.0
2006-06-06 16:00:00	NVDA	Stock	0.3698	0.3717	0.3695	0.3717	15716340.0
2006-06-06 17:00:00	NVDA	Stock	0.3717	0.3717	0.3717	0.3717	24000.0
2006-06-06 18:00:00	NVDA	Stock	0.3732	0.3732	0.3732	0.3732	12000.0
2006-06-06 04:00:00	AMZN	Stock	1.675	1.675	1.675	1.675	2000.0
2006-06-06 09:00:00	AMZN	Stock	1.6775	1.69	1.664	1.665	7959340.0
2006-06-06 10:00:00	AMZN	Stock	1.6655	1.686	1.661	1.6625	13797640.0
2006-06-06 11:00:00	AMZN	Stock	1.6625	1.666	1.6475	1.6505	11404960.0
2006-06-06 12:00:00	AMZN	Stock	1.651	1.68	1.6495	1.679	10127840.0
2006-06-06 13:00:00	AMZN	Stock	1.679	1.6845	1.6685	1.6735	9037200.0
2006-06-06 14:00:00	AMZN	Stock	1.673	1.673	1.6525	1.6555	10382300.0
2006-06-06 15:00:00	AMZN	Stock	1.6555	1.6715	1.6465	1.6705	19530040.0
2006-06-06 16:00:00	AMZN	Stock	1.671	1.675	1.6699	1.6699	69600.0
2006-06-06 09:00:00	CL	Stock	29.8	29.945	29.8	29.93	319600.0
2006-06-06 10:00:00	CL	Stock	29.925	29.925	29.755	29.855	939800.0
2006-06-06 11:00:00	CL	Stock	29.875	29.94	29.79	29.855	580400.0
2006-06-06 12:00:00	CL	Stock	29.855	30.0	29.855	29.985	410400.0
2006-06-06 13:00:00	CL	Stock	29.975	30.03	29.895	29.953	454800.0
2006-06-06 14:00:00	CL	Stock	29.95	30.07	29.89	29.99	539200.0
2006-06-06 15:00:00	CL	Stock	29.985	30.13	29.945	30.11	866600.0

> showing 50 of 29,200 rows — these rows as CSV

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