PREVIEW / stock_30min / 2015-09-16

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-16.parquet
  size:    1.6 MB
  rows:    81,706
  symbols: 3,472

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
2015-09-16 04:00:00	AAPL	Stock	29.095	29.1075	29.0425	29.1	47828.0
2015-09-16 04:30:00	AAPL	Stock	29.1075	29.125	29.1075	29.1075	12112.0
2015-09-16 05:00:00	AAPL	Stock	29.1025	29.1125	29.095	29.1125	10580.0
2015-09-16 05:30:00	AAPL	Stock	29.105	29.1175	29.0875	29.0875	23600.0
2015-09-16 06:00:00	AAPL	Stock	29.08	29.125	29.08	29.105	30368.0
2015-09-16 06:30:00	AAPL	Stock	29.12	29.125	29.115	29.125	3428.0
2015-09-16 07:00:00	AAPL	Stock	29.115	29.125	29.1	29.115	19604.0
2015-09-16 07:30:00	AAPL	Stock	29.11	29.1175	29.0825	29.1125	20920.0
2015-09-16 08:00:00	AAPL	Stock	29.11	29.125	29.0075	29.035	211188.0
2015-09-16 08:30:00	AAPL	Stock	29.0375	29.0625	29.025	29.035	138392.0
2015-09-16 09:00:00	AAPL	Stock	29.035	29.0825	29.0325	29.055	312256.0
2015-09-16 09:30:00	AAPL	Stock	29.055	29.085	28.86	28.9568	23044448.0
2015-09-16 10:00:00	AAPL	Stock	28.9525	29.0625	28.905	29.035	14486936.0
2015-09-16 10:30:00	AAPL	Stock	29.0325	29.0725	28.96	28.9675	9081464.0
2015-09-16 11:00:00	AAPL	Stock	28.9675	29.135	28.9328	29.1175	12579728.0
2015-09-16 11:30:00	AAPL	Stock	29.1178	29.125	29.025	29.0762	6396708.0
2015-09-16 12:00:00	AAPL	Stock	29.0775	29.095	29.0275	29.07	5595168.0
2015-09-16 12:30:00	AAPL	Stock	29.07	29.0825	29.0375	29.0525	5523260.0
2015-09-16 13:00:00	AAPL	Stock	29.05	29.0525	28.955	28.97	6368612.0
2015-09-16 13:30:00	AAPL	Stock	28.9675	29.025	28.961	29.0098	4536252.0
2015-09-16 14:00:00	AAPL	Stock	29.01	29.032	28.945	28.9775	5597184.0
2015-09-16 14:30:00	AAPL	Stock	28.9775	29.0175	28.9262	28.9975	8490204.0
2015-09-16 15:00:00	AAPL	Stock	29.0	29.06	28.9925	29.0575	11029936.0
2015-09-16 15:30:00	AAPL	Stock	29.0598	29.1188	29.0275	29.105	19158724.0
2015-09-16 16:00:00	AAPL	Stock	29.0838	29.11	29.0625	29.0875	5512224.0
2015-09-16 16:30:00	AAPL	Stock	29.0875	29.1	29.0625	29.09	84168.0
2015-09-16 17:00:00	AAPL	Stock	29.0975	29.1025	29.0775	29.1	96920.0
2015-09-16 17:30:00	AAPL	Stock	29.1025	29.105	29.09	29.0975	54480.0
2015-09-16 18:00:00	AAPL	Stock	29.1	29.1	29.0775	29.08	38248.0
2015-09-16 18:30:00	AAPL	Stock	29.08	29.095	29.08	29.0825	15000.0
2015-09-16 19:00:00	AAPL	Stock	29.0975	29.0975	29.0825	29.0875	32932.0
2015-09-16 19:30:00	AAPL	Stock	29.0875	29.0975	29.075	29.095	57452.0
2015-09-16 07:30:00	MSFT	Stock	44.09	44.18	44.09	44.18	7684.0
2015-09-16 08:00:00	MSFT	Stock	44.16	44.26	44.08	44.08	13119.0
2015-09-16 08:30:00	MSFT	Stock	44.15	44.15	44.09	44.09	1510.0
2015-09-16 09:00:00	MSFT	Stock	44.12	44.17	43.98	44.08	31493.0
2015-09-16 09:30:00	MSFT	Stock	43.97	44.35	43.935	44.195	2459580.0
2015-09-16 10:00:00	MSFT	Stock	44.2	44.24	44.01	44.064	1626693.0
2015-09-16 10:30:00	MSFT	Stock	44.06	44.177	43.84	43.895	1561559.0
2015-09-16 11:00:00	MSFT	Stock	43.891	44.35	43.85	44.274	3102402.0
2015-09-16 11:30:00	MSFT	Stock	44.28	44.31	44.115	44.18	1191594.0
2015-09-16 12:00:00	MSFT	Stock	44.18	44.24	44.08	44.2	771719.0
2015-09-16 12:30:00	MSFT	Stock	44.2	44.25	44.13	44.19	854619.0
2015-09-16 13:00:00	MSFT	Stock	44.19	44.205	44.1	44.185	801920.0
2015-09-16 13:30:00	MSFT	Stock	44.185	44.24	44.12	44.21	760140.0
2015-09-16 14:00:00	MSFT	Stock	44.21	44.215	43.96	44.025	1352535.0
2015-09-16 14:30:00	MSFT	Stock	44.03	44.18	43.97	44.16	1226809.0
2015-09-16 15:00:00	MSFT	Stock	44.16	44.24	44.11	44.21	1623959.0
2015-09-16 15:30:00	MSFT	Stock	44.215	44.38	44.2	44.3	3111013.0
2015-09-16 16:00:00	MSFT	Stock	44.3	44.3	44.3	44.3	1528082.0

> showing 50 of 81,706 rows — these rows as CSV

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