PREVIEW / etf_30min / 2014-12-16

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-16.parquet
  size:    394 KB
  rows:    13,106

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-16 04:00:00	SPY	ETF	200.08	200.1	199.7	200.1	37333.0
2014-12-16 04:30:00	SPY	ETF	200.13	200.36	199.93	200.34	58634.0
2014-12-16 05:00:00	SPY	ETF	200.4	200.46	200.2	200.4	8152.0
2014-12-16 05:30:00	SPY	ETF	200.35	200.69	200.35	200.43	143700.0
2014-12-16 06:00:00	SPY	ETF	200.44	200.44	199.95	200.08	60379.0
2014-12-16 06:30:00	SPY	ETF	200.11	200.16	198.84	198.89	278329.0
2014-12-16 07:00:00	SPY	ETF	198.82	198.88	197.49	198.2	1152731.0
2014-12-16 07:30:00	SPY	ETF	198.17	198.6	198.03	198.12	1356982.0
2014-12-16 08:00:00	SPY	ETF	198.12	200.71	197.78	199.0	1795764.0
2014-12-16 08:30:00	SPY	ETF	199.05	199.14	198.58	198.62	2835584.0
2014-12-16 09:00:00	SPY	ETF	198.61	199.04	198.46	198.58	1494074.0
2014-12-16 09:30:00	SPY	ETF	198.58	199.44	198.18	198.95	21955323.0
2014-12-16 10:00:00	SPY	ETF	198.95	200.09	198.64	199.95	17209346.0
2014-12-16 10:30:00	SPY	ETF	199.96	200.57	199.42	200.49	14193221.0
2014-12-16 11:00:00	SPY	ETF	200.48	202.22	200.17	201.96	20744053.0
2014-12-16 11:30:00	SPY	ETF	201.97	202.395	201.23	201.35	26190676.0
2014-12-16 12:00:00	SPY	ETF	201.36	201.52	200.97	201.17	10872582.0
2014-12-16 12:30:00	SPY	ETF	201.17	201.44	200.54	200.54	12889589.0
2014-12-16 13:00:00	SPY	ETF	200.54	200.83	199.44	199.69	14948427.0
2014-12-16 13:30:00	SPY	ETF	199.68	200.42	199.26	200.0835	12141744.0
2014-12-16 14:00:00	SPY	ETF	200.07	200.5599	199.8999	200.221	6898752.0
2014-12-16 14:30:00	SPY	ETF	200.2265	200.46	199.42	199.76	9649571.0
2014-12-16 15:00:00	SPY	ETF	199.76	200.0	199.1	199.19	10997672.0
2014-12-16 15:30:00	SPY	ETF	199.18	199.6	197.86	197.93	34453478.0
2014-12-16 16:00:00	SPY	ETF	197.93	199.5802	197.6	197.92	12484389.0
2014-12-16 16:30:00	SPY	ETF	197.91	198.0	197.81	197.97	13472105.0
2014-12-16 17:00:00	SPY	ETF	197.98	198.05	197.92	197.98	341710.0
2014-12-16 17:30:00	SPY	ETF	197.95	197.99	197.92	197.97	96620.0
2014-12-16 18:00:00	SPY	ETF	197.99	198.2	197.99	198.15	142777.0
2014-12-16 18:30:00	SPY	ETF	198.17	198.28	198.14	198.21	57255.0
2014-12-16 19:00:00	SPY	ETF	198.16	198.42	198.16	198.42	135815.0
2014-12-16 19:30:00	SPY	ETF	198.42	198.49	198.38	198.44	250864.0
2014-12-16 05:30:00	QQQ	ETF	102.08	102.12	102.08	102.09	23800.0
2014-12-16 06:00:00	QQQ	ETF	101.89	101.94	101.75	101.79	13300.0
2014-12-16 06:30:00	QQQ	ETF	101.83	101.83	101.28	101.28	62935.0
2014-12-16 07:00:00	QQQ	ETF	101.26	101.26	100.56	100.85	177058.0
2014-12-16 07:30:00	QQQ	ETF	100.88	101.08	100.8	100.84	166039.0
2014-12-16 08:00:00	QQQ	ETF	100.84	101.28	100.67	101.2	359326.0
2014-12-16 08:30:00	QQQ	ETF	101.2	101.3	101.0	101.09	223995.0
2014-12-16 09:00:00	QQQ	ETF	101.09	101.26	100.93	100.98	306370.0
2014-12-16 09:30:00	QQQ	ETF	100.98	101.44	100.6	100.991	8763466.0
2014-12-16 10:00:00	QQQ	ETF	100.991	101.255	100.44	101.22	7000293.0
2014-12-16 10:30:00	QQQ	ETF	101.21	101.48	100.81	101.43	4025426.0
2014-12-16 11:00:00	QQQ	ETF	101.43	102.19	101.24	102.09	5128801.0
2014-12-16 11:30:00	QQQ	ETF	102.1	102.47	101.85	101.94	4760212.0
2014-12-16 12:00:00	QQQ	ETF	101.94	102.06	101.79	101.89	2328877.0
2014-12-16 12:30:00	QQQ	ETF	101.89	102.04	101.57	101.57	2391842.0
2014-12-16 13:00:00	QQQ	ETF	101.57	101.72	100.94	101.09	4410908.0
2014-12-16 13:30:00	QQQ	ETF	101.08	101.52	100.85	101.31	3797276.0
2014-12-16 14:00:00	QQQ	ETF	101.31	101.4899	101.167	101.29	1898838.0

> showing 50 of 13,106 rows — these rows as CSV

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