PREVIEW / stock_30min / 2010-06-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-07.parquet
  size:    1.4 MB
  rows:    73,208
  symbols: 3,472

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-06-07 05:30:00	AAPL	Stock	9.1754	9.1754	9.1754	9.1754	2800.0
2010-06-07 06:00:00	AAPL	Stock	9.1964	9.2193	9.1964	9.2071	31948.0
2010-06-07 06:30:00	AAPL	Stock	9.2143	9.2143	9.2143	9.2143	8400.0
2010-06-07 07:00:00	AAPL	Stock	9.2143	9.2468	9.1964	9.2368	375788.0
2010-06-07 07:30:00	AAPL	Stock	9.2411	9.2418	9.2111	9.2143	361592.0
2010-06-07 08:00:00	AAPL	Stock	9.2161	9.2461	9.1964	9.2461	2679488.0
2010-06-07 08:30:00	AAPL	Stock	9.2414	9.2571	9.2236	9.2261	1991164.0
2010-06-07 09:00:00	AAPL	Stock	9.2293	9.2436	9.2089	9.2271	2123352.0
2010-06-07 09:30:00	AAPL	Stock	9.2246	9.2554	9.1521	9.235	96386052.0
2010-06-07 10:00:00	AAPL	Stock	9.235	9.2371	9.1554	9.1643	52976028.0
2010-06-07 10:30:00	AAPL	Stock	9.1643	9.1693	9.0104	9.0268	77202244.0
2010-06-07 11:00:00	AAPL	Stock	9.0268	9.0579	9.005	9.0517	50083096.0
2010-06-07 11:30:00	AAPL	Stock	9.0536	9.1004	9.0475	9.0979	44798488.0
2010-06-07 12:00:00	AAPL	Stock	9.0979	9.1243	9.0714	9.075	25140640.0
2010-06-07 12:30:00	AAPL	Stock	9.0755	9.1643	9.0736	9.1518	37208556.0
2010-06-07 13:00:00	AAPL	Stock	9.1532	9.1553	9.0796	9.115	42737044.0
2010-06-07 13:30:00	AAPL	Stock	9.1177	9.1875	9.0718	9.0989	99250592.0
2010-06-07 14:00:00	AAPL	Stock	9.1011	9.1214	9.0114	9.0443	64895404.0
2010-06-07 14:30:00	AAPL	Stock	9.0429	9.0479	8.9704	9.0364	91632548.0
2010-06-07 15:00:00	AAPL	Stock	9.0404	9.0629	8.9696	8.9696	79273880.0
2010-06-07 15:30:00	AAPL	Stock	8.9697	9.0051	8.9482	8.9625	96022696.0
2010-06-07 16:00:00	AAPL	Stock	8.9625	8.975	8.9586	8.9654	12741148.0
2010-06-07 16:30:00	AAPL	Stock	8.9643	8.9732	8.9618	8.9709	1051232.0
2010-06-07 17:00:00	AAPL	Stock	8.9679	8.9846	8.9571	8.9846	550172.0
2010-06-07 17:30:00	AAPL	Stock	8.9868	8.9871	8.9664	8.9746	207396.0
2010-06-07 18:00:00	AAPL	Stock	8.975	8.98	8.9646	8.98	174244.0
2010-06-07 18:30:00	AAPL	Stock	8.98	8.98	8.9621	8.9732	100632.0
2010-06-07 19:00:00	AAPL	Stock	8.9689	8.9839	8.9689	8.9839	155260.0
2010-06-07 19:30:00	AAPL	Stock	8.9861	9.0071	8.9768	9.0071	415940.0
2010-06-07 20:00:00	AAPL	Stock	9.0979	9.0979	9.0979	9.0979	5600.0
2010-06-07 04:00:00	MSFT	Stock	25.58	25.79	25.58	25.79	400.0
2010-06-07 06:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	200.0
2010-06-07 06:30:00	MSFT	Stock	25.85	25.85	25.85	25.85	121.0
2010-06-07 07:00:00	MSFT	Stock	25.84	25.85	25.82	25.82	2479.0
2010-06-07 07:30:00	MSFT	Stock	25.83	25.88	25.82	25.82	3015.0
2010-06-07 08:00:00	MSFT	Stock	25.86	25.89	25.79	25.87	7300.0
2010-06-07 08:30:00	MSFT	Stock	25.87	25.88	25.82	25.82	6200.0
2010-06-07 09:00:00	MSFT	Stock	25.83	25.91	25.8	25.82	32852.0
2010-06-07 09:30:00	MSFT	Stock	25.82	25.83	25.6	25.736	6274092.0
2010-06-07 10:00:00	MSFT	Stock	25.73	25.78	25.63	25.67	6940578.0
2010-06-07 10:30:00	MSFT	Stock	25.67	25.723	25.55	25.57	4369357.0
2010-06-07 11:00:00	MSFT	Stock	25.57	25.67	25.53	25.64	3682405.0
2010-06-07 11:30:00	MSFT	Stock	25.642	25.75	25.6	25.75	2535332.0
2010-06-07 12:00:00	MSFT	Stock	25.74	25.78	25.69	25.75	1808685.0
2010-06-07 12:30:00	MSFT	Stock	25.74	25.78	25.68	25.75	2190166.0
2010-06-07 13:00:00	MSFT	Stock	25.75	25.76	25.61	25.69	3720365.0
2010-06-07 13:30:00	MSFT	Stock	25.685	25.76	25.575	25.61	2762909.0
2010-06-07 14:00:00	MSFT	Stock	25.61	25.64	25.51	25.609	3577751.0
2010-06-07 14:30:00	MSFT	Stock	25.61	25.63	25.41	25.448	5003253.0
2010-06-07 15:00:00	MSFT	Stock	25.44	25.51	25.315	25.32	9583131.0

> showing 50 of 73,208 rows — these rows as CSV

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