PREVIEW / stock_1hour / 2006-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-05.parquet
  size:    610 KB
  rows:    28,949
  symbols: 2,287

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-05 07:00:00	AAPL	Stock	2.1893	2.1911	2.1893	2.1893	33600.0
2006-06-05 08:00:00	AAPL	Stock	2.1893	2.1893	2.1825	2.1868	710024.0
2006-06-05 09:00:00	AAPL	Stock	2.1875	2.1875	2.1625	2.1664	94655064.0
2006-06-05 10:00:00	AAPL	Stock	2.1664	2.1779	2.1621	2.1746	106196916.0
2006-06-05 11:00:00	AAPL	Stock	2.175	2.1832	2.1693	2.1729	58360624.0
2006-06-05 12:00:00	AAPL	Stock	2.1729	2.1743	2.1564	2.1629	59297084.0
2006-06-05 13:00:00	AAPL	Stock	2.1631	2.1664	2.1593	2.1625	40563096.0
2006-06-05 14:00:00	AAPL	Stock	2.1621	2.1625	2.1446	2.1493	101927476.0
2006-06-05 15:00:00	AAPL	Stock	2.1486	2.1536	2.1418	2.1437	134207528.0
2006-06-05 16:00:00	AAPL	Stock	2.1439	2.1468	2.1396	2.1443	2466604.0
2006-06-05 17:00:00	AAPL	Stock	2.1443	2.1464	2.1436	2.1439	254352.0
2006-06-05 18:00:00	AAPL	Stock	2.1439	2.1461	2.1436	2.1446	114520.0
2006-06-05 08:00:00	MSFT	Stock	22.77	22.77	22.69	22.69	2349.0
2006-06-05 09:00:00	MSFT	Stock	22.69	22.75	22.62	22.66	5837769.0
2006-06-05 10:00:00	MSFT	Stock	22.66	22.71	22.52	22.64	8591104.0
2006-06-05 11:00:00	MSFT	Stock	22.65	22.66	22.59	22.611	6229249.0
2006-06-05 12:00:00	MSFT	Stock	22.62	22.62	22.58	22.6	5932332.0
2006-06-05 13:00:00	MSFT	Stock	22.6	22.61	22.54	22.56	6039396.0
2006-06-05 14:00:00	MSFT	Stock	22.56	22.59	22.5	22.55	10967264.0
2006-06-05 15:00:00	MSFT	Stock	22.55	22.55	22.49	22.51	17297989.0
2006-06-05 16:00:00	MSFT	Stock	22.5	22.55	22.5	22.54	995634.0
2006-06-05 17:00:00	MSFT	Stock	22.55	22.56	22.52	22.52	44235.0
2006-06-05 18:00:00	MSFT	Stock	22.52	22.55	22.51	22.52	17000.0
2006-06-05 09:00:00	NVDA	Stock	0.3957	0.4012	0.394	0.3977	34438500.0
2006-06-05 10:00:00	NVDA	Stock	0.3977	0.4012	0.397	0.4007	68939700.0
2006-06-05 11:00:00	NVDA	Stock	0.4007	0.4023	0.4005	0.4023	42412140.0
2006-06-05 12:00:00	NVDA	Stock	0.4023	0.4023	0.3967	0.3973	61414920.0
2006-06-05 13:00:00	NVDA	Stock	0.3975	0.3982	0.392	0.3922	79050900.0
2006-06-05 14:00:00	NVDA	Stock	0.392	0.3923	0.387	0.3895	100371480.0
2006-06-05 15:00:00	NVDA	Stock	0.3895	0.39	0.3793	0.381	177961440.0
2006-06-05 16:00:00	NVDA	Stock	0.3802	0.3805	0.3783	0.3792	805260.0
2006-06-05 17:00:00	NVDA	Stock	0.3788	0.3807	0.3788	0.3807	308280.0
2006-06-05 18:00:00	NVDA	Stock	0.3808	0.3817	0.3808	0.3817	18000.0
2006-06-05 08:00:00	AMZN	Stock	1.75	1.757	1.75	1.757	4000.0
2006-06-05 09:00:00	AMZN	Stock	1.733	1.733	1.7055	1.711	10016360.0
2006-06-05 10:00:00	AMZN	Stock	1.7105	1.7265	1.7055	1.713	9432800.0
2006-06-05 11:00:00	AMZN	Stock	1.7125	1.719	1.7075	1.7175	6560700.0
2006-06-05 12:00:00	AMZN	Stock	1.7176	1.7176	1.702	1.704	5975920.0
2006-06-05 13:00:00	AMZN	Stock	1.7036	1.7065	1.701	1.7045	8384240.0
2006-06-05 14:00:00	AMZN	Stock	1.7041	1.7041	1.6765	1.678	28411720.0
2006-06-05 15:00:00	AMZN	Stock	1.6775	1.679	1.6635	1.675	30455660.0
2006-06-05 16:00:00	AMZN	Stock	1.6745	1.6755	1.6735	1.675	250700.0
2006-06-05 17:00:00	AMZN	Stock	1.676	1.6765	1.676	1.6765	12800.0
2006-06-05 08:00:00	CL	Stock	30.11	30.11	30.11	30.11	4000.0
2006-06-05 09:00:00	CL	Stock	30.0	30.23	29.96	30.06	248400.0
2006-06-05 10:00:00	CL	Stock	30.055	30.065	29.9	29.935	375000.0
2006-06-05 11:00:00	CL	Stock	29.935	29.96	29.85	29.9	254400.0
2006-06-05 12:00:00	CL	Stock	29.8925	29.95	29.884	29.915	205800.0
2006-06-05 13:00:00	CL	Stock	29.915	29.96	29.887	29.915	306800.0
2006-06-05 14:00:00	CL	Stock	29.92	29.93	29.75	29.805	470400.0

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

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