PREVIEW / stock_1hour / 2006-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-20.parquet
  size:    611 KB
  rows:    28,743
  symbols: 2,216

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-20 05:00:00	AAPL	Stock	2.3214	2.3214	2.3214	2.3214	16408.0
2006-03-20 06:00:00	AAPL	Stock	2.3214	2.3214	2.3214	2.3214	176400.0
2006-03-20 07:00:00	AAPL	Stock	2.325	2.3304	2.3232	2.3232	120400.0
2006-03-20 08:00:00	AAPL	Stock	2.3214	2.33	2.3214	2.3246	2982084.0
2006-03-20 09:00:00	AAPL	Stock	2.3246	2.3379	2.3154	2.3154	117682460.0
2006-03-20 10:00:00	AAPL	Stock	2.3154	2.3196	2.2871	2.295	130850804.0
2006-03-20 11:00:00	AAPL	Stock	2.295	2.3282	2.2946	2.3039	72601256.0
2006-03-20 12:00:00	AAPL	Stock	2.3043	2.31	2.3011	2.3039	36418284.0
2006-03-20 13:00:00	AAPL	Stock	2.3036	2.3287	2.2857	2.2921	61382552.0
2006-03-20 14:00:00	AAPL	Stock	2.2921	2.2982	2.2821	2.2832	68371520.0
2006-03-20 15:00:00	AAPL	Stock	2.2829	2.2918	2.2811	2.2857	103379864.0
2006-03-20 16:00:00	AAPL	Stock	2.2857	2.2871	2.2839	2.2846	2172072.0
2006-03-20 17:00:00	AAPL	Stock	2.2839	2.2857	2.2839	2.2839	5031600.0
2006-03-20 18:00:00	AAPL	Stock	2.2836	2.2839	2.2832	2.2832	135800.0
2006-03-20 07:00:00	MSFT	Stock	27.59	27.64	27.55	27.56	18340.0
2006-03-20 08:00:00	MSFT	Stock	27.6	27.67	27.58	27.67	97297.0
2006-03-20 09:00:00	MSFT	Stock	27.66	27.79	27.64	27.73	9463082.0
2006-03-20 10:00:00	MSFT	Stock	27.74	27.93	27.71	27.9	15727260.0
2006-03-20 11:00:00	MSFT	Stock	27.91	27.97	27.87	27.94	9069421.0
2006-03-20 12:00:00	MSFT	Stock	27.95	27.99	27.87	27.98	7645719.0
2006-03-20 13:00:00	MSFT	Stock	27.98	27.99	27.93	27.93	6169422.0
2006-03-20 14:00:00	MSFT	Stock	27.94	27.95	27.87	27.9	6203356.0
2006-03-20 15:00:00	MSFT	Stock	27.9	27.91	27.86	27.89	11255081.0
2006-03-20 16:00:00	MSFT	Stock	27.89	27.89	27.8	27.86	374579.0
2006-03-20 17:00:00	MSFT	Stock	27.85	27.86	27.84	27.85	9246.0
2006-03-20 18:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	964.0
2006-03-20 08:00:00	NVDA	Stock	0.4072	0.41	0.4072	0.41	156000.0
2006-03-20 09:00:00	NVDA	Stock	0.4092	0.4101	0.4052	0.4062	49913400.0
2006-03-20 10:00:00	NVDA	Stock	0.4063	0.4079	0.4032	0.4039	45811920.0
2006-03-20 11:00:00	NVDA	Stock	0.4039	0.4071	0.4038	0.4067	50169720.0
2006-03-20 12:00:00	NVDA	Stock	0.4067	0.4077	0.406	0.4073	28082760.0
2006-03-20 13:00:00	NVDA	Stock	0.4073	0.4075	0.4057	0.4062	22447200.0
2006-03-20 14:00:00	NVDA	Stock	0.4062	0.4072	0.404	0.4041	33173280.0
2006-03-20 15:00:00	NVDA	Stock	0.4041	0.4042	0.4029	0.4032	59443680.0
2006-03-20 16:00:00	NVDA	Stock	0.4032	0.4038	0.4032	0.4033	249840.0
2006-03-20 17:00:00	NVDA	Stock	0.4029	0.4033	0.4028	0.4028	132000.0
2006-03-20 09:00:00	AMZN	Stock	1.7995	1.8255	1.79	1.825	14657020.0
2006-03-20 10:00:00	AMZN	Stock	1.825	1.8355	1.8125	1.835	19972220.0
2006-03-20 11:00:00	AMZN	Stock	1.835	1.8635	1.835	1.8565	17406400.0
2006-03-20 12:00:00	AMZN	Stock	1.8555	1.8565	1.8415	1.8475	14248580.0
2006-03-20 13:00:00	AMZN	Stock	1.8475	1.8475	1.8275	1.829	12001600.0
2006-03-20 14:00:00	AMZN	Stock	1.829	1.833	1.82	1.8205	11412200.0
2006-03-20 15:00:00	AMZN	Stock	1.82	1.8205	1.8095	1.8115	31699160.0
2006-03-20 16:00:00	AMZN	Stock	1.814	1.8145	1.8115	1.8125	156800.0
2006-03-20 17:00:00	AMZN	Stock	1.815	1.815	1.815	1.815	2000.0
2006-03-20 09:00:00	CL	Stock	28.47	28.545	28.405	28.425	453800.0
2006-03-20 10:00:00	CL	Stock	28.425	28.525	28.4205	28.5	684000.0
2006-03-20 11:00:00	CL	Stock	28.5	28.53	28.45	28.5	422200.0
2006-03-20 12:00:00	CL	Stock	28.5	28.525	28.465	28.5	319600.0
2006-03-20 13:00:00	CL	Stock	28.5	28.53	28.48	28.5	228600.0

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

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