PREVIEW / stock_30min / 2013-04-02

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-02.parquet
  size:    1.5 MB
  rows:    78,650
  symbols: 3,473

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
2013-04-02 04:00:00	AAPL	Stock	15.295	15.295	15.2107	15.2143	46480.0
2013-04-02 04:30:00	AAPL	Stock	15.25	15.25	15.2429	15.2429	19740.0
2013-04-02 05:00:00	AAPL	Stock	15.2504	15.2821	15.2504	15.2821	14000.0
2013-04-02 05:30:00	AAPL	Stock	15.2857	15.3154	15.2857	15.3154	9744.0
2013-04-02 06:00:00	AAPL	Stock	15.2911	15.2946	15.2857	15.2946	25200.0
2013-04-02 06:30:00	AAPL	Stock	15.2804	15.3143	15.2804	15.3143	88900.0
2013-04-02 07:00:00	AAPL	Stock	15.3143	15.3943	15.3143	15.3929	350980.0
2013-04-02 07:30:00	AAPL	Stock	15.405	15.4196	15.345	15.3554	791840.0
2013-04-02 08:00:00	AAPL	Stock	15.3454	15.4143	15.2807	15.3179	1988084.0
2013-04-02 08:30:00	AAPL	Stock	15.3214	15.3214	15.2357	15.2789	2085048.0
2013-04-02 09:00:00	AAPL	Stock	15.2768	15.2839	15.2232	15.2689	3182844.0
2013-04-02 09:30:00	AAPL	Stock	15.2729	15.5604	15.2286	15.5282	100811116.0
2013-04-02 10:00:00	AAPL	Stock	15.5246	15.5957	15.4961	15.5613	51166976.0
2013-04-02 10:30:00	AAPL	Stock	15.5614	15.5929	15.5175	15.5704	36649452.0
2013-04-02 11:00:00	AAPL	Stock	15.5732	15.6304	15.5611	15.5682	27289052.0
2013-04-02 11:30:00	AAPL	Stock	15.5679	15.5792	15.5189	15.5493	18745580.0
2013-04-02 12:00:00	AAPL	Stock	15.5493	15.6146	15.5425	15.6032	19245408.0
2013-04-02 12:30:00	AAPL	Stock	15.6031	15.6107	15.5718	15.5979	11694424.0
2013-04-02 13:00:00	AAPL	Stock	15.5989	15.6479	15.5089	15.5508	30769816.0
2013-04-02 13:30:00	AAPL	Stock	15.5511	15.5568	15.3939	15.4254	44375520.0
2013-04-02 14:00:00	AAPL	Stock	15.4218	15.4392	15.3175	15.3496	45229576.0
2013-04-02 14:30:00	AAPL	Stock	15.3482	15.3618	15.2396	15.3214	43515528.0
2013-04-02 15:00:00	AAPL	Stock	15.3239	15.3729	15.2982	15.3362	29545096.0
2013-04-02 15:30:00	AAPL	Stock	15.3343	15.3586	15.2768	15.3532	40656196.0
2013-04-02 16:00:00	AAPL	Stock	15.3532	15.5868	15.3254	15.3525	8315916.0
2013-04-02 16:30:00	AAPL	Stock	15.3532	15.3536	15.3376	15.3446	6667416.0
2013-04-02 17:00:00	AAPL	Stock	15.3464	15.3504	15.3393	15.35	107156.0
2013-04-02 17:30:00	AAPL	Stock	15.5715	15.5715	15.35	15.3625	378560.0
2013-04-02 18:00:00	AAPL	Stock	15.3714	15.3836	15.3679	15.3836	101332.0
2013-04-02 18:30:00	AAPL	Stock	15.3793	15.3818	15.3696	15.3711	124992.0
2013-04-02 19:00:00	AAPL	Stock	15.3654	15.3654	15.3646	15.3646	22428.0
2013-04-02 19:30:00	AAPL	Stock	15.3657	15.3764	15.3625	15.3764	124096.0
2013-04-02 05:00:00	MSFT	Stock	28.65	28.67	28.65	28.67	850.0
2013-04-02 07:00:00	MSFT	Stock	28.67	28.67	28.67	28.67	259.0
2013-04-02 08:00:00	MSFT	Stock	28.67	28.67	28.56	28.65	22828.0
2013-04-02 08:30:00	MSFT	Stock	28.63	28.63	28.62	28.62	900.0
2013-04-02 09:00:00	MSFT	Stock	28.64	28.69	28.57	28.57	191286.0
2013-04-02 09:30:00	MSFT	Stock	28.59	28.74	28.52	28.725	3681523.0
2013-04-02 10:00:00	MSFT	Stock	28.73	28.79	28.7	28.77	3073739.0
2013-04-02 10:30:00	MSFT	Stock	28.77	28.85	28.76	28.805	2679750.0
2013-04-02 11:00:00	MSFT	Stock	28.81	28.85	28.76	28.78	1449447.0
2013-04-02 11:30:00	MSFT	Stock	28.775	28.8	28.75	28.78	1080525.0
2013-04-02 12:00:00	MSFT	Stock	28.772	28.8	28.77	28.785	888951.0
2013-04-02 12:30:00	MSFT	Stock	28.78	28.79	28.76	28.783	779293.0
2013-04-02 13:00:00	MSFT	Stock	28.785	28.8	28.77	28.785	1081958.0
2013-04-02 13:30:00	MSFT	Stock	28.785	28.79	28.75	28.76	1254189.0
2013-04-02 14:00:00	MSFT	Stock	28.76	28.77	28.7	28.728	1510723.0
2013-04-02 14:30:00	MSFT	Stock	28.722	28.73	28.67	28.715	1422459.0
2013-04-02 15:00:00	MSFT	Stock	28.716	28.78	28.7	28.76	1782444.0
2013-04-02 15:30:00	MSFT	Stock	28.75	28.8	28.71	28.8	5112754.0

> showing 50 of 78,650 rows — these rows as CSV

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