PREVIEW / etf_30min / 2014-12-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-17.parquet
  size:    386 KB
  rows:    12,822

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-17 04:00:00	SPY	ETF	198.5	198.84	198.5	198.84	25536.0
2014-12-17 04:30:00	SPY	ETF	198.69	199.03	198.69	198.91	175655.0
2014-12-17 05:00:00	SPY	ETF	198.84	199.13	198.84	199.12	149636.0
2014-12-17 05:30:00	SPY	ETF	199.06	199.11	198.78	198.84	38615.0
2014-12-17 06:00:00	SPY	ETF	198.84	198.94	198.52	198.58	32020.0
2014-12-17 06:30:00	SPY	ETF	198.57	199.03	198.57	199.02	90087.0
2014-12-17 07:00:00	SPY	ETF	199.05	199.42	198.91	198.97	226294.0
2014-12-17 07:30:00	SPY	ETF	198.94	199.0	198.6	198.77	465546.0
2014-12-17 08:00:00	SPY	ETF	199.01	199.39	198.61	198.73	508077.0
2014-12-17 08:30:00	SPY	ETF	198.71	199.07	198.54	198.6	1377127.0
2014-12-17 09:00:00	SPY	ETF	198.57	198.67	198.12	198.44	2761060.0
2014-12-17 09:30:00	SPY	ETF	198.44	199.53	198.29	199.4	23673439.0
2014-12-17 10:00:00	SPY	ETF	199.39	199.44	198.67	198.715	12318109.0
2014-12-17 10:30:00	SPY	ETF	198.71	199.41	198.51	199.07	11355898.0
2014-12-17 11:00:00	SPY	ETF	199.07	199.84	199.0135	199.65	12259995.0
2014-12-17 11:30:00	SPY	ETF	199.65	200.7	199.47	200.57	14896838.0
2014-12-17 12:00:00	SPY	ETF	200.57	200.61	199.68	199.73	9230662.0
2014-12-17 12:30:00	SPY	ETF	199.725	200.14	199.56	199.97	10169142.0
2014-12-17 13:00:00	SPY	ETF	199.97	200.14	199.87	200.06	5893449.0
2014-12-17 13:30:00	SPY	ETF	200.06	200.43	199.76	200.4	8307390.0
2014-12-17 14:00:00	SPY	ETF	200.4	201.99	200.17	201.23	42558615.0
2014-12-17 14:30:00	SPY	ETF	201.23	201.58	200.27	200.44	24137414.0
2014-12-17 15:00:00	SPY	ETF	200.445	201.769	199.78	201.6601	18607762.0
2014-12-17 15:30:00	SPY	ETF	201.675	202.34	201.38	201.9	34347449.0
2014-12-17 16:00:00	SPY	ETF	201.91	202.15	201.48	201.99	9329620.0
2014-12-17 16:30:00	SPY	ETF	201.99	202.1	201.79	202.0	3361333.0
2014-12-17 17:00:00	SPY	ETF	202.0	202.11	202.0	202.07	246117.0
2014-12-17 17:30:00	SPY	ETF	202.07	202.13	202.06	202.06	159636.0
2014-12-17 18:00:00	SPY	ETF	202.06	202.15	201.9	202.12	1181755.0
2014-12-17 18:30:00	SPY	ETF	202.11	202.11	201.97	201.97	45612.0
2014-12-17 19:00:00	SPY	ETF	201.98	202.13	201.94	202.13	30447.0
2014-12-17 19:30:00	SPY	ETF	202.08	202.13	202.0	202.03	109782.0
2014-12-17 05:00:00	QQQ	ETF	100.45	100.5	100.4	100.5	1100.0
2014-12-17 05:30:00	QQQ	ETF	100.51	100.51	100.51	100.51	200.0
2014-12-17 06:00:00	QQQ	ETF	100.37	100.44	100.27	100.27	4400.0
2014-12-17 06:30:00	QQQ	ETF	100.29	100.53	100.29	100.53	15100.0
2014-12-17 07:00:00	QQQ	ETF	100.56	100.69	100.53	100.55	29413.0
2014-12-17 07:30:00	QQQ	ETF	100.51	100.51	100.35	100.44	123184.0
2014-12-17 08:00:00	QQQ	ETF	100.41	100.59	100.3	100.39	103971.0
2014-12-17 08:30:00	QQQ	ETF	100.37	100.54	100.21	100.21	695965.0
2014-12-17 09:00:00	QQQ	ETF	100.23	100.26	99.98	100.05	916106.0
2014-12-17 09:30:00	QQQ	ETF	100.05	100.55	99.92	100.52	11201936.0
2014-12-17 10:00:00	QQQ	ETF	100.52	100.62	100.12	100.16	5826456.0
2014-12-17 10:30:00	QQQ	ETF	100.16	100.45	100.09	100.163	5935743.0
2014-12-17 11:00:00	QQQ	ETF	100.17	100.69	100.16	100.6	3700345.0
2014-12-17 11:30:00	QQQ	ETF	100.6	101.09	100.54	101.05	3894432.0
2014-12-17 12:00:00	QQQ	ETF	101.04	101.06	100.55	100.57	2441105.0
2014-12-17 12:30:00	QQQ	ETF	100.57	100.745	100.44	100.63	2027148.0
2014-12-17 13:00:00	QQQ	ETF	100.64	100.72	100.51	100.67	1528719.0
2014-12-17 13:30:00	QQQ	ETF	100.66	100.93	100.57	100.914	2241006.0

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

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