PREVIEW / stock_1hour / 2006-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-25.parquet
  size:    615 KB
  rows:    30,000
  symbols: 2,325

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-07-25 08:00:00	AAPL	Stock	2.2018	2.2089	2.2	2.2018	3020668.0
2006-07-25 09:00:00	AAPL	Stock	2.2018	2.2143	2.1886	2.1893	82889128.0
2006-07-25 10:00:00	AAPL	Stock	2.1893	2.2029	2.1707	2.1768	122052756.0
2006-07-25 11:00:00	AAPL	Stock	2.1757	2.1871	2.1743	2.1829	65245460.0
2006-07-25 12:00:00	AAPL	Stock	2.1832	2.2014	2.1757	2.1989	68192880.0
2006-07-25 13:00:00	AAPL	Stock	2.1993	2.2039	2.1893	2.1929	56418376.0
2006-07-25 14:00:00	AAPL	Stock	2.1925	2.2068	2.1871	2.2039	53248692.0
2006-07-25 15:00:00	AAPL	Stock	2.2039	2.2175	2.2032	2.2118	128803752.0
2006-07-25 16:00:00	AAPL	Stock	2.2118	2.2139	2.2036	2.2086	1689268.0
2006-07-25 17:00:00	AAPL	Stock	2.2086	2.2107	2.2086	2.2086	321160.0
2006-07-25 18:00:00	AAPL	Stock	2.2086	2.2089	2.2046	2.2089	162400.0
2006-07-25 08:00:00	MSFT	Stock	24.05	24.07	24.0	24.0	13000.0
2006-07-25 09:00:00	MSFT	Stock	24.0	24.17	23.81	24.16	4981392.0
2006-07-25 10:00:00	MSFT	Stock	24.16	24.27	23.9	24.02	12541141.0
2006-07-25 11:00:00	MSFT	Stock	24.02	24.06	23.95	23.97	5728812.0
2006-07-25 12:00:00	MSFT	Stock	23.96	24.05	23.94	23.98	5650452.0
2006-07-25 13:00:00	MSFT	Stock	23.98	24.09	23.97	24.08	5179188.0
2006-07-25 14:00:00	MSFT	Stock	24.08	24.22	24.02	24.2	7227848.0
2006-07-25 15:00:00	MSFT	Stock	24.2	24.29	24.14	24.22	15866796.0
2006-07-25 16:00:00	MSFT	Stock	24.21	24.3	24.11	24.15	894046.0
2006-07-25 17:00:00	MSFT	Stock	24.13	24.15	24.1	24.11	48577.0
2006-07-25 18:00:00	MSFT	Stock	24.11	24.11	24.11	24.11	2100.0
2006-07-25 07:00:00	NVDA	Stock	0.3177	0.3177	0.3177	0.3177	60000.0
2006-07-25 08:00:00	NVDA	Stock	0.3333	0.3358	0.3317	0.3317	3164160.0
2006-07-25 09:00:00	NVDA	Stock	0.3317	0.3333	0.3252	0.3328	59204400.0
2006-07-25 10:00:00	NVDA	Stock	0.3328	0.341	0.3314	0.3355	127517100.0
2006-07-25 11:00:00	NVDA	Stock	0.3355	0.3387	0.3327	0.3337	67129260.0
2006-07-25 12:00:00	NVDA	Stock	0.3335	0.3375	0.3328	0.336	47322000.0
2006-07-25 13:00:00	NVDA	Stock	0.3358	0.336	0.3323	0.3335	39577140.0
2006-07-25 14:00:00	NVDA	Stock	0.3335	0.3338	0.328	0.3317	79110120.0
2006-07-25 15:00:00	NVDA	Stock	0.3318	0.3392	0.3313	0.3375	137437320.0
2006-07-25 16:00:00	NVDA	Stock	0.3373	0.3375	0.336	0.336	956340.0
2006-07-25 17:00:00	NVDA	Stock	0.336	0.3375	0.336	0.3375	150780.0
2006-07-25 18:00:00	NVDA	Stock	0.338	0.338	0.338	0.338	50940.0
2006-07-25 05:00:00	AMZN	Stock	1.7185	1.7185	1.7185	1.7185	7000.0
2006-07-25 08:00:00	AMZN	Stock	1.7185	1.724	1.7	1.7	51000.0
2006-07-25 09:00:00	AMZN	Stock	1.7	1.7125	1.6855	1.6945	20863600.0
2006-07-25 10:00:00	AMZN	Stock	1.693	1.708	1.686	1.6915	31159760.0
2006-07-25 11:00:00	AMZN	Stock	1.691	1.6955	1.681	1.6925	23005040.0
2006-07-25 12:00:00	AMZN	Stock	1.6925	1.698	1.686	1.6975	22764020.0
2006-07-25 13:00:00	AMZN	Stock	1.6975	1.706	1.695	1.701	21613700.0
2006-07-25 14:00:00	AMZN	Stock	1.701	1.703	1.6945	1.701	27071400.0
2006-07-25 15:00:00	AMZN	Stock	1.701	1.703	1.6695	1.6785	71128720.0
2006-07-25 16:00:00	AMZN	Stock	1.675	1.7295	1.49	1.4985	101179840.0
2006-07-25 17:00:00	AMZN	Stock	1.498	1.523	1.485	1.4925	21860920.0
2006-07-25 18:00:00	AMZN	Stock	1.4925	1.494	1.47	1.475	16041540.0
2006-07-25 08:00:00	CL	Stock	31.0	31.0	31.0	31.0	200.0
2006-07-25 09:00:00	CL	Stock	30.65	30.725	30.505	30.62	631800.0
2006-07-25 10:00:00	CL	Stock	30.625	30.635	30.3	30.385	1194200.0
2006-07-25 11:00:00	CL	Stock	30.38	30.4	30.005	30.065	898200.0

> showing 50 of 30,000 rows — these rows as CSV

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