PREVIEW / stock_1hour / 2006-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-02.parquet
  size:    598 KB
  rows:    28,234
  symbols: 2,193

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-03-02 06:00:00	AAPL	Stock	2.4643	2.4643	2.4643	2.4643	28000.0
2006-03-02 07:00:00	AAPL	Stock	2.475	2.475	2.4639	2.4661	143080.0
2006-03-02 08:00:00	AAPL	Stock	2.4821	2.4821	2.4596	2.4643	1188628.0
2006-03-02 09:00:00	AAPL	Stock	2.4643	2.4954	2.4575	2.4786	97644148.0
2006-03-02 10:00:00	AAPL	Stock	2.4786	2.4889	2.4525	2.4754	123500356.0
2006-03-02 11:00:00	AAPL	Stock	2.4754	2.4893	2.47	2.4721	82056352.0
2006-03-02 12:00:00	AAPL	Stock	2.4721	2.4725	2.46	2.4704	55810944.0
2006-03-02 13:00:00	AAPL	Stock	2.4704	2.4875	2.4682	2.4854	52123400.0
2006-03-02 14:00:00	AAPL	Stock	2.4857	2.4911	2.4732	2.4818	60735024.0
2006-03-02 15:00:00	AAPL	Stock	2.4821	2.4996	2.4714	2.4861	118914796.0
2006-03-02 16:00:00	AAPL	Stock	2.4864	2.4893	2.4807	2.4875	1436512.0
2006-03-02 17:00:00	AAPL	Stock	2.4875	2.4918	2.4875	2.4918	576968.0
2006-03-02 18:00:00	AAPL	Stock	2.4911	2.4918	2.4882	2.4911	308532.0
2006-03-02 07:00:00	MSFT	Stock	27.07	27.07	27.07	27.07	1000.0
2006-03-02 08:00:00	MSFT	Stock	27.09	27.11	27.07	27.11	24057.0
2006-03-02 09:00:00	MSFT	Stock	27.11	27.11	26.97	26.99	4278259.0
2006-03-02 10:00:00	MSFT	Stock	27.0	27.06	26.95	27.03	6568743.0
2006-03-02 11:00:00	MSFT	Stock	27.03	27.1	26.97	26.99	5714004.0
2006-03-02 12:00:00	MSFT	Stock	26.99	27.0	26.9	26.95	4826973.0
2006-03-02 13:00:00	MSFT	Stock	26.942	27.01	26.94	27.0	4556959.0
2006-03-02 14:00:00	MSFT	Stock	26.99	27.0	26.91	26.962	4902957.0
2006-03-02 15:00:00	MSFT	Stock	26.97	27.07	26.96	26.98	8769979.0
2006-03-02 16:00:00	MSFT	Stock	26.98	27.02	26.97	26.99	396952.0
2006-03-02 17:00:00	MSFT	Stock	27.0	27.015	26.99	26.99	24410.0
2006-03-02 18:00:00	MSFT	Stock	27.0	27.0	26.97	26.97	6075.0
2006-03-02 07:00:00	NVDA	Stock	0.425	0.425	0.425	0.425	24000.0
2006-03-02 08:00:00	NVDA	Stock	0.4108	0.4115	0.4086	0.4086	252000.0
2006-03-02 09:00:00	NVDA	Stock	0.4086	0.4086	0.4037	0.4062	71814000.0
2006-03-02 10:00:00	NVDA	Stock	0.4062	0.4132	0.4058	0.4124	120591600.0
2006-03-02 11:00:00	NVDA	Stock	0.4125	0.414	0.4087	0.4101	84427680.0
2006-03-02 12:00:00	NVDA	Stock	0.4101	0.4102	0.403	0.4037	68371440.0
2006-03-02 13:00:00	NVDA	Stock	0.4037	0.4065	0.4032	0.4059	61612920.0
2006-03-02 14:00:00	NVDA	Stock	0.4058	0.4062	0.4037	0.4042	48887280.0
2006-03-02 15:00:00	NVDA	Stock	0.4042	0.4083	0.4041	0.4082	76251240.0
2006-03-02 16:00:00	NVDA	Stock	0.4077	0.4082	0.4066	0.4082	756600.0
2006-03-02 17:00:00	NVDA	Stock	0.4079	0.4079	0.4077	0.4077	24000.0
2006-03-02 18:00:00	NVDA	Stock	0.4073	0.4082	0.4073	0.4082	600000.0
2006-03-02 08:00:00	AMZN	Stock	1.8775	1.8775	1.8	1.8025	1208060.0
2006-03-02 09:00:00	AMZN	Stock	1.8095	1.822	1.7685	1.79	66125380.0
2006-03-02 10:00:00	AMZN	Stock	1.79	1.8405	1.7875	1.833	50275660.0
2006-03-02 11:00:00	AMZN	Stock	1.833	1.8435	1.8155	1.8325	34106860.0
2006-03-02 12:00:00	AMZN	Stock	1.8325	1.834	1.822	1.833	14923620.0
2006-03-02 13:00:00	AMZN	Stock	1.833	1.8435	1.83	1.8395	15099420.0
2006-03-02 14:00:00	AMZN	Stock	1.84	1.8425	1.826	1.84	15155920.0
2006-03-02 15:00:00	AMZN	Stock	1.84	1.85	1.836	1.844	29135880.0
2006-03-02 16:00:00	AMZN	Stock	1.844	1.8475	1.8196	1.844	1176660.0
2006-03-02 17:00:00	AMZN	Stock	1.8418	1.8565	1.8418	1.85	9000.0
2006-03-02 18:00:00	AMZN	Stock	1.85	1.856	1.85	1.856	20000.0
2006-03-02 09:00:00	CL	Stock	27.275	27.37	27.135	27.155	306000.0
2006-03-02 10:00:00	CL	Stock	27.175	27.285	27.125	27.25	314400.0

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

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