PREVIEW / stock_30min / 2011-02-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-22.parquet
  size:    1.5 MB
  rows:    81,050
  symbols: 3,545

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-22 04:00:00	AAPL	Stock	12.4286	12.4286	12.2896	12.3393	175000.0
2011-02-22 04:30:00	AAPL	Stock	12.3393	12.3929	12.3304	12.3929	281008.0
2011-02-22 05:00:00	AAPL	Stock	12.3668	12.3714	12.3661	12.3661	18004.0
2011-02-22 05:30:00	AAPL	Stock	12.3857	12.3857	12.3689	12.3857	23072.0
2011-02-22 06:00:00	AAPL	Stock	12.3886	12.3886	12.3839	12.3839	6440.0
2011-02-22 06:30:00	AAPL	Stock	12.3804	12.3804	12.3579	12.3579	55076.0
2011-02-22 07:00:00	AAPL	Stock	12.3468	12.3554	12.3214	12.3429	354592.0
2011-02-22 07:30:00	AAPL	Stock	12.3429	12.3732	12.3393	12.3643	310632.0
2011-02-22 08:00:00	AAPL	Stock	12.3504	12.3614	12.2357	12.2946	3988824.0
2011-02-22 08:30:00	AAPL	Stock	12.2929	12.3193	12.2696	12.2971	1665496.0
2011-02-22 09:00:00	AAPL	Stock	12.3	12.3004	12.2196	12.2214	5299168.0
2011-02-22 09:30:00	AAPL	Stock	12.2311	12.2628	12.0714	12.2168	202016192.0
2011-02-22 10:00:00	AAPL	Stock	12.2221	12.3357	12.1821	12.2818	96700492.0
2011-02-22 10:30:00	AAPL	Stock	12.2818	12.3143	12.27	12.2771	42710192.0
2011-02-22 11:00:00	AAPL	Stock	12.2742	12.2807	12.1661	12.2343	69879544.0
2011-02-22 11:30:00	AAPL	Stock	12.2343	12.2557	12.2036	12.2189	46816896.0
2011-02-22 12:00:00	AAPL	Stock	12.2199	12.2354	12.1825	12.23	28761600.0
2011-02-22 12:30:00	AAPL	Stock	12.23	12.2446	12.1121	12.1257	49687372.0
2011-02-22 13:00:00	AAPL	Stock	12.1261	12.1893	12.1	12.155	49817488.0
2011-02-22 13:30:00	AAPL	Stock	12.155	12.1714	12.1214	12.1482	33152616.0
2011-02-22 14:00:00	AAPL	Stock	12.1471	12.1675	12.1354	12.1563	27113100.0
2011-02-22 14:30:00	AAPL	Stock	12.1566	12.1964	12.1375	12.1432	38189956.0
2011-02-22 15:00:00	AAPL	Stock	12.1421	12.1517	12.0714	12.0811	54703264.0
2011-02-22 15:30:00	AAPL	Stock	12.08	12.1114	12.0614	12.0957	75098156.0
2011-02-22 16:00:00	AAPL	Stock	12.0961	12.1803	12.0786	12.0882	23908332.0
2011-02-22 16:30:00	AAPL	Stock	12.0871	12.0882	12.0688	12.0814	981008.0
2011-02-22 17:00:00	AAPL	Stock	12.0814	12.2294	12.0661	12.0679	1122380.0
2011-02-22 17:30:00	AAPL	Stock	12.0661	12.0679	12.0268	12.0375	350168.0
2011-02-22 18:00:00	AAPL	Stock	12.0357	12.0932	11.9729	11.9796	504616.0
2011-02-22 18:30:00	AAPL	Stock	11.98	12.0268	11.98	12.0179	486388.0
2011-02-22 19:00:00	AAPL	Stock	12.0232	12.0393	12.0	12.0179	381920.0
2011-02-22 19:30:00	AAPL	Stock	12.0107	12.0268	12.0	12.0161	414624.0
2011-02-22 05:30:00	MSFT	Stock	26.91	26.91	26.77	26.77	2800.0
2011-02-22 07:00:00	MSFT	Stock	26.82	26.82	26.8	26.82	5056.0
2011-02-22 07:30:00	MSFT	Stock	26.81	26.82	26.78	26.78	1800.0
2011-02-22 08:00:00	MSFT	Stock	26.85	26.9	26.78	26.81	20664.0
2011-02-22 08:30:00	MSFT	Stock	26.81	26.9	26.8	26.88	25756.0
2011-02-22 09:00:00	MSFT	Stock	26.9	26.95	26.75	26.79	242624.0
2011-02-22 09:30:00	MSFT	Stock	26.77	26.92	26.68	26.92	8883248.0
2011-02-22 10:00:00	MSFT	Stock	26.92	27.1	26.85	26.99	5483618.0
2011-02-22 10:30:00	MSFT	Stock	26.99	27.09	26.99	27.03	2156699.0
2011-02-22 11:00:00	MSFT	Stock	27.03	27.03	26.79	26.82	4186657.0
2011-02-22 11:30:00	MSFT	Stock	26.83	26.84	26.73	26.76	3517587.0
2011-02-22 12:00:00	MSFT	Stock	26.76	26.77	26.62	26.66	4604625.0
2011-02-22 12:30:00	MSFT	Stock	26.66	26.67	26.58	26.615	4995257.0
2011-02-22 13:00:00	MSFT	Stock	26.61	26.76	26.59	26.71	3992474.0
2011-02-22 13:30:00	MSFT	Stock	26.71	26.73	26.625	26.69	2616334.0
2011-02-22 14:00:00	MSFT	Stock	26.7	26.7	26.61	26.671	2961209.0
2011-02-22 14:30:00	MSFT	Stock	26.676	26.77	26.66	26.7	2805093.0
2011-02-22 15:00:00	MSFT	Stock	26.709	26.71	26.54	26.55	4389519.0

> showing 50 of 81,050 rows — these rows as CSV

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