PREVIEW / stock_1hour / 2008-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-29.parquet
  size:    819 KB
  rows:    39,830
  symbols: 3,316

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-08-29 07:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-08-29 08:00:00	AAPL	Stock	6.1839	6.205	6.1689	6.1707	1490972.0
2008-08-29 09:00:00	AAPL	Stock	6.1704	6.1964	6.1432	6.1711	73816428.0
2008-08-29 10:00:00	AAPL	Stock	6.17	6.1796	6.0786	6.0843	120935528.0
2008-08-29 11:00:00	AAPL	Stock	6.0843	6.1107	6.0746	6.0789	66080476.0
2008-08-29 12:00:00	AAPL	Stock	6.08	6.0814	6.0371	6.0804	74597460.0
2008-08-29 13:00:00	AAPL	Stock	6.0807	6.1061	6.0536	6.0586	67494504.0
2008-08-29 14:00:00	AAPL	Stock	6.0586	6.0846	6.0575	6.0764	39841788.0
2008-08-29 15:00:00	AAPL	Stock	6.0764	6.0768	6.0425	6.058	81809840.0
2008-08-29 16:00:00	AAPL	Stock	6.0536	6.0966	6.0446	6.05	26524652.0
2008-08-29 17:00:00	AAPL	Stock	6.0518	6.0546	6.0482	6.0482	1911140.0
2008-08-29 18:00:00	AAPL	Stock	6.0518	6.0518	6.05	6.05	39564.0
2008-08-29 19:00:00	AAPL	Stock	6.0532	6.0554	6.0518	6.0518	25844.0
2008-08-29 07:00:00	MSFT	Stock	27.5	27.67	27.5	27.6	2803.0
2008-08-29 08:00:00	MSFT	Stock	27.69	27.7	27.6	27.61	5747.0
2008-08-29 09:00:00	MSFT	Stock	27.61	27.79	27.6	27.67	4871840.0
2008-08-29 10:00:00	MSFT	Stock	27.67	27.7	27.45	27.47	7762231.0
2008-08-29 11:00:00	MSFT	Stock	27.48	27.54	27.41	27.428	5736501.0
2008-08-29 12:00:00	MSFT	Stock	27.43	27.45	27.31	27.43	4555614.0
2008-08-29 13:00:00	MSFT	Stock	27.42	27.56	27.42	27.53	3229886.0
2008-08-29 14:00:00	MSFT	Stock	27.535	27.62	27.48	27.56	4807496.0
2008-08-29 15:00:00	MSFT	Stock	27.56	27.58	27.32	27.32	9729984.0
2008-08-29 16:00:00	MSFT	Stock	27.33	27.516	27.284	27.31	7786389.0
2008-08-29 17:00:00	MSFT	Stock	27.29	27.34	27.29	27.33	578285.0
2008-08-29 18:00:00	MSFT	Stock	27.32	27.33	27.28	27.29	13290.0
2008-08-29 19:00:00	MSFT	Stock	27.29	27.3	27.27	27.29	5100.0
2008-08-29 08:00:00	NVDA	Stock	0.3305	0.3305	0.3253	0.3253	192000.0
2008-08-29 09:00:00	NVDA	Stock	0.3253	0.3253	0.3188	0.3188	89693400.0
2008-08-29 10:00:00	NVDA	Stock	0.3188	0.3203	0.3165	0.3193	102580440.0
2008-08-29 11:00:00	NVDA	Stock	0.3193	0.3195	0.3175	0.3175	43338360.0
2008-08-29 12:00:00	NVDA	Stock	0.3178	0.3178	0.316	0.3173	45860160.0
2008-08-29 13:00:00	NVDA	Stock	0.3173	0.3198	0.3173	0.3185	43069760.0
2008-08-29 14:00:00	NVDA	Stock	0.3188	0.3195	0.3168	0.3175	52490680.0
2008-08-29 15:00:00	NVDA	Stock	0.3175	0.3178	0.315	0.3163	96472000.0
2008-08-29 16:00:00	NVDA	Stock	0.3163	0.3183	0.3138	0.315	27281720.0
2008-08-29 17:00:00	NVDA	Stock	0.316	0.316	0.315	0.315	1640600.0
2008-08-29 19:00:00	NVDA	Stock	0.3158	0.3158	0.3158	0.3158	8000.0
2008-08-29 09:00:00	AMZN	Stock	4.141	4.1515	4.1005	4.104	9388080.0
2008-08-29 10:00:00	AMZN	Stock	4.1045	4.107	4.036	4.0515	16911520.0
2008-08-29 11:00:00	AMZN	Stock	4.0515	4.0685	4.025	4.0535	9487680.0
2008-08-29 12:00:00	AMZN	Stock	4.054	4.0725	4.041	4.072	12994880.0
2008-08-29 13:00:00	AMZN	Stock	4.0715	4.082	4.0535	4.061	12435120.0
2008-08-29 14:00:00	AMZN	Stock	4.0605	4.0735	4.0415	4.0595	8705120.0
2008-08-29 15:00:00	AMZN	Stock	4.06	4.061	4.039	4.0405	16399980.0
2008-08-29 16:00:00	AMZN	Stock	4.044	4.0653	4.0375	4.0405	6305060.0
2008-08-29 17:00:00	AMZN	Stock	4.0405	4.0405	4.0405	4.0405	443680.0
2008-08-29 18:00:00	AMZN	Stock	4.0585	4.0585	4.0585	4.0585	2000.0
2008-08-29 07:00:00	TLT	Stock	94.25	94.25	94.25	94.25	100.0
2008-08-29 08:00:00	TLT	Stock	94.5	94.5	94.45	94.45	800.0
2008-08-29 09:00:00	TLT	Stock	94.28	94.28	93.69	93.85	374304.0

> showing 50 of 39,830 rows — these rows as CSV

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