PREVIEW / etf_30min / 2014-11-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-12.parquet
  size:    352 KB
  rows:    11,995

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-11-12 04:00:00	SPY	ETF	203.9	203.9	203.63	203.72	11830.0
2014-11-12 04:30:00	SPY	ETF	203.64	203.72	203.61	203.64	24271.0
2014-11-12 05:00:00	SPY	ETF	203.7	203.77	203.62	203.77	7785.0
2014-11-12 05:30:00	SPY	ETF	203.91	203.94	203.8	203.86	16027.0
2014-11-12 06:00:00	SPY	ETF	203.71	203.74	203.48	203.49	18039.0
2014-11-12 06:30:00	SPY	ETF	203.59	203.59	203.38	203.42	82266.0
2014-11-12 07:00:00	SPY	ETF	203.44	203.53	203.4	203.44	55717.0
2014-11-12 07:30:00	SPY	ETF	203.44	203.52	203.33	203.44	274898.0
2014-11-12 08:00:00	SPY	ETF	203.44	203.51	203.24	203.33	317642.0
2014-11-12 08:30:00	SPY	ETF	203.32	203.52	203.26	203.39	1892534.0
2014-11-12 09:00:00	SPY	ETF	203.39	203.48	203.3	203.34	461785.0
2014-11-12 09:30:00	SPY	ETF	203.35	203.7	203.31	203.6699	7227967.0
2014-11-12 10:00:00	SPY	ETF	203.67	203.95	203.65	203.79	6253037.0
2014-11-12 10:30:00	SPY	ETF	203.79	203.81	203.48	203.49	5980527.0
2014-11-12 11:00:00	SPY	ETF	203.49	203.8	203.39	203.695	5352458.0
2014-11-12 11:30:00	SPY	ETF	203.7	204.12	203.69	204.05	5590315.0
2014-11-12 12:00:00	SPY	ETF	204.06	204.19	203.98	204.085	6002305.0
2014-11-12 12:30:00	SPY	ETF	204.089	204.11	203.91	204.03	3449276.0
2014-11-12 13:00:00	SPY	ETF	204.04	204.15	203.93	204.14	3911507.0
2014-11-12 13:30:00	SPY	ETF	204.135	204.19	203.93	203.98	4545092.0
2014-11-12 14:00:00	SPY	ETF	203.97	204.17	203.95	204.125	3207114.0
2014-11-12 14:30:00	SPY	ETF	204.13	204.14	203.72	203.81	5551749.0
2014-11-12 15:00:00	SPY	ETF	203.81	204.08	203.71	204.075	4901225.0
2014-11-12 15:30:00	SPY	ETF	204.075	204.24	203.94	203.98	11175153.0
2014-11-12 16:00:00	SPY	ETF	203.99	204.18	203.8592	204.08	8812094.0
2014-11-12 16:30:00	SPY	ETF	204.06	204.08	204.01	204.02	155563.0
2014-11-12 17:00:00	SPY	ETF	204.02	204.02	203.97	204.0	293255.0
2014-11-12 17:30:00	SPY	ETF	204.0	204.03	204.0	204.01	27731.0
2014-11-12 18:00:00	SPY	ETF	204.0	204.0	203.91	203.94	58676.0
2014-11-12 18:30:00	SPY	ETF	203.95	203.95	203.9	203.95	28728.0
2014-11-12 19:00:00	SPY	ETF	203.95	203.97	203.93	203.93	13175.0
2014-11-12 19:30:00	SPY	ETF	203.95	204.01	203.95	204.01	43900.0
2014-11-12 04:00:00	QQQ	ETF	102.05	102.05	102.05	102.05	200.0
2014-11-12 05:00:00	QQQ	ETF	102.0	102.03	102.0	102.03	600.0
2014-11-12 05:30:00	QQQ	ETF	102.12	102.12	102.11	102.11	1000.0
2014-11-12 06:00:00	QQQ	ETF	102.05	102.05	101.92	101.92	25501.0
2014-11-12 06:30:00	QQQ	ETF	101.94	101.94	101.87	101.9	18500.0
2014-11-12 07:00:00	QQQ	ETF	101.91	101.95	101.89	101.91	31713.0
2014-11-12 07:30:00	QQQ	ETF	101.89	101.97	101.87	101.96	31664.0
2014-11-12 08:00:00	QQQ	ETF	101.93	101.95	101.82	101.85	70069.0
2014-11-12 08:30:00	QQQ	ETF	101.86	101.95	101.83	101.88	106792.0
2014-11-12 09:00:00	QQQ	ETF	101.89	101.93	101.86	101.87	73700.0
2014-11-12 09:30:00	QQQ	ETF	101.87	102.11	101.87	102.04	2460980.0
2014-11-12 10:00:00	QQQ	ETF	102.04	102.25	102.0	102.13	1423316.0
2014-11-12 10:30:00	QQQ	ETF	102.13	102.15	101.98	102.0	1163598.0
2014-11-12 11:00:00	QQQ	ETF	101.99	102.187	101.923	102.14	1078012.0
2014-11-12 11:30:00	QQQ	ETF	102.14	102.38	102.14	102.3301	1250962.0
2014-11-12 12:00:00	QQQ	ETF	102.34	102.42	102.31	102.404	1253159.0
2014-11-12 12:30:00	QQQ	ETF	102.4	102.44	102.31	102.42	912044.0
2014-11-12 13:00:00	QQQ	ETF	102.42	102.48	102.37	102.47	820344.0

> showing 50 of 11,995 rows — these rows as CSV

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