PREVIEW / stock_30min / 2013-02-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-20.parquet
  size:    1.5 MB
  rows:    78,545
  symbols: 3,497

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-02-20 04:00:00	AAPL	Stock	16.4286	16.4464	16.4286	16.4464	39200.0
2013-02-20 06:00:00	AAPL	Stock	16.4107	16.4107	16.2936	16.3046	191520.0
2013-02-20 06:30:00	AAPL	Stock	16.3036	16.3039	16.2314	16.2454	433944.0
2013-02-20 07:00:00	AAPL	Stock	16.2329	16.2461	16.1311	16.1557	1610896.0
2013-02-20 07:30:00	AAPL	Stock	16.1611	16.3343	16.1161	16.2793	4654468.0
2013-02-20 08:00:00	AAPL	Stock	16.2682	16.4214	16.1786	16.2893	2564548.0
2013-02-20 08:30:00	AAPL	Stock	16.2896	16.2896	16.2489	16.2757	1438724.0
2013-02-20 09:00:00	AAPL	Stock	16.2693	16.4104	16.2679	16.3454	2941708.0
2013-02-20 09:30:00	AAPL	Stock	16.3461	16.3461	16.1329	16.1406	76854400.0
2013-02-20 10:00:00	AAPL	Stock	16.1438	16.2143	16.0996	16.1791	53958212.0
2013-02-20 10:30:00	AAPL	Stock	16.1821	16.2203	16.1161	16.125	32239676.0
2013-02-20 11:00:00	AAPL	Stock	16.1225	16.1786	16.1179	16.1346	36936396.0
2013-02-20 11:30:00	AAPL	Stock	16.1346	16.1429	16.0618	16.1239	48838188.0
2013-02-20 12:00:00	AAPL	Stock	16.1246	16.1446	16.0904	16.1304	18454156.0
2013-02-20 12:30:00	AAPL	Stock	16.1286	16.1561	16.1096	16.1311	13843620.0
2013-02-20 13:00:00	AAPL	Stock	16.1349	16.1557	16.1146	16.1438	13504680.0
2013-02-20 13:30:00	AAPL	Stock	16.1429	16.1529	16.1179	16.1302	10174556.0
2013-02-20 14:00:00	AAPL	Stock	16.1304	16.2029	16.1111	16.1312	23487436.0
2013-02-20 14:30:00	AAPL	Stock	16.1321	16.1525	16.1029	16.1071	25157328.0
2013-02-20 15:00:00	AAPL	Stock	16.1071	16.1079	16.0357	16.0611	32894372.0
2013-02-20 15:30:00	AAPL	Stock	16.0625	16.0796	16.0286	16.0329	44643060.0
2013-02-20 16:00:00	AAPL	Stock	16.0382	16.1381	16.0179	16.0214	8889916.0
2013-02-20 16:30:00	AAPL	Stock	16.0193	16.0597	16.0186	16.0186	1092028.0
2013-02-20 17:00:00	AAPL	Stock	16.0189	16.1603	16.0071	16.0071	638820.0
2013-02-20 17:30:00	AAPL	Stock	16.0071	16.0175	16.0071	16.0071	225456.0
2013-02-20 18:00:00	AAPL	Stock	16.0075	16.0143	16.0	16.0	338016.0
2013-02-20 18:30:00	AAPL	Stock	16.0071	16.0179	16.0036	16.0179	94752.0
2013-02-20 19:00:00	AAPL	Stock	16.0171	16.0232	16.0118	16.0232	83832.0
2013-02-20 19:30:00	AAPL	Stock	16.0232	16.0246	16.0004	16.0004	217476.0
2013-02-20 07:30:00	MSFT	Stock	28.03	28.1	28.03	28.1	900.0
2013-02-20 08:00:00	MSFT	Stock	28.03	28.11	28.01	28.05	8146.0
2013-02-20 08:30:00	MSFT	Stock	28.05	28.1	28.04	28.1	3900.0
2013-02-20 09:00:00	MSFT	Stock	28.1	28.14	28.1	28.13	9914.0
2013-02-20 09:30:00	MSFT	Stock	28.12	28.2	27.96	28.02	4999912.0
2013-02-20 10:00:00	MSFT	Stock	28.025	28.1	28.02	28.07	2297665.0
2013-02-20 10:30:00	MSFT	Stock	28.08	28.08	27.98	27.997	2559644.0
2013-02-20 11:00:00	MSFT	Stock	27.995	28.01	27.92	27.955	4383694.0
2013-02-20 11:30:00	MSFT	Stock	27.95	27.96	27.83	27.94	4237044.0
2013-02-20 12:00:00	MSFT	Stock	27.95	28.0	27.92	27.955	1503937.0
2013-02-20 12:30:00	MSFT	Stock	27.955	27.97	27.93	27.966	1499027.0
2013-02-20 13:00:00	MSFT	Stock	27.96	27.965	27.91	27.93	1357044.0
2013-02-20 13:30:00	MSFT	Stock	27.935	27.95	27.9	27.92	2284568.0
2013-02-20 14:00:00	MSFT	Stock	27.92	27.97	27.89	27.94	2251520.0
2013-02-20 14:30:00	MSFT	Stock	27.943	27.96	27.85	27.89	3374134.0
2013-02-20 15:00:00	MSFT	Stock	27.89	27.91	27.85	27.87	3342187.0
2013-02-20 15:30:00	MSFT	Stock	27.88	27.9	27.84	27.86	6911667.0
2013-02-20 16:00:00	MSFT	Stock	27.88	27.95	27.8	27.877	2185831.0
2013-02-20 16:30:00	MSFT	Stock	27.88	27.93	27.82	27.88	204513.0
2013-02-20 17:00:00	MSFT	Stock	27.88	28.054	27.84	28.054	44865.0
2013-02-20 17:30:00	MSFT	Stock	27.84	27.84	27.84	27.84	620.0

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

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