PREVIEW / stock_30min / 2014-01-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-13.parquet
  size:    1.6 MB
  rows:    82,681
  symbols: 3,532

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
2014-01-13 04:00:00	AAPL	Stock	19.0339	19.0357	19.03	19.0321	22596.0
2014-01-13 04:30:00	AAPL	Stock	19.0179	19.0179	19.0179	19.0179	2800.0
2014-01-13 05:30:00	AAPL	Stock	19.0732	19.0732	19.0693	19.0693	18200.0
2014-01-13 06:00:00	AAPL	Stock	19.0829	19.0829	19.0789	19.0789	11200.0
2014-01-13 06:30:00	AAPL	Stock	19.0818	19.0818	19.0814	19.0814	27160.0
2014-01-13 07:00:00	AAPL	Stock	19.1071	19.1571	19.0821	19.1521	261856.0
2014-01-13 07:30:00	AAPL	Stock	19.1432	19.1554	19.1132	19.1429	185220.0
2014-01-13 08:00:00	AAPL	Stock	19.1286	19.1554	19.0179	19.0411	1447768.0
2014-01-13 08:30:00	AAPL	Stock	19.0361	19.0496	19.0214	19.0364	464940.0
2014-01-13 09:00:00	AAPL	Stock	19.0357	19.0361	18.9118	18.9286	1248520.0
2014-01-13 09:30:00	AAPL	Stock	18.9254	19.2482	18.9243	19.2393	61723060.0
2014-01-13 10:00:00	AAPL	Stock	19.2418	19.2929	19.2304	19.24	29699264.0
2014-01-13 10:30:00	AAPL	Stock	19.2432	19.2796	19.2243	19.2718	17153360.0
2014-01-13 11:00:00	AAPL	Stock	19.2744	19.3529	19.2607	19.3379	20731284.0
2014-01-13 11:30:00	AAPL	Stock	19.3429	19.3732	19.3375	19.3568	16729216.0
2014-01-13 12:00:00	AAPL	Stock	19.3557	19.375	19.3082	19.3129	15171324.0
2014-01-13 12:30:00	AAPL	Stock	19.3093	19.3175	19.2811	19.2886	15151948.0
2014-01-13 13:00:00	AAPL	Stock	19.2882	19.2886	19.2218	19.2375	15704724.0
2014-01-13 13:30:00	AAPL	Stock	19.2371	19.2546	19.1946	19.2429	11758796.0
2014-01-13 14:00:00	AAPL	Stock	19.2421	19.2729	19.1698	19.179	15007440.0
2014-01-13 14:30:00	AAPL	Stock	19.1786	19.1861	19.1032	19.1539	16334136.0
2014-01-13 15:00:00	AAPL	Stock	19.1539	19.1557	18.9843	19.0175	25120284.0
2014-01-13 15:30:00	AAPL	Stock	19.0107	19.1564	18.9654	19.1286	38935400.0
2014-01-13 16:00:00	AAPL	Stock	19.1332	19.1824	18.9394	19.1332	12217716.0
2014-01-13 16:30:00	AAPL	Stock	19.125	19.1332	19.1207	19.1314	325080.0
2014-01-13 17:00:00	AAPL	Stock	19.1296	19.1429	19.1271	19.1421	310548.0
2014-01-13 17:30:00	AAPL	Stock	19.1382	19.1382	19.1232	19.1232	54600.0
2014-01-13 18:00:00	AAPL	Stock	19.1286	19.1386	19.1225	19.1386	281876.0
2014-01-13 18:30:00	AAPL	Stock	19.1411	19.1607	19.1411	19.1607	245532.0
2014-01-13 19:00:00	AAPL	Stock	19.1607	19.1657	19.1482	19.1529	142184.0
2014-01-13 19:30:00	AAPL	Stock	19.1543	19.1571	19.1504	19.1571	76412.0
2014-01-13 05:30:00	MSFT	Stock	36.09	36.09	36.09	36.09	800.0
2014-01-13 06:30:00	MSFT	Stock	36.03	36.03	36.03	36.03	100.0
2014-01-13 07:00:00	MSFT	Stock	36.09	36.09	36.09	36.09	600.0
2014-01-13 07:30:00	MSFT	Stock	36.01	36.02	36.01	36.02	758.0
2014-01-13 08:00:00	MSFT	Stock	36.0	36.03	35.97	36.0	5746.0
2014-01-13 08:30:00	MSFT	Stock	36.03	36.03	35.97	36.01	3200.0
2014-01-13 09:00:00	MSFT	Stock	36.03	36.04	35.98	35.99	11917.0
2014-01-13 09:30:00	MSFT	Stock	35.97	36.02	35.61	35.63	3438412.0
2014-01-13 10:00:00	MSFT	Stock	35.63	35.666	35.57	35.62	3039712.0
2014-01-13 10:30:00	MSFT	Stock	35.616	35.74	35.61	35.705	2216810.0
2014-01-13 11:00:00	MSFT	Stock	35.71	35.74	35.65	35.69	1861387.0
2014-01-13 11:30:00	MSFT	Stock	35.7	35.8	35.68	35.77	1033084.0
2014-01-13 12:00:00	MSFT	Stock	35.77	35.77	35.6	35.62	1184536.0
2014-01-13 12:30:00	MSFT	Stock	35.61	35.62	35.53	35.54	1740334.0
2014-01-13 13:00:00	MSFT	Stock	35.54	35.54	35.42	35.48	1803061.0
2014-01-13 13:30:00	MSFT	Stock	35.48	35.48	35.35	35.42	1632379.0
2014-01-13 14:00:00	MSFT	Stock	35.42	35.47	35.32	35.33	1848620.0
2014-01-13 14:30:00	MSFT	Stock	35.327	35.327	35.17	35.195	2979022.0
2014-01-13 15:00:00	MSFT	Stock	35.19	35.19	34.96	34.995	7316927.0

> showing 50 of 82,681 rows — these rows as CSV

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