PREVIEW / stock_1hour / 2008-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-17.parquet
  size:    831 KB
  rows:    39,978
  symbols: 3,312

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-06-17 07:00:00	AAPL	Stock	6.3425	6.3536	6.3393	6.3464	231532.0
2008-06-17 08:00:00	AAPL	Stock	6.3482	6.3586	6.3157	6.3525	6104224.0
2008-06-17 09:00:00	AAPL	Stock	6.3529	6.4211	6.3361	6.4111	147118048.0
2008-06-17 10:00:00	AAPL	Stock	6.4111	6.4714	6.3775	6.4572	182805028.0
2008-06-17 11:00:00	AAPL	Stock	6.4579	6.4739	6.4171	6.4268	101956876.0
2008-06-17 12:00:00	AAPL	Stock	6.4268	6.4521	6.4196	6.4489	67705484.0
2008-06-17 13:00:00	AAPL	Stock	6.4493	6.4832	6.445	6.475	100554188.0
2008-06-17 14:00:00	AAPL	Stock	6.4744	6.4996	6.4536	6.4954	100232440.0
2008-06-17 15:00:00	AAPL	Stock	6.4954	6.4989	6.4418	6.4793	157983168.0
2008-06-17 16:00:00	AAPL	Stock	6.4793	6.4857	6.4424	6.4854	5699624.0
2008-06-17 17:00:00	AAPL	Stock	6.4821	6.4882	6.3501	6.4861	302120.0
2008-06-17 18:00:00	AAPL	Stock	6.4907	6.4929	6.4829	6.4875	442372.0
2008-06-17 19:00:00	AAPL	Stock	6.4857	6.4889	6.4832	6.4875	127652.0
2008-06-17 07:00:00	MSFT	Stock	29.25	29.25	29.1	29.1	2046.0
2008-06-17 08:00:00	MSFT	Stock	29.0	29.08	28.98	29.05	72313.0
2008-06-17 09:00:00	MSFT	Stock	29.05	29.12	28.81	28.85	4830681.0
2008-06-17 10:00:00	MSFT	Stock	28.84	29.06	28.82	29.04	8107351.0
2008-06-17 11:00:00	MSFT	Stock	29.04	29.12	28.87	28.88	7176142.0
2008-06-17 12:00:00	MSFT	Stock	28.88	29.0	28.81	28.845	4409125.0
2008-06-17 13:00:00	MSFT	Stock	28.85	29.0	28.82	28.91	4068842.0
2008-06-17 14:00:00	MSFT	Stock	28.92	29.0	28.9	28.95	4984067.0
2008-06-17 15:00:00	MSFT	Stock	28.95	28.97	28.79	28.8	8028833.0
2008-06-17 16:00:00	MSFT	Stock	28.8	28.979	28.75	28.8	975062.0
2008-06-17 17:00:00	MSFT	Stock	28.79	28.79	28.77	28.77	7145.0
2008-06-17 18:00:00	MSFT	Stock	28.8	28.85	28.8	28.85	3271.0
2008-06-17 19:00:00	MSFT	Stock	28.82	28.82	28.78	28.8	4440.0
2008-06-17 08:00:00	NVDA	Stock	0.5305	0.535	0.5305	0.535	187400.0
2008-06-17 09:00:00	NVDA	Stock	0.535	0.5355	0.5255	0.5287	59746320.0
2008-06-17 10:00:00	NVDA	Stock	0.529	0.5315	0.5242	0.528	99319720.0
2008-06-17 11:00:00	NVDA	Stock	0.5278	0.5302	0.522	0.5235	61460520.0
2008-06-17 12:00:00	NVDA	Stock	0.5235	0.524	0.5168	0.5173	73349480.0
2008-06-17 13:00:00	NVDA	Stock	0.517	0.5182	0.5125	0.5182	116235760.0
2008-06-17 14:00:00	NVDA	Stock	0.518	0.5213	0.5165	0.5172	89783960.0
2008-06-17 15:00:00	NVDA	Stock	0.517	0.5178	0.5115	0.5128	168292800.0
2008-06-17 16:00:00	NVDA	Stock	0.5125	0.5202	0.5125	0.5138	10227200.0
2008-06-17 17:00:00	NVDA	Stock	0.5162	0.5162	0.5128	0.5128	103400.0
2008-06-17 18:00:00	NVDA	Stock	0.5158	0.5158	0.5158	0.5158	10000.0
2008-06-17 19:00:00	NVDA	Stock	0.5158	0.5165	0.5158	0.5165	40000.0
2008-06-17 07:00:00	AMZN	Stock	4.095	4.1025	4.095	4.1025	155360.0
2008-06-17 08:00:00	AMZN	Stock	4.12	4.161	4.11	4.161	500480.0
2008-06-17 09:00:00	AMZN	Stock	4.16	4.2	4.14	4.1795	32679740.0
2008-06-17 10:00:00	AMZN	Stock	4.1805	4.197	4.161	4.176	29281600.0
2008-06-17 11:00:00	AMZN	Stock	4.1755	4.198	4.167	4.1695	28415000.0
2008-06-17 12:00:00	AMZN	Stock	4.169	4.191	4.168	4.1775	12698320.0
2008-06-17 13:00:00	AMZN	Stock	4.1765	4.21	4.1545	4.207	20419940.0
2008-06-17 14:00:00	AMZN	Stock	4.2065	4.215	4.1905	4.1975	14703960.0
2008-06-17 15:00:00	AMZN	Stock	4.1983	4.2004	4.146	4.146	31731020.0
2008-06-17 16:00:00	AMZN	Stock	4.1475	4.1886	4.1445	4.1445	2498520.0
2008-06-17 17:00:00	AMZN	Stock	4.156	4.1675	4.156	4.1625	39000.0
2008-06-17 18:00:00	AMZN	Stock	4.1575	4.1725	4.1575	4.1725	22000.0

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

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