PREVIEW / stock_1hour / 2009-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-10.parquet
  size:    874 KB
  rows:    42,488
  symbols: 3,400

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
2009-08-10 07:00:00	AAPL	Stock	5.9193	5.9643	5.9193	5.9457	132664.0
2009-08-10 08:00:00	AAPL	Stock	5.9382	5.9382	5.8982	5.925	1082116.0
2009-08-10 09:00:00	AAPL	Stock	5.9218	5.95	5.8936	5.9283	49336056.0
2009-08-10 10:00:00	AAPL	Stock	5.9286	5.9357	5.9007	5.9054	50254288.0
2009-08-10 11:00:00	AAPL	Stock	5.905	5.9143	5.8811	5.8911	40276124.0
2009-08-10 12:00:00	AAPL	Stock	5.8911	5.9036	5.8721	5.8746	31542252.0
2009-08-10 13:00:00	AAPL	Stock	5.8743	5.8811	5.8593	5.8664	33794964.0
2009-08-10 14:00:00	AAPL	Stock	5.8668	5.8714	5.845	5.8632	35203364.0
2009-08-10 15:00:00	AAPL	Stock	5.8639	5.8861	5.8629	5.8829	53045188.0
2009-08-10 16:00:00	AAPL	Stock	5.8807	5.893	5.8807	5.8829	4400256.0
2009-08-10 17:00:00	AAPL	Stock	5.8839	5.8839	5.8764	5.8789	99736.0
2009-08-10 18:00:00	AAPL	Stock	5.8793	5.8829	5.875	5.875	272496.0
2009-08-10 19:00:00	AAPL	Stock	5.8721	5.8814	5.8714	5.875	74872.0
2009-08-10 04:00:00	MSFT	Stock	23.56	23.56	23.56	23.56	200.0
2009-08-10 07:00:00	MSFT	Stock	23.58	23.58	23.44	23.44	1525.0
2009-08-10 08:00:00	MSFT	Stock	23.56	23.62	23.5	23.5	15888.0
2009-08-10 09:00:00	MSFT	Stock	23.5	23.55	23.34	23.44	4016059.0
2009-08-10 10:00:00	MSFT	Stock	23.44	23.53	23.39	23.42	4025989.0
2009-08-10 11:00:00	MSFT	Stock	23.42	23.46	23.37	23.39	3353111.0
2009-08-10 12:00:00	MSFT	Stock	23.4	23.44	23.37	23.382	2663635.0
2009-08-10 13:00:00	MSFT	Stock	23.39	23.42	23.32	23.36	3429663.0
2009-08-10 14:00:00	MSFT	Stock	23.36	23.4	23.31	23.39	3898988.0
2009-08-10 15:00:00	MSFT	Stock	23.39	23.42	23.3	23.42	9085941.0
2009-08-10 16:00:00	MSFT	Stock	23.42	23.44	23.333	23.42	1338772.0
2009-08-10 17:00:00	MSFT	Stock	23.4	23.42	23.38	23.4	6634.0
2009-08-10 18:00:00	MSFT	Stock	23.38	23.4	23.38	23.4	1520.0
2009-08-10 19:00:00	MSFT	Stock	23.39	23.4	23.37	23.37	5976.0
2009-08-10 08:00:00	NVDA	Stock	0.3488	0.3488	0.3402	0.3438	317800.0
2009-08-10 09:00:00	NVDA	Stock	0.3433	0.3475	0.3375	0.3383	88770320.0
2009-08-10 10:00:00	NVDA	Stock	0.3382	0.3398	0.3358	0.3375	103995320.0
2009-08-10 11:00:00	NVDA	Stock	0.3375	0.3502	0.335	0.3358	88111640.0
2009-08-10 12:00:00	NVDA	Stock	0.3358	0.3358	0.3295	0.3308	83566160.0
2009-08-10 13:00:00	NVDA	Stock	0.331	0.3355	0.3305	0.333	113898280.0
2009-08-10 14:00:00	NVDA	Stock	0.3329	0.333	0.33	0.3313	75692120.0
2009-08-10 15:00:00	NVDA	Stock	0.3313	0.3322	0.33	0.331	121213240.0
2009-08-10 16:00:00	NVDA	Stock	0.3315	0.3384	0.33	0.3315	14968760.0
2009-08-10 17:00:00	NVDA	Stock	0.3315	0.3315	0.3315	0.3315	6480.0
2009-08-10 18:00:00	NVDA	Stock	0.3315	0.3315	0.3303	0.331	35400.0
2009-08-10 19:00:00	NVDA	Stock	0.3308	0.3325	0.3303	0.3325	56920.0
2009-08-10 08:00:00	AMZN	Stock	4.25	4.255	4.25	4.255	40000.0
2009-08-10 09:00:00	AMZN	Stock	4.247	4.2735	4.239	4.243	12851500.0
2009-08-10 10:00:00	AMZN	Stock	4.2425	4.2453	4.194	4.216	19335500.0
2009-08-10 11:00:00	AMZN	Stock	4.2165	4.2295	4.195	4.2	8787920.0
2009-08-10 12:00:00	AMZN	Stock	4.201	4.2115	4.179	4.192	6919040.0
2009-08-10 13:00:00	AMZN	Stock	4.1915	4.199	4.171	4.1885	8839520.0
2009-08-10 14:00:00	AMZN	Stock	4.1885	4.1905	4.1635	4.1875	8259820.0
2009-08-10 15:00:00	AMZN	Stock	4.1875	4.222	4.1865	4.222	19340060.0
2009-08-10 16:00:00	AMZN	Stock	4.222	4.2255	4.1984	4.222	894820.0
2009-08-10 17:00:00	AMZN	Stock	4.222	4.222	4.2215	4.2215	4900.0
2009-08-10 18:00:00	AMZN	Stock	4.222	4.222	4.21	4.21	127240.0

> showing 50 of 42,488 rows — these rows as CSV

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