PREVIEW / stock_30min / 2011-02-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-23.parquet
  size:    1.5 MB
  rows:    79,979
  symbols: 3,538

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
2011-02-23 04:00:00	AAPL	Stock	12.0964	12.0964	12.0964	12.0964	28000.0
2011-02-23 05:00:00	AAPL	Stock	12.0986	12.0986	12.0986	12.0986	2800.0
2011-02-23 05:30:00	AAPL	Stock	12.1139	12.1139	12.1082	12.1082	5600.0
2011-02-23 06:00:00	AAPL	Stock	12.1021	12.1254	12.1	12.1254	30520.0
2011-02-23 06:30:00	AAPL	Stock	12.1418	12.1604	12.1418	12.1604	30800.0
2011-02-23 07:00:00	AAPL	Stock	12.1696	12.2125	12.1696	12.2054	446740.0
2011-02-23 07:30:00	AAPL	Stock	12.2046	12.2307	12.2014	12.2014	368284.0
2011-02-23 08:00:00	AAPL	Stock	12.2018	12.2096	12.1429	12.1661	2282952.0
2011-02-23 08:30:00	AAPL	Stock	12.1636	12.1864	12.1614	12.1786	1510936.0
2011-02-23 09:00:00	AAPL	Stock	12.1793	12.1829	12.1018	12.1032	2505972.0
2011-02-23 09:30:00	AAPL	Stock	12.0989	12.2475	12.0932	12.1461	95312728.0
2011-02-23 10:00:00	AAPL	Stock	12.1461	12.2214	12.1114	12.1921	61900916.0
2011-02-23 10:30:00	AAPL	Stock	12.1921	12.2143	12.1418	12.1968	37272452.0
2011-02-23 11:00:00	AAPL	Stock	12.1964	12.2757	12.1807	12.2507	68485088.0
2011-02-23 11:30:00	AAPL	Stock	12.2489	12.2511	12.1804	12.1854	43627500.0
2011-02-23 12:00:00	AAPL	Stock	12.1855	12.1882	12.1318	12.1782	44805376.0
2011-02-23 12:30:00	AAPL	Stock	12.1779	12.1831	12.1211	12.1761	31061884.0
2011-02-23 13:00:00	AAPL	Stock	12.1761	12.1827	12.1082	12.163	34559784.0
2011-02-23 13:30:00	AAPL	Stock	12.1638	12.1871	12.1279	12.1714	32988872.0
2011-02-23 14:00:00	AAPL	Stock	12.1718	12.2256	12.1704	12.2018	31274348.0
2011-02-23 14:30:00	AAPL	Stock	12.2004	12.26	12.1861	12.2577	34666912.0
2011-02-23 15:00:00	AAPL	Stock	12.2571	12.3086	12.2357	12.2925	50780660.0
2011-02-23 15:30:00	AAPL	Stock	12.2918	12.2964	12.2364	12.2364	58997008.0
2011-02-23 16:00:00	AAPL	Stock	12.24	12.2493	12.2001	12.2361	12155948.0
2011-02-23 16:30:00	AAPL	Stock	12.2364	12.2943	12.0905	12.2429	1040228.0
2011-02-23 17:00:00	AAPL	Stock	12.2411	12.2454	12.2364	12.2364	601244.0
2011-02-23 17:30:00	AAPL	Stock	12.2411	12.2479	12.2407	12.2464	244384.0
2011-02-23 18:00:00	AAPL	Stock	12.2471	12.2657	12.2443	12.2643	379316.0
2011-02-23 18:30:00	AAPL	Stock	12.2539	12.2675	12.2364	12.2589	120512.0
2011-02-23 19:00:00	AAPL	Stock	12.2639	12.2639	12.2625	12.2632	38528.0
2011-02-23 19:30:00	AAPL	Stock	12.2632	12.2714	12.2611	12.2679	241752.0
2011-02-23 04:00:00	MSFT	Stock	26.7	26.7	26.7	26.7	400.0
2011-02-23 07:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	200.0
2011-02-23 07:30:00	MSFT	Stock	26.62	26.67	26.62	26.67	3200.0
2011-02-23 08:00:00	MSFT	Stock	26.63	26.65	26.6	26.6	17276.0
2011-02-23 08:30:00	MSFT	Stock	26.6	26.62	26.58	26.62	13072.0
2011-02-23 09:00:00	MSFT	Stock	26.62	26.63	26.53	26.55	126893.0
2011-02-23 09:30:00	MSFT	Stock	26.53	26.86	26.5	26.52	7082478.0
2011-02-23 10:00:00	MSFT	Stock	26.52	26.705	26.51	26.67	3405826.0
2011-02-23 10:30:00	MSFT	Stock	26.67	26.7	26.55	26.655	3999767.0
2011-02-23 11:00:00	MSFT	Stock	26.65	26.665	26.55	26.55	2412685.0
2011-02-23 11:30:00	MSFT	Stock	26.558	26.6	26.43	26.55	3447871.0
2011-02-23 12:00:00	MSFT	Stock	26.55	26.618	26.505	26.607	3419042.0
2011-02-23 12:30:00	MSFT	Stock	26.6	26.71	26.59	26.698	4152875.0
2011-02-23 13:00:00	MSFT	Stock	26.69	26.74	26.56	26.65	3667657.0
2011-02-23 13:30:00	MSFT	Stock	26.65	26.7	26.6	26.66	2154825.0
2011-02-23 14:00:00	MSFT	Stock	26.66	26.74	26.625	26.678	2265887.0
2011-02-23 14:30:00	MSFT	Stock	26.679	26.71	26.57	26.659	3747843.0
2011-02-23 15:00:00	MSFT	Stock	26.65	26.71	26.62	26.645	2671298.0
2011-02-23 15:30:00	MSFT	Stock	26.643	26.68	26.585	26.59	7222952.0

> showing 50 of 79,979 rows — these rows as CSV

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