PREVIEW / stock_1hour / 2006-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-02.parquet
  size:    604 KB
  rows:    28,671
  symbols: 2,255

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-05-02 06:00:00	AAPL	Stock	2.5071	2.5157	2.5071	2.5157	8400.0
2006-05-02 08:00:00	AAPL	Stock	2.5096	2.5179	2.5018	2.5136	3147424.0
2006-05-02 09:00:00	AAPL	Stock	2.5136	2.5311	2.4907	2.5271	98411880.0
2006-05-02 10:00:00	AAPL	Stock	2.5268	2.5707	2.5257	2.5607	227385340.0
2006-05-02 11:00:00	AAPL	Stock	2.5607	2.5625	2.5296	2.5468	120616776.0
2006-05-02 12:00:00	AAPL	Stock	2.5471	2.5589	2.5371	2.5532	64643208.0
2006-05-02 13:00:00	AAPL	Stock	2.5532	2.5661	2.5471	2.5517	48868708.0
2006-05-02 14:00:00	AAPL	Stock	2.5514	2.5571	2.5432	2.55	64839180.0
2006-05-02 15:00:00	AAPL	Stock	2.55	2.5693	2.5468	2.5575	124057472.0
2006-05-02 16:00:00	AAPL	Stock	2.5575	2.5614	2.5554	2.5614	2831864.0
2006-05-02 17:00:00	AAPL	Stock	2.5607	2.5621	2.5593	2.5614	330764.0
2006-05-02 18:00:00	AAPL	Stock	2.5614	2.5614	2.5579	2.5589	311136.0
2006-05-02 04:00:00	MSFT	Stock	24.58	24.63	24.43	24.63	1200.0
2006-05-02 05:00:00	MSFT	Stock	24.65	24.66	24.65	24.66	3100.0
2006-05-02 06:00:00	MSFT	Stock	24.65	24.65	24.61	24.61	6500.0
2006-05-02 07:00:00	MSFT	Stock	24.63	24.67	24.5	24.51	38170.0
2006-05-02 08:00:00	MSFT	Stock	24.5	24.5	24.43	24.47	259397.0
2006-05-02 09:00:00	MSFT	Stock	24.47	25.0	24.31	24.338	22275722.0
2006-05-02 10:00:00	MSFT	Stock	24.34	24.485	24.15	24.19	29407501.0
2006-05-02 11:00:00	MSFT	Stock	24.19	24.24	24.05	24.07	27514832.0
2006-05-02 12:00:00	MSFT	Stock	24.08	24.13	24.0	24.01	20635103.0
2006-05-02 13:00:00	MSFT	Stock	24.01	24.15	23.91	24.03	24800915.0
2006-05-02 14:00:00	MSFT	Stock	24.03	24.15	23.9	23.95	27563183.0
2006-05-02 15:00:00	MSFT	Stock	23.96	24.1	23.9	24.01	34334664.0
2006-05-02 16:00:00	MSFT	Stock	24.02	24.04	23.99	24.01	553993.0
2006-05-02 17:00:00	MSFT	Stock	24.01	24.01	23.99	24.01	39831.0
2006-05-02 18:00:00	MSFT	Stock	24.01	24.01	23.99	24.0	31638.0
2006-05-02 08:00:00	NVDA	Stock	0.5207	0.5207	0.5052	0.5182	1321080.0
2006-05-02 09:00:00	NVDA	Stock	0.5175	0.525	0.5055	0.5087	72278820.0
2006-05-02 10:00:00	NVDA	Stock	0.5085	0.5185	0.5067	0.5132	93908640.0
2006-05-02 11:00:00	NVDA	Stock	0.513	0.5182	0.5117	0.518	63596940.0
2006-05-02 12:00:00	NVDA	Stock	0.518	0.5202	0.5162	0.5197	62188380.0
2006-05-02 13:00:00	NVDA	Stock	0.5197	0.5247	0.5165	0.5247	70053420.0
2006-05-02 14:00:00	NVDA	Stock	0.5247	0.5248	0.5152	0.5157	51543480.0
2006-05-02 15:00:00	NVDA	Stock	0.5158	0.5185	0.5122	0.5142	100997760.0
2006-05-02 16:00:00	NVDA	Stock	0.5142	0.5143	0.5135	0.5135	682500.0
2006-05-02 17:00:00	NVDA	Stock	0.5136	0.5136	0.5132	0.5132	1530000.0
2006-05-02 18:00:00	NVDA	Stock	0.5143	0.5143	0.5143	0.5143	53280.0
2006-05-02 08:00:00	AMZN	Stock	1.734	1.734	1.732	1.734	28000.0
2006-05-02 09:00:00	AMZN	Stock	1.7375	1.7395	1.715	1.72	19369340.0
2006-05-02 10:00:00	AMZN	Stock	1.7205	1.747	1.7165	1.718	27795780.0
2006-05-02 11:00:00	AMZN	Stock	1.718	1.7225	1.7115	1.715	14744200.0
2006-05-02 12:00:00	AMZN	Stock	1.715	1.7164	1.712	1.7145	11172260.0
2006-05-02 13:00:00	AMZN	Stock	1.7145	1.7245	1.7125	1.7185	8550480.0
2006-05-02 14:00:00	AMZN	Stock	1.719	1.72	1.713	1.7131	10355280.0
2006-05-02 15:00:00	AMZN	Stock	1.7135	1.7215	1.713	1.7195	21367560.0
2006-05-02 16:00:00	AMZN	Stock	1.719	1.7195	1.718	1.718	224000.0
2006-05-02 17:00:00	AMZN	Stock	1.7169	1.7169	1.7169	1.7169	2000.0
2006-05-02 18:00:00	AMZN	Stock	1.719	1.719	1.719	1.719	11540.0
2006-05-02 09:00:00	CL	Stock	29.475	29.66	29.445	29.585	404800.0

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

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