PREVIEW / stock_1hour / 2006-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-02.parquet
  size:    607 KB
  rows:    28,864
  symbols: 2,265

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-02 08:00:00	AAPL	Stock	2.2279	2.2429	2.2232	2.2421	3732568.0
2006-06-02 09:00:00	AAPL	Stock	2.2421	2.2536	2.2004	2.2064	130560976.0
2006-06-02 10:00:00	AAPL	Stock	2.2061	2.2286	2.2018	2.2132	125807136.0
2006-06-02 11:00:00	AAPL	Stock	2.2132	2.2468	2.1796	2.1864	118309464.0
2006-06-02 12:00:00	AAPL	Stock	2.185	2.1979	2.1768	2.1775	66607856.0
2006-06-02 13:00:00	AAPL	Stock	2.1778	2.2186	2.1743	2.1857	66922912.0
2006-06-02 14:00:00	AAPL	Stock	2.1861	2.2089	2.1836	2.2061	67949000.0
2006-06-02 15:00:00	AAPL	Stock	2.2061	2.2143	2.1946	2.2018	96887224.0
2006-06-02 16:00:00	AAPL	Stock	2.2011	2.2032	2.1996	2.2032	2178624.0
2006-06-02 17:00:00	AAPL	Stock	2.2018	2.2332	2.1996	2.1996	667268.0
2006-06-02 18:00:00	AAPL	Stock	2.2018	2.2018	2.1989	2.1989	145068.0
2006-06-02 05:00:00	MSFT	Stock	22.9	22.99	22.9	22.99	1450.0
2006-06-02 06:00:00	MSFT	Stock	22.89	22.89	22.89	22.89	500.0
2006-06-02 07:00:00	MSFT	Stock	22.85	22.9	22.85	22.9	510.0
2006-06-02 08:00:00	MSFT	Stock	22.87	23.0	22.83	22.95	478419.0
2006-06-02 09:00:00	MSFT	Stock	22.95	22.99	22.75	22.8	12829529.0
2006-06-02 10:00:00	MSFT	Stock	22.8	22.94	22.79	22.838	17565641.0
2006-06-02 11:00:00	MSFT	Stock	22.84	22.84	22.71	22.74	9447821.0
2006-06-02 12:00:00	MSFT	Stock	22.74	22.79	22.68	22.71	7645456.0
2006-06-02 13:00:00	MSFT	Stock	22.71	22.75	22.69	22.69	5700270.0
2006-06-02 14:00:00	MSFT	Stock	22.7	22.76	22.67	22.74	6136046.0
2006-06-02 15:00:00	MSFT	Stock	22.73	22.76	22.68	22.76	11767918.0
2006-06-02 16:00:00	MSFT	Stock	22.76	22.834	22.74	22.74	1093905.0
2006-06-02 17:00:00	MSFT	Stock	22.74	22.76	22.74	22.76	14223.0
2006-06-02 18:00:00	MSFT	Stock	22.76	22.76	22.76	22.76	2300.0
2006-06-02 08:00:00	NVDA	Stock	0.4047	0.4107	0.4045	0.408	1196640.0
2006-06-02 09:00:00	NVDA	Stock	0.4085	0.4115	0.3945	0.395	104489220.0
2006-06-02 10:00:00	NVDA	Stock	0.395	0.401	0.3948	0.3977	123552600.0
2006-06-02 11:00:00	NVDA	Stock	0.3978	0.3997	0.3942	0.3942	107061240.0
2006-06-02 12:00:00	NVDA	Stock	0.3942	0.3968	0.3932	0.3962	100273980.0
2006-06-02 13:00:00	NVDA	Stock	0.3962	0.3982	0.3948	0.3957	60605580.0
2006-06-02 14:00:00	NVDA	Stock	0.3957	0.3978	0.3955	0.3977	48527760.0
2006-06-02 15:00:00	NVDA	Stock	0.3977	0.3983	0.3965	0.3968	113493540.0
2006-06-02 16:00:00	NVDA	Stock	0.397	0.3973	0.396	0.3973	1009080.0
2006-06-02 18:00:00	NVDA	Stock	0.3957	0.396	0.395	0.395	156000.0
2006-06-02 08:00:00	AMZN	Stock	1.7605	1.7605	1.7555	1.7555	44080.0
2006-06-02 09:00:00	AMZN	Stock	1.7605	1.7605	1.728	1.7325	17192860.0
2006-06-02 10:00:00	AMZN	Stock	1.7315	1.761	1.7265	1.7455	17681740.0
2006-06-02 11:00:00	AMZN	Stock	1.7455	1.7475	1.7075	1.7075	16046580.0
2006-06-02 12:00:00	AMZN	Stock	1.7075	1.716	1.7025	1.7065	5355840.0
2006-06-02 13:00:00	AMZN	Stock	1.7065	1.72	1.7065	1.7145	11882800.0
2006-06-02 14:00:00	AMZN	Stock	1.714	1.717	1.706	1.713	16714800.0
2006-06-02 15:00:00	AMZN	Stock	1.713	1.738	1.7115	1.738	19998640.0
2006-06-02 16:00:00	AMZN	Stock	1.738	1.7385	1.7311	1.7311	732300.0
2006-06-02 17:00:00	AMZN	Stock	1.7315	1.7315	1.7315	1.7315	4520.0
2006-06-02 18:00:00	AMZN	Stock	1.7315	1.7315	1.7315	1.7315	4000.0
2006-06-02 09:00:00	CL	Stock	30.5	30.5	30.295	30.295	599000.0
2006-06-02 10:00:00	CL	Stock	30.295	30.499	30.04	30.07	508800.0
2006-06-02 11:00:00	CL	Stock	30.075	30.13	29.915	29.97	384200.0
2006-06-02 12:00:00	CL	Stock	29.965	30.005	29.855	29.96	416800.0

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

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