PREVIEW / etf_30min / 2014-12-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-24.parquet
  size:    220 KB
  rows:    7,161

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
2014-12-24 04:00:00	SPY	ETF	208.0	208.0	208.0	208.0	3600.0
2014-12-24 04:30:00	SPY	ETF	208.0	208.0	208.0	208.0	5501.0
2014-12-24 05:00:00	SPY	ETF	208.08	208.08	208.07	208.07	2000.0
2014-12-24 05:30:00	SPY	ETF	208.06	208.13	208.06	208.13	51399.0
2014-12-24 06:00:00	SPY	ETF	208.08	208.08	208.0	208.06	2000.0
2014-12-24 06:30:00	SPY	ETF	208.01	208.09	208.01	208.03	625.0
2014-12-24 07:00:00	SPY	ETF	208.02	208.1	208.01	208.1	31560.0
2014-12-24 07:30:00	SPY	ETF	208.09	208.12	208.07	208.08	6825.0
2014-12-24 08:00:00	SPY	ETF	208.08	208.19	208.0	208.08	47962.0
2014-12-24 08:30:00	SPY	ETF	208.12	208.19	208.1	208.1	123033.0
2014-12-24 09:00:00	SPY	ETF	208.1	208.17	208.0	208.0	890916.0
2014-12-24 09:30:00	SPY	ETF	208.02	208.16	207.88	208.04	6493993.0
2014-12-24 10:00:00	SPY	ETF	208.04	208.15	207.98	208.14	4118837.0
2014-12-24 10:30:00	SPY	ETF	208.13	208.23	208.09	208.155	3592764.0
2014-12-24 11:00:00	SPY	ETF	208.15	208.335	208.15	208.29	3485479.0
2014-12-24 11:30:00	SPY	ETF	208.29	208.33	208.17	208.22	2863056.0
2014-12-24 12:00:00	SPY	ETF	208.22	208.34	208.18	208.24	3328884.0
2014-12-24 12:30:00	SPY	ETF	208.23	208.29	207.72	207.8	10321626.0
2014-12-24 13:00:00	SPY	ETF	207.79	208.1	207.73	207.79	5523692.0
2014-12-24 13:30:00	SPY	ETF	207.79	207.86	207.77	207.8	100622.0
2014-12-24 14:00:00	SPY	ETF	207.83	207.83	207.78	207.81	8040.0
2014-12-24 14:30:00	SPY	ETF	207.8	207.81	207.78	207.81	3100.0
2014-12-24 15:00:00	SPY	ETF	207.7901	207.81	207.78	207.78	40868.0
2014-12-24 15:30:00	SPY	ETF	207.82	207.9	207.82	207.9	8674.0
2014-12-24 16:00:00	SPY	ETF	207.93	207.93	207.85	207.86	5900.0
2014-12-24 05:00:00	QQQ	ETF	104.32	104.32	104.32	104.32	171.0
2014-12-24 07:30:00	QQQ	ETF	104.29	104.32	104.29	104.3	3300.0
2014-12-24 08:00:00	QQQ	ETF	104.3	104.37	104.3	104.32	9931.0
2014-12-24 08:30:00	QQQ	ETF	104.35	104.35	104.3	104.3	6665.0
2014-12-24 09:00:00	QQQ	ETF	104.29	104.38	104.29	104.33	58811.0
2014-12-24 09:30:00	QQQ	ETF	104.34	104.62	104.2699	104.57	2580301.0
2014-12-24 10:00:00	QQQ	ETF	104.57	104.61	104.4	104.57	1344814.0
2014-12-24 10:30:00	QQQ	ETF	104.57	104.62	104.55	104.59	962395.0
2014-12-24 11:00:00	QQQ	ETF	104.6	104.69	104.594	104.67	1143462.0
2014-12-24 11:30:00	QQQ	ETF	104.6697	104.7	104.53	104.54	769202.0
2014-12-24 12:00:00	QQQ	ETF	104.55	104.6428	104.4923	104.4923	686742.0
2014-12-24 12:30:00	QQQ	ETF	104.495	104.54	104.3	104.32	1424586.0
2014-12-24 13:00:00	QQQ	ETF	104.31	104.521	104.3	104.3599	3451421.0
2014-12-24 13:30:00	QQQ	ETF	104.35	104.35	104.31	104.3499	2200.0
2014-12-24 14:30:00	QQQ	ETF	104.35	104.35	104.3	104.3	2072.0
2014-12-24 15:30:00	QQQ	ETF	104.3499	104.3499	104.3499	104.3499	1000.0
2014-12-24 06:30:00	IWM	ETF	119.65	119.68	119.65	119.68	1900.0
2014-12-24 07:00:00	IWM	ETF	119.7	119.7	119.7	119.7	100.0
2014-12-24 07:30:00	IWM	ETF	119.71	119.73	119.71	119.73	3500.0
2014-12-24 08:00:00	IWM	ETF	119.74	119.77	119.68	119.68	19000.0
2014-12-24 08:30:00	IWM	ETF	119.72	119.73	119.66	119.66	7925.0
2014-12-24 09:00:00	IWM	ETF	119.67	119.73	119.62	119.65	45033.0
2014-12-24 09:30:00	IWM	ETF	119.64	119.79	119.2601	119.743	2506394.0
2014-12-24 10:00:00	IWM	ETF	119.75	119.95	119.67	119.94	1768799.0
2014-12-24 10:30:00	IWM	ETF	119.94	120.07	119.85	119.88	2002311.0

> showing 50 of 7,161 rows — these rows as CSV

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