PREVIEW / stock_1hour / 2009-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-04.parquet
  size:    885 KB
  rows:    42,596
  symbols: 3,381

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-04 04:00:00	AAPL	Stock	5.9364	5.9364	5.9364	5.9364	2800.0
2009-08-04 06:00:00	AAPL	Stock	5.9107	5.9107	5.9107	5.9107	14000.0
2009-08-04 07:00:00	AAPL	Stock	5.8936	5.9179	5.8929	5.9179	75600.0
2009-08-04 08:00:00	AAPL	Stock	5.9107	5.925	5.9	5.9107	1493828.0
2009-08-04 09:00:00	AAPL	Stock	5.9125	5.9132	5.8707	5.8957	71722840.0
2009-08-04 10:00:00	AAPL	Stock	5.8957	5.9032	5.8689	5.8925	66835496.0
2009-08-04 11:00:00	AAPL	Stock	5.8918	5.9071	5.8861	5.9025	42125636.0
2009-08-04 12:00:00	AAPL	Stock	5.9018	5.91	5.8896	5.9046	42869988.0
2009-08-04 13:00:00	AAPL	Stock	5.9054	5.9114	5.8714	5.8754	37687972.0
2009-08-04 14:00:00	AAPL	Stock	5.8754	5.8929	5.8707	5.8764	38343508.0
2009-08-04 15:00:00	AAPL	Stock	5.8768	5.9125	5.8646	5.9107	75490828.0
2009-08-04 16:00:00	AAPL	Stock	5.9107	5.9146	5.8911	5.9125	16407608.0
2009-08-04 17:00:00	AAPL	Stock	5.9439	5.9439	5.9107	5.9107	440216.0
2009-08-04 18:00:00	AAPL	Stock	5.9125	5.9129	5.9075	5.9075	335216.0
2009-08-04 19:00:00	AAPL	Stock	5.9121	5.9204	5.9071	5.9189	190960.0
2009-08-04 07:00:00	MSFT	Stock	23.7	23.7	23.7	23.7	1200.0
2009-08-04 08:00:00	MSFT	Stock	23.7	23.74	23.63	23.65	21190.0
2009-08-04 09:00:00	MSFT	Stock	23.67	23.75	23.6	23.7	4637850.0
2009-08-04 10:00:00	MSFT	Stock	23.7	23.75	23.55	23.55	8947715.0
2009-08-04 11:00:00	MSFT	Stock	23.55	23.64	23.53	23.55	6346499.0
2009-08-04 12:00:00	MSFT	Stock	23.55	23.67	23.54	23.65	5197857.0
2009-08-04 13:00:00	MSFT	Stock	23.65	23.7	23.59	23.62	4920895.0
2009-08-04 14:00:00	MSFT	Stock	23.62	23.68	23.57	23.6	5106586.0
2009-08-04 15:00:00	MSFT	Stock	23.6	23.77	23.56	23.76	8994482.0
2009-08-04 16:00:00	MSFT	Stock	23.76	23.8	23.622	23.76	3492060.0
2009-08-04 17:00:00	MSFT	Stock	23.58	23.84	23.58	23.83	101013.0
2009-08-04 18:00:00	MSFT	Stock	23.84	23.84	23.77	23.77	7490.0
2009-08-04 19:00:00	MSFT	Stock	23.77	23.78	23.77	23.78	800.0
2009-08-04 08:00:00	NVDA	Stock	0.3258	0.328	0.3258	0.328	410880.0
2009-08-04 09:00:00	NVDA	Stock	0.328	0.3305	0.3258	0.3303	100251400.0
2009-08-04 10:00:00	NVDA	Stock	0.3303	0.3348	0.3288	0.331	120058240.0
2009-08-04 11:00:00	NVDA	Stock	0.331	0.3368	0.3308	0.3348	121094040.0
2009-08-04 12:00:00	NVDA	Stock	0.335	0.3382	0.3345	0.338	77530960.0
2009-08-04 13:00:00	NVDA	Stock	0.3382	0.34	0.333	0.3338	70409280.0
2009-08-04 14:00:00	NVDA	Stock	0.3335	0.3375	0.3335	0.3348	62875280.0
2009-08-04 15:00:00	NVDA	Stock	0.3348	0.3353	0.3318	0.3342	128307280.0
2009-08-04 16:00:00	NVDA	Stock	0.3342	0.335	0.3334	0.335	12735680.0
2009-08-04 17:00:00	NVDA	Stock	0.332	0.3338	0.332	0.3338	32000.0
2009-08-04 18:00:00	NVDA	Stock	0.3338	0.3338	0.33	0.33	28000.0
2009-08-04 19:00:00	NVDA	Stock	0.3325	0.3338	0.3325	0.3338	28000.0
2009-08-04 07:00:00	AMZN	Stock	4.328	4.3575	4.328	4.3575	8000.0
2009-08-04 08:00:00	AMZN	Stock	4.35	4.35	4.328	4.3435	62660.0
2009-08-04 09:00:00	AMZN	Stock	4.345	4.374	4.3178	4.329	14359680.0
2009-08-04 10:00:00	AMZN	Stock	4.329	4.336	4.3025	4.309	21314260.0
2009-08-04 11:00:00	AMZN	Stock	4.309	4.334	4.306	4.329	12929220.0
2009-08-04 12:00:00	AMZN	Stock	4.328	4.3395	4.3095	4.324	9919940.0
2009-08-04 13:00:00	AMZN	Stock	4.324	4.3275	4.2725	4.2745	11475920.0
2009-08-04 14:00:00	AMZN	Stock	4.274	4.2865	4.251	4.257	17540860.0
2009-08-04 15:00:00	AMZN	Stock	4.256	4.3163	4.2465	4.29	30567780.0
2009-08-04 16:00:00	AMZN	Stock	4.29	4.3	4.2725	4.2875	3995620.0

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

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