PREVIEW / stock_30min / 2013-07-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-05.parquet
  size:    1.5 MB
  rows:    76,581
  symbols: 3,494

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-07-05 04:00:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	2800.0
2013-07-05 04:30:00	AAPL	Stock	15.1632	15.1632	15.1632	15.1632	2800.0
2013-07-05 05:00:00	AAPL	Stock	15.1571	15.1571	15.1571	15.1571	2800.0
2013-07-05 06:00:00	AAPL	Stock	15.1393	15.1761	15.1357	15.1761	51604.0
2013-07-05 06:30:00	AAPL	Stock	15.1507	15.1507	15.1118	15.1118	22400.0
2013-07-05 07:00:00	AAPL	Stock	15.1143	15.1711	15.1143	15.1586	131040.0
2013-07-05 07:30:00	AAPL	Stock	15.1464	15.1586	15.0929	15.1057	192248.0
2013-07-05 08:00:00	AAPL	Stock	15.1161	15.1589	14.9093	15.0979	1104348.0
2013-07-05 08:30:00	AAPL	Stock	15.0893	15.1514	15.0814	15.1393	2929472.0
2013-07-05 09:00:00	AAPL	Stock	15.1411	15.1411	14.9821	15.0107	3158484.0
2013-07-05 09:30:00	AAPL	Stock	14.9989	15.1175	14.9829	15.0179	48200880.0
2013-07-05 10:00:00	AAPL	Stock	15.0168	15.0289	14.8543	14.9121	41420400.0
2013-07-05 10:30:00	AAPL	Stock	14.9143	14.9457	14.8775	14.91	18773804.0
2013-07-05 11:00:00	AAPL	Stock	14.9107	14.9361	14.8896	14.8943	17191552.0
2013-07-05 11:30:00	AAPL	Stock	14.8939	14.9179	14.8629	14.8893	18361056.0
2013-07-05 12:00:00	AAPL	Stock	14.8943	14.9346	14.8893	14.9011	16021012.0
2013-07-05 12:30:00	AAPL	Stock	14.9046	14.9175	14.8893	14.8964	9730784.0
2013-07-05 13:00:00	AAPL	Stock	14.8964	14.898	14.8521	14.8659	12526528.0
2013-07-05 13:30:00	AAPL	Stock	14.8639	14.87	14.8343	14.8504	12053776.0
2013-07-05 14:00:00	AAPL	Stock	14.8471	14.9007	14.8461	14.8882	11968544.0
2013-07-05 14:30:00	AAPL	Stock	14.8886	14.9104	14.8682	14.8782	9889992.0
2013-07-05 15:00:00	AAPL	Stock	14.8829	14.8857	14.8339	14.8557	13319992.0
2013-07-05 15:30:00	AAPL	Stock	14.8557	14.9079	14.8529	14.9079	23547384.0
2013-07-05 16:00:00	AAPL	Stock	14.9079	14.9507	14.9	14.9079	7597548.0
2013-07-05 16:30:00	AAPL	Stock	14.9218	14.9314	14.8537	14.9125	2770992.0
2013-07-05 17:00:00	AAPL	Stock	14.91	14.9111	14.9018	14.9111	56168.0
2013-07-05 17:30:00	AAPL	Stock	14.9071	14.9075	14.9071	14.9071	92456.0
2013-07-05 18:30:00	AAPL	Stock	14.9107	14.9286	14.9107	14.9125	30800.0
2013-07-05 19:00:00	AAPL	Stock	14.9129	14.9129	14.9129	14.9129	2800.0
2013-07-05 19:30:00	AAPL	Stock	14.925	14.9289	14.9107	14.9289	26264.0
2013-07-05 04:00:00	MSFT	Stock	34.2	34.2	34.2	34.2	100.0
2013-07-05 08:00:00	MSFT	Stock	34.2	34.28	34.2	34.26	2702.0
2013-07-05 08:30:00	MSFT	Stock	34.3	34.32	34.01	34.28	22935.0
2013-07-05 09:00:00	MSFT	Stock	34.2	34.21	34.13	34.13	24667.0
2013-07-05 09:30:00	MSFT	Stock	34.09	34.15	33.83	33.94	4308590.0
2013-07-05 10:00:00	MSFT	Stock	33.94	34.005	33.7	33.79	2880039.0
2013-07-05 10:30:00	MSFT	Stock	33.795	33.8	33.581	33.735	2820447.0
2013-07-05 11:00:00	MSFT	Stock	33.735	33.86	33.73	33.84	2180533.0
2013-07-05 11:30:00	MSFT	Stock	33.83	34.02	33.8	34.005	1384191.0
2013-07-05 12:00:00	MSFT	Stock	34.005	34.11	34.0	34.04	1398679.0
2013-07-05 12:30:00	MSFT	Stock	34.04	34.1	33.99	34.0	718328.0
2013-07-05 13:00:00	MSFT	Stock	34.005	34.045	33.95	34.0	634661.0
2013-07-05 13:30:00	MSFT	Stock	34.01	34.07	33.99	34.065	612922.0
2013-07-05 14:00:00	MSFT	Stock	34.065	34.14	34.02	34.14	1198580.0
2013-07-05 14:30:00	MSFT	Stock	34.14	34.17	34.08	34.12	945663.0
2013-07-05 15:00:00	MSFT	Stock	34.13	34.15	34.02	34.06	812285.0
2013-07-05 15:30:00	MSFT	Stock	34.06	34.24	34.05	34.2	2383578.0
2013-07-05 16:00:00	MSFT	Stock	34.2	34.218	34.2	34.217	3610493.0
2013-07-05 16:30:00	MSFT	Stock	34.217	34.217	33.755	34.071	36967.0
2013-07-05 17:00:00	MSFT	Stock	34.21	34.21	34.21	34.21	1603.0

> showing 50 of 76,581 rows — these rows as CSV

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