PREVIEW / stock_30min / 2016-06-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-23.parquet
  size:    1.6 MB
  rows:    83,409
  symbols: 3,290

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-23 04:30:00	AAPL	Stock	23.9875	23.9875	23.9875	23.9875	3484.0
2016-06-23 05:00:00	AAPL	Stock	24.0125	24.095	24.0125	24.095	5116.0
2016-06-23 05:30:00	AAPL	Stock	24.0775	24.0775	24.0775	24.0775	1840.0
2016-06-23 06:00:00	AAPL	Stock	24.1	24.1	24.0875	24.1	2560.0
2016-06-23 06:30:00	AAPL	Stock	24.1	24.12	24.095	24.095	5552.0
2016-06-23 07:00:00	AAPL	Stock	24.05	24.05	24.0175	24.0175	18056.0
2016-06-23 07:30:00	AAPL	Stock	24.035	24.0375	24.015	24.0375	8036.0
2016-06-23 08:00:00	AAPL	Stock	24.02	24.07	23.975	24.0	203584.0
2016-06-23 08:30:00	AAPL	Stock	23.9925	24.02	23.975	24.0025	73352.0
2016-06-23 09:00:00	AAPL	Stock	24.0075	24.01	23.9775	23.99	140100.0
2016-06-23 09:30:00	AAPL	Stock	23.9925	24.025	23.8125	23.9225	19629744.0
2016-06-23 10:00:00	AAPL	Stock	23.9212	23.9925	23.9025	23.971	10570560.0
2016-06-23 10:30:00	AAPL	Stock	23.9725	24.0	23.9275	23.985	9346928.0
2016-06-23 11:00:00	AAPL	Stock	23.9862	24.0	23.9125	23.92	8564164.0
2016-06-23 11:30:00	AAPL	Stock	23.9198	23.95	23.9	23.9372	5897436.0
2016-06-23 12:00:00	AAPL	Stock	23.9375	23.9525	23.91	23.94	4157348.0
2016-06-23 12:30:00	AAPL	Stock	23.94	23.9462	23.905	23.93	4148528.0
2016-06-23 13:00:00	AAPL	Stock	23.93	23.945	23.9025	23.92	4092044.0
2016-06-23 13:30:00	AAPL	Stock	23.92	23.945	23.905	23.945	3826360.0
2016-06-23 14:00:00	AAPL	Stock	23.945	23.9525	23.885	23.895	5651848.0
2016-06-23 14:30:00	AAPL	Stock	23.8925	23.92	23.875	23.8825	5615244.0
2016-06-23 15:00:00	AAPL	Stock	23.8825	23.895	23.8475	23.861	6938988.0
2016-06-23 15:30:00	AAPL	Stock	23.8612	24.0725	23.8525	24.0225	18177972.0
2016-06-23 16:00:00	AAPL	Stock	24.025	24.0325	23.904	24.0325	11862472.0
2016-06-23 16:30:00	AAPL	Stock	24.0325	24.1125	24.025	24.075	550876.0
2016-06-23 17:00:00	AAPL	Stock	24.05	24.125	24.05	24.075	108652.0
2016-06-23 17:30:00	AAPL	Stock	24.075	24.1125	24.025	24.1	263676.0
2016-06-23 18:00:00	AAPL	Stock	24.105	24.1175	24.0875	24.1175	63756.0
2016-06-23 18:30:00	AAPL	Stock	24.1175	24.145	24.0875	24.0875	102872.0
2016-06-23 19:00:00	AAPL	Stock	24.0875	24.1125	23.955	23.965	154724.0
2016-06-23 19:30:00	AAPL	Stock	23.98	24.04	23.925	23.9875	61828.0
2016-06-23 05:00:00	MSFT	Stock	51.39	51.39	51.39	51.39	100.0
2016-06-23 05:30:00	MSFT	Stock	51.57	51.59	51.57	51.59	900.0
2016-06-23 06:00:00	MSFT	Stock	51.26	51.4	51.25	51.4	1100.0
2016-06-23 06:30:00	MSFT	Stock	51.39	51.45	51.39	51.45	1090.0
2016-06-23 07:00:00	MSFT	Stock	51.27	51.27	51.27	51.27	800.0
2016-06-23 07:30:00	MSFT	Stock	51.3	51.35	51.3	51.35	1400.0
2016-06-23 08:00:00	MSFT	Stock	51.25	51.43	51.1	51.34	8483.0
2016-06-23 08:30:00	MSFT	Stock	51.34	51.37	51.34	51.34	18476.0
2016-06-23 09:00:00	MSFT	Stock	51.37	51.44	51.23	51.26	11451.0
2016-06-23 09:30:00	MSFT	Stock	51.28	51.49	51.15	51.48	3053263.0
2016-06-23 10:00:00	MSFT	Stock	51.48	51.72	51.4	51.59	2037758.0
2016-06-23 10:30:00	MSFT	Stock	51.595	51.86	51.5	51.82	1773214.0
2016-06-23 11:00:00	MSFT	Stock	51.805	51.99	51.8	51.965	1634735.0
2016-06-23 11:30:00	MSFT	Stock	51.97	52.06	51.95	52.0	1746880.0
2016-06-23 12:00:00	MSFT	Stock	51.996	52.05	51.94	51.96	919291.0
2016-06-23 12:30:00	MSFT	Stock	51.965	51.98	51.89	51.95	1093523.0
2016-06-23 13:00:00	MSFT	Stock	51.95	51.97	51.88	51.915	1024325.0
2016-06-23 13:30:00	MSFT	Stock	51.92	51.93	51.84	51.88	1229959.0
2016-06-23 14:00:00	MSFT	Stock	51.88	51.89	51.75	51.755	1478682.0

> showing 50 of 83,409 rows — these rows as CSV

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