PREVIEW / stock_30min / 2016-06-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-21.parquet
  size:    1.6 MB
  rows:    81,177
  symbols: 3,289

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
2016-06-21 04:00:00	AAPL	Stock	23.77	23.77	23.7675	23.7675	2800.0
2016-06-21 04:30:00	AAPL	Stock	23.7875	23.8	23.775	23.775	3840.0
2016-06-21 05:00:00	AAPL	Stock	23.7625	23.7625	23.7625	23.7625	3336.0
2016-06-21 05:30:00	AAPL	Stock	23.7775	23.7775	23.7525	23.7525	2068.0
2016-06-21 06:30:00	AAPL	Stock	23.775	23.7775	23.765	23.765	14944.0
2016-06-21 07:00:00	AAPL	Stock	23.7875	23.815	23.7875	23.79	18440.0
2016-06-21 07:30:00	AAPL	Stock	23.795	23.8	23.785	23.7875	21440.0
2016-06-21 08:00:00	AAPL	Stock	23.8	23.8325	23.7625	23.81	93072.0
2016-06-21 08:30:00	AAPL	Stock	23.8125	23.8125	23.7625	23.795	140680.0
2016-06-21 09:00:00	AAPL	Stock	23.7925	23.82	23.73	23.73	321432.0
2016-06-21 09:30:00	AAPL	Stock	23.735	24.035	23.669	24.0275	26161512.0
2016-06-21 10:00:00	AAPL	Stock	24.0275	24.0275	23.9225	24.0025	13620140.0
2016-06-21 10:30:00	AAPL	Stock	24.005	24.025	23.965	23.98	9848192.0
2016-06-21 11:00:00	AAPL	Stock	23.98	24.0775	23.965	24.0325	9105828.0
2016-06-21 11:30:00	AAPL	Stock	24.0322	24.0775	24.01	24.07	5974844.0
2016-06-21 12:00:00	AAPL	Stock	24.07	24.0825	24.0225	24.08	6176460.0
2016-06-21 12:30:00	AAPL	Stock	24.0775	24.0875	24.0012	24.0238	7333468.0
2016-06-21 13:00:00	AAPL	Stock	24.0225	24.0575	24.005	24.0282	4750296.0
2016-06-21 13:30:00	AAPL	Stock	24.0275	24.03	23.95	23.975	6706900.0
2016-06-21 14:00:00	AAPL	Stock	23.9775	24.03	23.9625	24.011	5009028.0
2016-06-21 14:30:00	AAPL	Stock	24.01	24.0675	24.0	24.035	5695972.0
2016-06-21 15:00:00	AAPL	Stock	24.035	24.07	23.9972	24.0588	7155524.0
2016-06-21 15:30:00	AAPL	Stock	24.0575	24.0712	23.975	23.9775	14364924.0
2016-06-21 16:00:00	AAPL	Stock	23.9775	23.985	23.9675	23.9775	6033668.0
2016-06-21 16:30:00	AAPL	Stock	23.975	23.9775	23.955	23.955	479608.0
2016-06-21 17:00:00	AAPL	Stock	23.955	24.0375	23.95	24.025	235476.0
2016-06-21 17:30:00	AAPL	Stock	24.025	24.13	24.025	24.1125	218308.0
2016-06-21 18:00:00	AAPL	Stock	24.1125	24.13	24.0525	24.08	139872.0
2016-06-21 18:30:00	AAPL	Stock	24.0825	24.0825	24.04	24.045	36000.0
2016-06-21 19:00:00	AAPL	Stock	24.0525	24.065	24.04	24.065	52512.0
2016-06-21 19:30:00	AAPL	Stock	24.0625	24.095	24.0525	24.09	43224.0
2016-06-21 07:30:00	MSFT	Stock	50.23	50.23	50.23	50.23	100.0
2016-06-21 08:00:00	MSFT	Stock	50.27	50.27	50.24	50.24	3970.0
2016-06-21 08:30:00	MSFT	Stock	50.25	50.26	50.24	50.24	3575.0
2016-06-21 09:00:00	MSFT	Stock	50.26	50.26	50.16	50.16	9463.0
2016-06-21 09:30:00	MSFT	Stock	50.2	50.69	50.16	50.675	3262885.0
2016-06-21 10:00:00	MSFT	Stock	50.675	50.9	50.57	50.89	3183474.0
2016-06-21 10:30:00	MSFT	Stock	50.89	51.05	50.83	50.91	2695843.0
2016-06-21 11:00:00	MSFT	Stock	50.905	51.13	50.88	50.936	1752337.0
2016-06-21 11:30:00	MSFT	Stock	50.936	51.18	50.91	51.14	1512937.0
2016-06-21 12:00:00	MSFT	Stock	51.145	51.26	51.06	51.235	1275304.0
2016-06-21 12:30:00	MSFT	Stock	51.24	51.25	51.03	51.055	1561522.0
2016-06-21 13:00:00	MSFT	Stock	51.05	51.2	51.05	51.185	1448822.0
2016-06-21 13:30:00	MSFT	Stock	51.185	51.19	51.01	51.154	1329937.0
2016-06-21 14:00:00	MSFT	Stock	51.16	51.24	51.11	51.22	1559164.0
2016-06-21 14:30:00	MSFT	Stock	51.22	51.31	51.18	51.24	1982411.0
2016-06-21 15:00:00	MSFT	Stock	51.23	51.43	51.12	51.405	2501014.0
2016-06-21 15:30:00	MSFT	Stock	51.4	51.41	51.18	51.19	5440816.0
2016-06-21 16:00:00	MSFT	Stock	51.19	51.24	51.15	51.19	2150742.0
2016-06-21 16:30:00	MSFT	Stock	51.19	51.22	51.19	51.19	85280.0

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

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