PREVIEW / etf_30min / 2016-05-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-27.parquet
  size:    375 KB
  rows:    12,801

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-05-27 04:00:00	SPY	ETF	209.59	209.59	209.5	209.57	5000.0
2016-05-27 04:30:00	SPY	ETF	209.59	209.6	209.49	209.54	29625.0
2016-05-27 05:00:00	SPY	ETF	209.52	209.6	209.47	209.6	3713.0
2016-05-27 05:30:00	SPY	ETF	209.6	209.8	209.6	209.71	3556.0
2016-05-27 06:00:00	SPY	ETF	209.72	209.72	209.66	209.66	5002.0
2016-05-27 06:30:00	SPY	ETF	209.67	209.79	209.67	209.79	1655.0
2016-05-27 07:00:00	SPY	ETF	209.71	209.78	209.69	209.7	26901.0
2016-05-27 07:30:00	SPY	ETF	209.68	209.76	209.66	209.68	58395.0
2016-05-27 08:00:00	SPY	ETF	209.7	209.77	209.481	209.7	111411.0
2016-05-27 08:30:00	SPY	ETF	209.7	209.75	209.53	209.53	214744.0
2016-05-27 09:00:00	SPY	ETF	209.52	209.59	209.47	209.52	244662.0
2016-05-27 09:30:00	SPY	ETF	209.53	209.83	209.47	209.6801	5369445.0
2016-05-27 10:00:00	SPY	ETF	209.68	209.94	209.66	209.7764	4985327.0
2016-05-27 10:30:00	SPY	ETF	209.78	209.92	209.705	209.76	3634126.0
2016-05-27 11:00:00	SPY	ETF	209.7599	209.94	209.68	209.94	3044215.0
2016-05-27 11:30:00	SPY	ETF	209.94	210.1	209.9	209.97	3256410.0
2016-05-27 12:00:00	SPY	ETF	209.97	210.05	209.94	210.05	1974146.0
2016-05-27 12:30:00	SPY	ETF	210.05	210.05	209.92	209.96	2877264.0
2016-05-27 13:00:00	SPY	ETF	209.96	209.99	209.86	209.89	1556586.0
2016-05-27 13:30:00	SPY	ETF	209.89	209.94	209.52	209.68	5292599.0
2016-05-27 14:00:00	SPY	ETF	209.67	209.95	209.52	209.87	3521228.0
2016-05-27 14:30:00	SPY	ETF	209.865	209.89	209.66	209.85	3222833.0
2016-05-27 15:00:00	SPY	ETF	209.855	209.95	209.8	209.92	3409321.0
2016-05-27 15:30:00	SPY	ETF	209.93	210.21	209.91	210.2	10308612.0
2016-05-27 16:00:00	SPY	ETF	210.2	210.35	210.0738	210.32	7672823.0
2016-05-27 16:30:00	SPY	ETF	210.32	210.45	210.27	210.4	993881.0
2016-05-27 17:00:00	SPY	ETF	210.39	210.43	210.35	210.37	134278.0
2016-05-27 17:30:00	SPY	ETF	210.37	210.46	210.37	210.43	1321423.0
2016-05-27 18:00:00	SPY	ETF	210.41	210.43	210.35	210.35	17528.0
2016-05-27 18:30:00	SPY	ETF	210.35	210.4	210.34	210.39	39440.0
2016-05-27 19:00:00	SPY	ETF	210.39	210.4	210.36	210.4	23832.0
2016-05-27 19:30:00	SPY	ETF	210.4	210.41	210.35	210.39	42376.0
2016-05-27 04:00:00	QQQ	ETF	109.78	109.78	109.78	109.78	1311.0
2016-05-27 05:00:00	QQQ	ETF	109.76	109.77	109.76	109.77	2307.0
2016-05-27 05:30:00	QQQ	ETF	109.9	109.9	109.89	109.89	6231.0
2016-05-27 06:00:00	QQQ	ETF	109.89	109.89	109.89	109.89	200.0
2016-05-27 06:30:00	QQQ	ETF	109.88	109.89	109.88	109.89	1270.0
2016-05-27 07:00:00	QQQ	ETF	109.85	109.86	109.83	109.83	12500.0
2016-05-27 07:30:00	QQQ	ETF	109.83	109.86	109.82	109.82	2643.0
2016-05-27 08:00:00	QQQ	ETF	109.82	109.86	109.82	109.83	8085.0
2016-05-27 08:30:00	QQQ	ETF	109.81	109.82	109.69	109.7	28102.0
2016-05-27 09:00:00	QQQ	ETF	109.69	109.71	109.62	109.65	46659.0
2016-05-27 09:30:00	QQQ	ETF	109.65	109.94	109.61	109.87	1462659.0
2016-05-27 10:00:00	QQQ	ETF	109.86	110.12	109.75	109.88	1596570.0
2016-05-27 10:30:00	QQQ	ETF	109.8832	110.0	109.8832	109.91	488616.0
2016-05-27 11:00:00	QQQ	ETF	109.91	110.03	109.86	110.02	660725.0
2016-05-27 11:30:00	QQQ	ETF	110.03	110.14	110.03	110.08	1166459.0
2016-05-27 12:00:00	QQQ	ETF	110.09	110.11	110.05	110.08	602746.0
2016-05-27 12:30:00	QQQ	ETF	110.0885	110.1	110.01	110.07	843360.0
2016-05-27 13:00:00	QQQ	ETF	110.065	110.08	110.0	110.03	423685.0

> showing 50 of 12,801 rows — these rows as CSV

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