PREVIEW / stock_1hour / 2008-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-05.parquet
  size:    845 KB
  rows:    40,454
  symbols: 3,288

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
2008-05-05 05:00:00	AAPL	Stock	6.4114	6.4114	6.4114	6.4114	13300.0
2008-05-05 06:00:00	AAPL	Stock	6.4586	6.4586	6.4586	6.4586	2800.0
2008-05-05 07:00:00	AAPL	Stock	6.4461	6.4461	6.4214	6.4421	193424.0
2008-05-05 08:00:00	AAPL	Stock	6.4375	6.4846	6.4371	6.4821	2958928.0
2008-05-05 09:00:00	AAPL	Stock	6.4807	6.5818	6.4621	6.5643	154505540.0
2008-05-05 10:00:00	AAPL	Stock	6.5639	6.6182	6.5629	6.5836	204917916.0
2008-05-05 11:00:00	AAPL	Stock	6.5832	6.5982	6.5643	6.5943	86098656.0
2008-05-05 12:00:00	AAPL	Stock	6.5946	6.615	6.5764	6.5861	62598872.0
2008-05-05 13:00:00	AAPL	Stock	6.586	6.5893	6.52	6.5414	102301948.0
2008-05-05 14:00:00	AAPL	Stock	6.5414	6.5971	6.5332	6.5749	91236236.0
2008-05-05 15:00:00	AAPL	Stock	6.5746	6.5986	6.5482	6.5896	124496848.0
2008-05-05 16:00:00	AAPL	Stock	6.5907	6.5975	6.5621	6.5886	13130908.0
2008-05-05 17:00:00	AAPL	Stock	6.5918	6.5971	6.4621	6.5893	657104.0
2008-05-05 18:00:00	AAPL	Stock	6.5918	6.5929	6.5882	6.5929	79604.0
2008-05-05 19:00:00	AAPL	Stock	6.5925	6.5929	6.5893	6.5929	188412.0
2008-05-05 20:00:00	AAPL	Stock	6.5604	6.5604	6.5604	6.5604	424536.0
2008-05-05 04:00:00	MSFT	Stock	30.4	30.5	30.25	30.3	24254.0
2008-05-05 05:00:00	MSFT	Stock	30.3	30.5	30.25	30.25	22727.0
2008-05-05 06:00:00	MSFT	Stock	30.45	31.13	30.35	30.9	116758.0
2008-05-05 07:00:00	MSFT	Stock	30.9	31.0	30.4	30.6	1751863.0
2008-05-05 08:00:00	MSFT	Stock	30.55	31.0	29.77	29.9	6923243.0
2008-05-05 09:00:00	MSFT	Stock	29.9	30.23	29.24	29.92	20758065.0
2008-05-05 10:00:00	MSFT	Stock	29.91	30.06	29.79	29.847	17931437.0
2008-05-05 11:00:00	MSFT	Stock	29.85	29.95	29.625	29.69	11513023.0
2008-05-05 12:00:00	MSFT	Stock	29.69	29.72	29.32	29.44	12972323.0
2008-05-05 13:00:00	MSFT	Stock	29.44	29.445	29.22	29.305	10375967.0
2008-05-05 14:00:00	MSFT	Stock	29.3	29.41	29.16	29.16	11903542.0
2008-05-05 15:00:00	MSFT	Stock	29.165	29.48	28.99	29.05	18685596.0
2008-05-05 16:00:00	MSFT	Stock	29.05	30.03	29.034	29.07	4126609.0
2008-05-05 17:00:00	MSFT	Stock	29.06	29.495	29.06	29.1	101534.0
2008-05-05 18:00:00	MSFT	Stock	29.1	29.11	29.08	29.1	17380.0
2008-05-05 19:00:00	MSFT	Stock	29.11	29.13	29.05	29.07	35436.0
2008-05-05 20:00:00	MSFT	Stock	29.91	29.91	29.91	29.91	31773.0
2008-05-05 07:00:00	NVDA	Stock	0.562	0.562	0.562	0.562	8000.0
2008-05-05 08:00:00	NVDA	Stock	0.5625	0.5665	0.56	0.5602	259000.0
2008-05-05 09:00:00	NVDA	Stock	0.56	0.5618	0.5505	0.5512	94663680.0
2008-05-05 10:00:00	NVDA	Stock	0.5512	0.5588	0.55	0.55	168175960.0
2008-05-05 11:00:00	NVDA	Stock	0.55	0.556	0.548	0.5545	159020920.0
2008-05-05 12:00:00	NVDA	Stock	0.5545	0.5568	0.5518	0.5548	122425600.0
2008-05-05 13:00:00	NVDA	Stock	0.555	0.555	0.55	0.5512	99124200.0
2008-05-05 14:00:00	NVDA	Stock	0.5511	0.5532	0.549	0.5492	81470520.0
2008-05-05 15:00:00	NVDA	Stock	0.5495	0.5505	0.5478	0.5492	131115760.0
2008-05-05 16:00:00	NVDA	Stock	0.549	0.5562	0.5485	0.5562	80419640.0
2008-05-05 17:00:00	NVDA	Stock	0.5572	0.5588	0.555	0.5562	868000.0
2008-05-05 18:00:00	NVDA	Stock	0.5562	0.5562	0.5558	0.5562	80000.0
2008-05-05 19:00:00	NVDA	Stock	0.556	0.556	0.556	0.556	20000.0
2008-05-05 08:00:00	AMZN	Stock	3.888	3.888	3.865	3.865	15900.0
2008-05-05 09:00:00	AMZN	Stock	3.865	3.8885	3.8335	3.8375	16652800.0
2008-05-05 10:00:00	AMZN	Stock	3.837	3.8675	3.825	3.83	23467640.0
2008-05-05 11:00:00	AMZN	Stock	3.8295	3.8455	3.8085	3.811	11588420.0

> showing 50 of 40,454 rows — these rows as CSV

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