PREVIEW / stock_1hour / 2006-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-12.parquet
  size:    617 KB
  rows:    29,521
  symbols: 2,351

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-09-12 07:00:00	AAPL	Stock	2.5789	2.5893	2.575	2.5893	140000.0
2006-09-12 08:00:00	AAPL	Stock	2.5875	2.6061	2.5839	2.5979	3786216.0
2006-09-12 09:00:00	AAPL	Stock	2.5964	2.6064	2.57	2.5843	144324740.0
2006-09-12 10:00:00	AAPL	Stock	2.585	2.6232	2.5843	2.6128	192789632.0
2006-09-12 11:00:00	AAPL	Stock	2.6131	2.6157	2.5968	2.6021	110432000.0
2006-09-12 12:00:00	AAPL	Stock	2.6021	2.6196	2.5982	2.6093	117182520.0
2006-09-12 13:00:00	AAPL	Stock	2.6093	2.6114	2.555	2.5661	522607820.0
2006-09-12 14:00:00	AAPL	Stock	2.5661	2.6179	2.5518	2.6122	324540104.0
2006-09-12 15:00:00	AAPL	Stock	2.6114	2.6193	2.5907	2.5929	257678904.0
2006-09-12 16:00:00	AAPL	Stock	2.5929	2.5979	2.5925	2.5964	4597852.0
2006-09-12 17:00:00	AAPL	Stock	2.5964	2.5964	2.5936	2.5939	472360.0
2006-09-12 18:00:00	AAPL	Stock	2.5936	2.5939	2.5907	2.5936	693364.0
2006-09-12 08:00:00	MSFT	Stock	25.87	25.91	25.84	25.9	20074.0
2006-09-12 09:00:00	MSFT	Stock	25.91	25.98	25.84	25.888	8161813.0
2006-09-12 10:00:00	MSFT	Stock	25.89	25.91	25.78	25.86	8781654.0
2006-09-12 11:00:00	MSFT	Stock	25.862	25.91	25.78	25.79	6427800.0
2006-09-12 12:00:00	MSFT	Stock	25.8	25.81	25.73	25.77	4847956.0
2006-09-12 13:00:00	MSFT	Stock	25.77	25.83	25.72	25.81	5257803.0
2006-09-12 14:00:00	MSFT	Stock	25.81	25.98	25.79	25.97	5472661.0
2006-09-12 15:00:00	MSFT	Stock	25.97	25.98	25.8	25.94	8602404.0
2006-09-12 16:00:00	MSFT	Stock	25.92	26.003	25.78	25.95	374489.0
2006-09-12 17:00:00	MSFT	Stock	25.89	25.95	25.87	25.87	1914800.0
2006-09-12 08:00:00	NVDA	Stock	0.4667	0.4667	0.4667	0.4667	12000.0
2006-09-12 09:00:00	NVDA	Stock	0.4668	0.473	0.4642	0.4692	36658440.0
2006-09-12 10:00:00	NVDA	Stock	0.4693	0.4742	0.468	0.4737	57243300.0
2006-09-12 11:00:00	NVDA	Stock	0.4737	0.475	0.471	0.4747	65737380.0
2006-09-12 12:00:00	NVDA	Stock	0.4747	0.4758	0.4728	0.4747	52147260.0
2006-09-12 13:00:00	NVDA	Stock	0.4747	0.4775	0.4745	0.4773	52950060.0
2006-09-12 14:00:00	NVDA	Stock	0.4772	0.4842	0.4762	0.4833	126264240.0
2006-09-12 15:00:00	NVDA	Stock	0.4833	0.4835	0.4783	0.481	90745920.0
2006-09-12 16:00:00	NVDA	Stock	0.4808	0.4812	0.4803	0.4803	322260.0
2006-09-12 17:00:00	NVDA	Stock	0.4805	0.4812	0.4805	0.4812	378000.0
2006-09-12 18:00:00	NVDA	Stock	0.4812	0.4812	0.4812	0.4812	125280.0
2006-09-12 09:00:00	AMZN	Stock	1.5365	1.546	1.5265	1.528	8130660.0
2006-09-12 10:00:00	AMZN	Stock	1.5278	1.5535	1.5275	1.5535	16905080.0
2006-09-12 11:00:00	AMZN	Stock	1.5535	1.5745	1.552	1.567	23452040.0
2006-09-12 12:00:00	AMZN	Stock	1.567	1.5795	1.566	1.5765	13547440.0
2006-09-12 13:00:00	AMZN	Stock	1.5768	1.588	1.5694	1.5875	14225240.0
2006-09-12 14:00:00	AMZN	Stock	1.5875	1.597	1.5775	1.5965	17358840.0
2006-09-12 15:00:00	AMZN	Stock	1.5965	1.5965	1.5755	1.5845	24295380.0
2006-09-12 16:00:00	AMZN	Stock	1.586	1.5865	1.5835	1.585	125660.0
2006-09-12 17:00:00	AMZN	Stock	1.5855	1.5855	1.5855	1.5855	19000.0
2006-09-12 18:00:00	AMZN	Stock	1.586	1.586	1.586	1.586	57800.0
2006-09-12 09:00:00	CL	Stock	31.05	31.1	31.005	31.0605	300200.0
2006-09-12 10:00:00	CL	Stock	31.06	31.14	31.06	31.09	569800.0
2006-09-12 11:00:00	CL	Stock	31.1	31.14	30.97	31.025	1971400.0
2006-09-12 12:00:00	CL	Stock	31.015	31.125	31.0	31.06	452600.0
2006-09-12 13:00:00	CL	Stock	31.06	31.245	31.01	31.21	366400.0
2006-09-12 14:00:00	CL	Stock	31.22	31.24	31.12	31.14	282600.0
2006-09-12 15:00:00	CL	Stock	31.135	31.235	31.08	31.155	640000.0

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

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