PREVIEW / stock_1hour / 2006-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-30.parquet
  size:    595 KB
  rows:    28,009
  symbols: 2,186

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-30 04:00:00	AAPL	Stock	2.5732	2.5768	2.5732	2.575	33600.0
2006-01-30 05:00:00	AAPL	Stock	2.5768	2.5804	2.5714	2.5714	274400.0
2006-01-30 06:00:00	AAPL	Stock	2.575	2.5768	2.575	2.5768	140560.0
2006-01-30 07:00:00	AAPL	Stock	2.5768	2.5768	2.5554	2.5554	387800.0
2006-01-30 08:00:00	AAPL	Stock	2.5661	2.5696	2.5436	2.5529	5522972.0
2006-01-30 09:00:00	AAPL	Stock	2.5521	2.5875	2.5311	2.5686	195217092.0
2006-01-30 10:00:00	AAPL	Stock	2.5679	2.6204	2.5546	2.6107	181468728.0
2006-01-30 11:00:00	AAPL	Stock	2.6118	2.6421	2.5936	2.6364	136250492.0
2006-01-30 12:00:00	AAPL	Stock	2.6361	2.7193	2.625	2.7061	273864220.0
2006-01-30 13:00:00	AAPL	Stock	2.7061	2.7314	2.6946	2.7246	182688352.0
2006-01-30 14:00:00	AAPL	Stock	2.7246	2.7357	2.6675	2.6777	210101136.0
2006-01-30 15:00:00	AAPL	Stock	2.6775	2.6939	2.6661	2.6857	172656372.0
2006-01-30 16:00:00	AAPL	Stock	2.6871	2.6996	2.6786	2.6854	3433668.0
2006-01-30 17:00:00	AAPL	Stock	2.6857	2.6918	2.6786	2.6918	5963664.0
2006-01-30 18:00:00	AAPL	Stock	2.6918	2.6986	2.6896	2.6964	844648.0
2006-01-30 07:00:00	MSFT	Stock	27.72	27.82	27.66	27.7	25300.0
2006-01-30 08:00:00	MSFT	Stock	27.75	27.78	27.66	27.74	123092.0
2006-01-30 09:00:00	MSFT	Stock	27.74	28.11	27.73	27.962	15655935.0
2006-01-30 10:00:00	MSFT	Stock	27.97	28.04	27.89	27.94	19000790.0
2006-01-30 11:00:00	MSFT	Stock	27.94	27.96	27.86	27.94	10549764.0
2006-01-30 12:00:00	MSFT	Stock	27.93	27.97	27.898	27.95	7416391.0
2006-01-30 13:00:00	MSFT	Stock	27.95	28.02	27.9	27.97	12553842.0
2006-01-30 14:00:00	MSFT	Stock	27.97	28.12	27.97	28.12	12217612.0
2006-01-30 15:00:00	MSFT	Stock	28.12	28.18	27.97	28.0	20919965.0
2006-01-30 16:00:00	MSFT	Stock	28.01	28.04	27.99	28.0	968251.0
2006-01-30 17:00:00	MSFT	Stock	28.02	28.04	28.0	28.02	702909.0
2006-01-30 18:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	309.0
2006-01-30 08:00:00	NVDA	Stock	0.3817	0.3817	0.3817	0.3817	24000.0
2006-01-30 09:00:00	NVDA	Stock	0.3858	0.3875	0.3801	0.3813	40259040.0
2006-01-30 10:00:00	NVDA	Stock	0.3812	0.3845	0.3804	0.3835	45643680.0
2006-01-30 11:00:00	NVDA	Stock	0.3835	0.3836	0.3807	0.3827	28923240.0
2006-01-30 12:00:00	NVDA	Stock	0.3827	0.3847	0.3824	0.3828	23465640.0
2006-01-30 13:00:00	NVDA	Stock	0.3827	0.3835	0.3818	0.3824	29168280.0
2006-01-30 14:00:00	NVDA	Stock	0.3824	0.3827	0.3808	0.3812	27887400.0
2006-01-30 15:00:00	NVDA	Stock	0.3811	0.3818	0.3793	0.3807	83354280.0
2006-01-30 16:00:00	NVDA	Stock	0.3808	0.3813	0.3807	0.3811	3053640.0
2006-01-30 09:00:00	AMZN	Stock	2.2615	2.2985	2.2615	2.278	20179900.0
2006-01-30 10:00:00	AMZN	Stock	2.2785	2.2795	2.252	2.2615	11555040.0
2006-01-30 11:00:00	AMZN	Stock	2.2605	2.2665	2.237	2.2375	8889920.0
2006-01-30 12:00:00	AMZN	Stock	2.2375	2.256	2.237	2.249	8021240.0
2006-01-30 13:00:00	AMZN	Stock	2.249	2.2625	2.2475	2.256	6594020.0
2006-01-30 14:00:00	AMZN	Stock	2.2555	2.2605	2.245	2.2455	7888440.0
2006-01-30 15:00:00	AMZN	Stock	2.2455	2.25	2.241	2.2485	12829480.0
2006-01-30 16:00:00	AMZN	Stock	2.248	2.2605	2.2445	2.2445	95000.0
2006-01-30 17:00:00	AMZN	Stock	2.246	2.252	2.246	2.252	1633500.0
2006-01-30 09:00:00	CL	Stock	28.035	28.05	27.9645	27.97	284000.0
2006-01-30 10:00:00	CL	Stock	27.955	27.975	27.825	27.84	540400.0
2006-01-30 11:00:00	CL	Stock	27.84	27.875	27.785	27.855	645600.0
2006-01-30 12:00:00	CL	Stock	27.855	27.89	27.8	27.85	635800.0
2006-01-30 13:00:00	CL	Stock	27.855	27.865	27.8	27.84	446000.0

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

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