PREVIEW / stock_30min / 2011-03-17

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-17.parquet
  size:    1.4 MB
  rows:    75,403
  symbols: 3,517

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-03-17 04:00:00	AAPL	Stock	11.8071	11.8757	11.8046	11.8464	140000.0
2011-03-17 04:30:00	AAPL	Stock	11.8214	11.8571	11.8214	11.8214	98000.0
2011-03-17 05:00:00	AAPL	Stock	11.8304	11.8857	11.8218	11.8571	74200.0
2011-03-17 05:30:00	AAPL	Stock	11.8571	11.8857	11.8571	11.8654	44800.0
2011-03-17 06:00:00	AAPL	Stock	11.8575	11.875	11.8575	11.8679	56000.0
2011-03-17 06:30:00	AAPL	Stock	11.8632	11.8714	11.8214	11.8321	354340.0
2011-03-17 07:00:00	AAPL	Stock	11.8432	11.8618	11.8268	11.8429	399588.0
2011-03-17 07:30:00	AAPL	Stock	11.8454	11.9	11.8421	11.885	1865052.0
2011-03-17 08:00:00	AAPL	Stock	11.8775	11.9911	11.8714	11.9671	5272624.0
2011-03-17 08:30:00	AAPL	Stock	11.9643	11.9982	11.9486	11.9886	3818752.0
2011-03-17 09:00:00	AAPL	Stock	11.9904	12.0507	11.9882	12.0296	7455084.0
2011-03-17 09:30:00	AAPL	Stock	12.0296	12.0975	11.9912	12.0407	142259852.0
2011-03-17 10:00:00	AAPL	Stock	12.041	12.0704	12.0179	12.0525	61125652.0
2011-03-17 10:30:00	AAPL	Stock	12.055	12.1129	12.0511	12.0979	57587068.0
2011-03-17 11:00:00	AAPL	Stock	12.0973	12.1289	12.0682	12.0875	50226484.0
2011-03-17 11:30:00	AAPL	Stock	12.0875	12.1143	12.0725	12.0736	33224296.0
2011-03-17 12:00:00	AAPL	Stock	12.0745	12.0986	12.0629	12.0779	21227864.0
2011-03-17 12:30:00	AAPL	Stock	12.0768	12.0964	12.075	12.0821	19118904.0
2011-03-17 13:00:00	AAPL	Stock	12.0824	12.0968	12.0443	12.05	27604780.0
2011-03-17 13:30:00	AAPL	Stock	12.0484	12.0614	11.9996	12.0143	45799096.0
2011-03-17 14:00:00	AAPL	Stock	12.0146	12.0271	11.9682	11.9989	38093328.0
2011-03-17 14:30:00	AAPL	Stock	11.9988	12.0439	11.9979	12.0364	25074028.0
2011-03-17 15:00:00	AAPL	Stock	12.0343	12.0425	11.9507	11.9618	29641360.0
2011-03-17 15:30:00	AAPL	Stock	11.96	11.9975	11.9364	11.9461	61934488.0
2011-03-17 16:00:00	AAPL	Stock	11.9486	12.044	11.9311	11.9354	10273256.0
2011-03-17 16:30:00	AAPL	Stock	11.9357	12.0432	11.9114	11.9293	3384724.0
2011-03-17 17:00:00	AAPL	Stock	11.9339	11.9514	11.9164	11.9164	639072.0
2011-03-17 17:30:00	AAPL	Stock	11.9243	11.9514	11.9093	11.9286	180600.0
2011-03-17 18:00:00	AAPL	Stock	11.9286	11.9514	11.9111	11.9286	213192.0
2011-03-17 18:30:00	AAPL	Stock	11.9318	11.9361	11.9107	11.9107	261100.0
2011-03-17 19:00:00	AAPL	Stock	11.9089	11.9179	11.8993	11.9143	207620.0
2011-03-17 19:30:00	AAPL	Stock	11.9125	11.9357	11.9036	11.9357	412076.0
2011-03-17 04:00:00	MSFT	Stock	24.76	24.83	24.76	24.83	470.0
2011-03-17 04:30:00	MSFT	Stock	24.88	24.9	24.88	24.9	800.0
2011-03-17 05:00:00	MSFT	Stock	24.95	24.95	24.95	24.95	400.0
2011-03-17 06:30:00	MSFT	Stock	24.83	24.83	24.83	24.83	100.0
2011-03-17 07:00:00	MSFT	Stock	24.86	24.94	24.86	24.94	800.0
2011-03-17 07:30:00	MSFT	Stock	24.91	24.95	24.91	24.95	5583.0
2011-03-17 08:00:00	MSFT	Stock	24.93	25.0	24.92	24.97	47835.0
2011-03-17 08:30:00	MSFT	Stock	24.97	25.04	24.96	25.0	44367.0
2011-03-17 09:00:00	MSFT	Stock	25.05	25.08	25.02	25.07	74734.0
2011-03-17 09:30:00	MSFT	Stock	25.07	25.08	24.93	25.0	5504861.0
2011-03-17 10:00:00	MSFT	Stock	25.01	25.16	24.95	25.14	4554015.0
2011-03-17 10:30:00	MSFT	Stock	25.14	25.16	25.01	25.03	3133574.0
2011-03-17 11:00:00	MSFT	Stock	25.03	25.15	25.022	25.11	5371596.0
2011-03-17 11:30:00	MSFT	Stock	25.11	25.2	25.1	25.12	6084061.0
2011-03-17 12:00:00	MSFT	Stock	25.12	25.21	25.12	25.18	2560130.0
2011-03-17 12:30:00	MSFT	Stock	25.18	25.22	25.07	25.075	1928843.0
2011-03-17 13:00:00	MSFT	Stock	25.075	25.15	25.0	25.0	2805205.0
2011-03-17 13:30:00	MSFT	Stock	25.0	25.04	24.8	24.83	4939495.0

> showing 50 of 75,403 rows — these rows as CSV

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