PREVIEW / stock_1hour / 2010-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-24.parquet
  size:    906 KB
  rows:    43,056
  symbols: 3,457

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
2010-03-24 04:00:00	AAPL	Stock	8.1596	8.1596	8.1346	8.1346	30044.0
2010-03-24 05:00:00	AAPL	Stock	8.1	8.1107	8.1	8.1107	42476.0
2010-03-24 06:00:00	AAPL	Stock	8.1111	8.1179	8.1079	8.1079	64400.0
2010-03-24 07:00:00	AAPL	Stock	8.125	8.1304	8.1114	8.1254	404684.0
2010-03-24 08:00:00	AAPL	Stock	8.1254	8.1432	8.1189	8.1286	1944180.0
2010-03-24 09:00:00	AAPL	Stock	8.13	8.1921	8.1161	8.1785	92190224.0
2010-03-24 10:00:00	AAPL	Stock	8.1775	8.2214	8.1571	8.2108	120785392.0
2010-03-24 11:00:00	AAPL	Stock	8.2107	8.2196	8.1682	8.2082	74512732.0
2010-03-24 12:00:00	AAPL	Stock	8.208	8.2129	8.1943	8.2029	34605956.0
2010-03-24 13:00:00	AAPL	Stock	8.2029	8.21	8.1857	8.2	41665120.0
2010-03-24 14:00:00	AAPL	Stock	8.1997	8.2161	8.1843	8.1868	52702944.0
2010-03-24 15:00:00	AAPL	Stock	8.1871	8.2129	8.1829	8.1914	84319116.0
2010-03-24 16:00:00	AAPL	Stock	8.1918	8.2035	8.16	8.1971	6786472.0
2010-03-24 17:00:00	AAPL	Stock	8.1964	8.1971	8.1893	8.1968	130788.0
2010-03-24 18:00:00	AAPL	Stock	8.1911	8.1964	8.1911	8.1946	174916.0
2010-03-24 19:00:00	AAPL	Stock	8.1911	8.1993	8.1911	8.1925	332696.0
2010-03-24 06:00:00	MSFT	Stock	29.67	29.67	29.67	29.67	1000.0
2010-03-24 07:00:00	MSFT	Stock	29.69	29.74	29.69	29.71	4042.0
2010-03-24 08:00:00	MSFT	Stock	29.84	29.84	29.77	29.79	14958.0
2010-03-24 09:00:00	MSFT	Stock	29.8	29.8	29.6	29.72	4208172.0
2010-03-24 10:00:00	MSFT	Stock	29.72	29.85	29.68	29.75	5995406.0
2010-03-24 11:00:00	MSFT	Stock	29.755	29.79	29.62	29.78	4639413.0
2010-03-24 12:00:00	MSFT	Stock	29.79	29.8	29.71	29.77	2838302.0
2010-03-24 13:00:00	MSFT	Stock	29.76	29.77	29.63	29.72	4011812.0
2010-03-24 14:00:00	MSFT	Stock	29.72	29.73	29.64	29.668	3698437.0
2010-03-24 15:00:00	MSFT	Stock	29.67	29.75	29.63	29.66	6185608.0
2010-03-24 16:00:00	MSFT	Stock	29.66	29.713	29.6	29.62	1774959.0
2010-03-24 17:00:00	MSFT	Stock	29.838	29.838	29.6	29.6	80100.0
2010-03-24 18:00:00	MSFT	Stock	29.67	29.67	29.6	29.65	6448.0
2010-03-24 19:00:00	MSFT	Stock	29.67	29.67	29.61	29.61	2100.0
2010-03-24 08:00:00	NVDA	Stock	0.4458	0.4462	0.4312	0.4458	240240.0
2010-03-24 09:00:00	NVDA	Stock	0.445	0.4452	0.438	0.4412	34946880.0
2010-03-24 10:00:00	NVDA	Stock	0.4412	0.4415	0.4368	0.4382	88883120.0
2010-03-24 11:00:00	NVDA	Stock	0.438	0.4395	0.434	0.4345	83677160.0
2010-03-24 12:00:00	NVDA	Stock	0.4348	0.4375	0.4345	0.4355	49526720.0
2010-03-24 13:00:00	NVDA	Stock	0.4358	0.4358	0.4328	0.4338	44992240.0
2010-03-24 14:00:00	NVDA	Stock	0.434	0.4344	0.432	0.4328	44187120.0
2010-03-24 15:00:00	NVDA	Stock	0.4325	0.4335	0.4314	0.4328	81555800.0
2010-03-24 16:00:00	NVDA	Stock	0.4332	0.4362	0.4312	0.433	1871120.0
2010-03-24 17:00:00	NVDA	Stock	0.432	0.432	0.432	0.432	4160.0
2010-03-24 18:00:00	NVDA	Stock	0.433	0.4335	0.433	0.4335	168000.0
2010-03-24 19:00:00	NVDA	Stock	0.434	0.434	0.4325	0.4335	32000.0
2010-03-24 08:00:00	AMZN	Stock	6.4425	6.4425	6.4425	6.4425	2000.0
2010-03-24 09:00:00	AMZN	Stock	6.439	6.47	6.405	6.4155	12757300.0
2010-03-24 10:00:00	AMZN	Stock	6.413	6.422	6.3745	6.3965	24105500.0
2010-03-24 11:00:00	AMZN	Stock	6.3973	6.407	6.36	6.395	14339860.0
2010-03-24 12:00:00	AMZN	Stock	6.3955	6.4185	6.381	6.3935	8860520.0
2010-03-24 13:00:00	AMZN	Stock	6.3925	6.3975	6.3725	6.3885	7782100.0
2010-03-24 14:00:00	AMZN	Stock	6.389	6.41	6.3785	6.399	7866020.0
2010-03-24 15:00:00	AMZN	Stock	6.399	6.418	6.395	6.404	13205360.0

> showing 50 of 43,056 rows — these rows as CSV

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