PREVIEW / stock_1hour / 2006-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-27.parquet
  size:    611 KB
  rows:    28,898
  symbols: 2,189

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-01-27 04:00:00	AAPL	Stock	2.6304	2.6304	2.6304	2.6304	2800.0
2006-01-27 07:00:00	AAPL	Stock	2.6268	2.6321	2.6179	2.6179	299600.0
2006-01-27 08:00:00	AAPL	Stock	2.6179	2.6261	2.6071	2.6082	4757760.0
2006-01-27 09:00:00	AAPL	Stock	2.6086	2.6125	2.5393	2.5882	182390936.0
2006-01-27 10:00:00	AAPL	Stock	2.5839	2.6286	2.5661	2.5832	250879440.0
2006-01-27 11:00:00	AAPL	Stock	2.5832	2.5857	2.5625	2.5732	116052356.0
2006-01-27 12:00:00	AAPL	Stock	2.5729	2.6	2.5711	2.5796	99021916.0
2006-01-27 13:00:00	AAPL	Stock	2.5793	2.5796	2.5536	2.5609	74160100.0
2006-01-27 14:00:00	AAPL	Stock	2.5618	2.5771	2.5554	2.5646	74326784.0
2006-01-27 15:00:00	AAPL	Stock	2.565	2.5725	2.5454	2.5711	128750692.0
2006-01-27 16:00:00	AAPL	Stock	2.5711	2.5768	2.5589	2.5732	5141836.0
2006-01-27 17:00:00	AAPL	Stock	2.5732	2.5782	2.5632	2.5725	921396.0
2006-01-27 18:00:00	AAPL	Stock	2.5771	2.5786	2.5732	2.575	581896.0
2006-01-27 04:00:00	MSFT	Stock	27.2	27.2	27.2	27.2	200.0
2006-01-27 07:00:00	MSFT	Stock	27.25	27.4	27.2	27.4	25100.0
2006-01-27 08:00:00	MSFT	Stock	27.4	27.42	27.21	27.28	1990006.0
2006-01-27 09:00:00	MSFT	Stock	27.28	27.36	27.19	27.32	23257314.0
2006-01-27 10:00:00	MSFT	Stock	27.33	27.5	27.31	27.44	22232841.0
2006-01-27 11:00:00	MSFT	Stock	27.45	27.66	27.42	27.66	22372344.0
2006-01-27 12:00:00	MSFT	Stock	27.66	27.86	27.4	27.8	14504024.0
2006-01-27 13:00:00	MSFT	Stock	27.82	27.82	27.6	27.708	11626662.0
2006-01-27 14:00:00	MSFT	Stock	27.71	27.86	27.66	27.85	9931833.0
2006-01-27 15:00:00	MSFT	Stock	27.85	27.95	27.72	27.8	24015232.0
2006-01-27 16:00:00	MSFT	Stock	27.81	27.83	27.67	27.79	973604.0
2006-01-27 17:00:00	MSFT	Stock	27.77	27.78	27.75	27.75	5278.0
2006-01-27 18:00:00	MSFT	Stock	27.76	27.78	27.75	27.78	4520.0
2006-01-27 08:00:00	NVDA	Stock	0.3852	0.3877	0.3833	0.3833	1917600.0
2006-01-27 09:00:00	NVDA	Stock	0.3833	0.3874	0.3801	0.3855	63889200.0
2006-01-27 10:00:00	NVDA	Stock	0.3852	0.3897	0.3851	0.3886	87257280.0
2006-01-27 11:00:00	NVDA	Stock	0.3887	0.3892	0.386	0.3882	43987680.0
2006-01-27 12:00:00	NVDA	Stock	0.3881	0.389	0.3859	0.3862	22168680.0
2006-01-27 13:00:00	NVDA	Stock	0.3862	0.3862	0.3803	0.3805	37572960.0
2006-01-27 14:00:00	NVDA	Stock	0.3808	0.3834	0.38	0.3829	37814160.0
2006-01-27 15:00:00	NVDA	Stock	0.3829	0.3854	0.3827	0.3854	72802200.0
2006-01-27 16:00:00	NVDA	Stock	0.3852	0.3854	0.3852	0.3854	3004200.0
2006-01-27 17:00:00	NVDA	Stock	0.3854	0.3854	0.3854	0.3854	12840.0
2006-01-27 08:00:00	AMZN	Stock	2.23	2.234	2.23	2.234	97000.0
2006-01-27 09:00:00	AMZN	Stock	2.2325	2.255	2.2265	2.2505	14751460.0
2006-01-27 10:00:00	AMZN	Stock	2.2505	2.2595	2.24	2.25	17135720.0
2006-01-27 11:00:00	AMZN	Stock	2.2505	2.259	2.2345	2.258	10983180.0
2006-01-27 12:00:00	AMZN	Stock	2.2575	2.2575	2.2495	2.2525	6091880.0
2006-01-27 13:00:00	AMZN	Stock	2.2525	2.2525	2.238	2.244	7690760.0
2006-01-27 14:00:00	AMZN	Stock	2.244	2.2525	2.244	2.2495	7504480.0
2006-01-27 15:00:00	AMZN	Stock	2.2495	2.2605	2.245	2.2605	17290520.0
2006-01-27 16:00:00	AMZN	Stock	2.2605	2.262	2.26	2.262	98540.0
2006-01-27 17:00:00	AMZN	Stock	2.262	2.2635	2.262	2.2635	16400.0
2006-01-27 18:00:00	AMZN	Stock	2.265	2.265	2.265	2.265	2000.0
2006-01-27 08:00:00	CL	Stock	27.585	27.585	27.5	27.5	1800.0
2006-01-27 09:00:00	CL	Stock	27.55	28.0	27.55	27.77	883400.0
2006-01-27 10:00:00	CL	Stock	27.76	27.85	27.55	27.58	930000.0

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

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