PREVIEW / etf_30min / 2014-11-04

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-04.parquet
  size:    360 KB
  rows:    12,205

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-04 04:00:00	SPY	ETF	201.85	201.86	201.76	201.85	10905.0
2014-11-04 04:30:00	SPY	ETF	201.85	201.95	201.85	201.95	1400.0
2014-11-04 05:00:00	SPY	ETF	201.8	201.8	201.25	201.33	23516.0
2014-11-04 05:30:00	SPY	ETF	201.39	201.39	201.1	201.28	20727.0
2014-11-04 06:00:00	SPY	ETF	201.28	201.36	201.22	201.24	13282.0
2014-11-04 06:30:00	SPY	ETF	201.31	201.48	201.21	201.43	45564.0
2014-11-04 07:00:00	SPY	ETF	201.47	201.48	201.29	201.29	108399.0
2014-11-04 07:30:00	SPY	ETF	201.28	201.48	201.18	201.18	218011.0
2014-11-04 08:00:00	SPY	ETF	201.19	201.54	201.12	201.17	382372.0
2014-11-04 08:30:00	SPY	ETF	201.18	201.28	201.0	201.2	328523.0
2014-11-04 09:00:00	SPY	ETF	201.17	201.41	201.15	201.22	759974.0
2014-11-04 09:30:00	SPY	ETF	201.23	201.53	201.07	201.35	10464112.0
2014-11-04 10:00:00	SPY	ETF	201.35	201.6	200.89	200.93	8869908.0
2014-11-04 10:30:00	SPY	ETF	200.935	200.96	200.28	200.31	8779598.0
2014-11-04 11:00:00	SPY	ETF	200.31	200.56	200.06	200.49	8663431.0
2014-11-04 11:30:00	SPY	ETF	200.495	200.5499	200.245	200.37	4837129.0
2014-11-04 12:00:00	SPY	ETF	200.36	200.94	200.35	200.87	5534466.0
2014-11-04 12:30:00	SPY	ETF	200.875	201.21	200.79	201.05	4269405.0
2014-11-04 13:00:00	SPY	ETF	201.05	201.09	200.68	200.85	3662120.0
2014-11-04 13:30:00	SPY	ETF	200.85	201.38	200.7	201.27	4814592.0
2014-11-04 14:00:00	SPY	ETF	201.275	201.39	200.96	200.97	4276789.0
2014-11-04 14:30:00	SPY	ETF	200.97	201.25	200.84	201.24	4186924.0
2014-11-04 15:00:00	SPY	ETF	201.2399	201.3	200.92	201.04	5318414.0
2014-11-04 15:30:00	SPY	ETF	201.04	201.21	200.94	201.11	8943927.0
2014-11-04 16:00:00	SPY	ETF	201.1	201.7456	200.88	201.07	5584622.0
2014-11-04 16:30:00	SPY	ETF	201.06	201.28	201.06	201.12	1693629.0
2014-11-04 17:00:00	SPY	ETF	201.12	201.7456	201.09	201.17	582039.0
2014-11-04 17:30:00	SPY	ETF	201.14	201.17	201.13	201.13	3795.0
2014-11-04 18:00:00	SPY	ETF	201.1	201.13	200.94	200.97	121756.0
2014-11-04 18:30:00	SPY	ETF	200.98	201.02	200.96	200.96	22560.0
2014-11-04 19:00:00	SPY	ETF	200.99	201.11	200.96	201.06	32355.0
2014-11-04 19:30:00	SPY	ETF	201.1	201.22	201.1	201.17	64663.0
2014-11-04 04:00:00	QQQ	ETF	101.6	101.67	101.6	101.67	1000.0
2014-11-04 05:00:00	QQQ	ETF	101.62	101.62	101.48	101.48	30100.0
2014-11-04 05:30:00	QQQ	ETF	101.47	101.47	101.4	101.46	24150.0
2014-11-04 06:00:00	QQQ	ETF	101.45	101.5	101.45	101.45	9325.0
2014-11-04 06:30:00	QQQ	ETF	101.45	101.5	101.4	101.5	5900.0
2014-11-04 07:00:00	QQQ	ETF	101.5	101.5	101.37	101.37	24900.0
2014-11-04 07:30:00	QQQ	ETF	101.36	101.45	101.28	101.29	46900.0
2014-11-04 08:00:00	QQQ	ETF	101.3	101.44	101.26	101.28	79732.0
2014-11-04 08:30:00	QQQ	ETF	101.25	101.7	101.21	101.33	56906.0
2014-11-04 09:00:00	QQQ	ETF	101.32	101.42	101.32	101.35	169665.0
2014-11-04 09:30:00	QQQ	ETF	101.36	101.56	101.21	101.505	2799430.0
2014-11-04 10:00:00	QQQ	ETF	101.505	101.6244	101.24	101.26	2042828.0
2014-11-04 10:30:00	QQQ	ETF	101.26	101.32	100.85	100.87	2287135.0
2014-11-04 11:00:00	QQQ	ETF	100.86	100.98	100.67	100.95	2079139.0
2014-11-04 11:30:00	QQQ	ETF	100.96	101.01	100.76	100.7766	1366571.0
2014-11-04 12:00:00	QQQ	ETF	100.7741	101.076	100.7741	101.03	929050.0
2014-11-04 12:30:00	QQQ	ETF	101.05	101.275	101.025	101.1899	768272.0
2014-11-04 13:00:00	QQQ	ETF	101.1801	101.21	101.0666	101.185	575064.0

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

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