PREVIEW / etf_30min / 2014-05-05

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-05.parquet
  size:    329 KB
  rows:    11,280

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-05-05 04:00:00	SPY	ETF	188.04	188.04	187.66	187.66	650.0
2014-05-05 04:30:00	SPY	ETF	187.56	187.57	187.4	187.4	550.0
2014-05-05 05:00:00	SPY	ETF	187.1	187.48	187.1	187.48	2200.0
2014-05-05 05:30:00	SPY	ETF	187.39	187.39	187.28	187.28	301.0
2014-05-05 06:00:00	SPY	ETF	187.33	187.39	187.31	187.36	12136.0
2014-05-05 06:30:00	SPY	ETF	187.34	187.34	187.27	187.28	26271.0
2014-05-05 07:00:00	SPY	ETF	187.27	187.31	187.14	187.26	86757.0
2014-05-05 07:30:00	SPY	ETF	187.3	187.31	187.22	187.31	55268.0
2014-05-05 08:00:00	SPY	ETF	187.22	187.82	187.18	187.25	541473.0
2014-05-05 08:30:00	SPY	ETF	187.24	187.31	187.17	187.21	250052.0
2014-05-05 09:00:00	SPY	ETF	187.21	187.22	186.96	187.13	602449.0
2014-05-05 09:30:00	SPY	ETF	187.14	187.4	186.62	187.39	12816831.0
2014-05-05 10:00:00	SPY	ETF	187.4	187.87	187.22	187.62	8381323.0
2014-05-05 10:30:00	SPY	ETF	187.63	188.21	187.62	188.05	8567113.0
2014-05-05 11:00:00	SPY	ETF	188.06	188.16	187.91	188.05	5427713.0
2014-05-05 11:30:00	SPY	ETF	188.05	188.37	188.05	188.22	4071075.0
2014-05-05 12:00:00	SPY	ETF	188.225	188.27	188.08	188.2	1838930.0
2014-05-05 12:30:00	SPY	ETF	188.2	188.21	187.99	188.02	1804566.0
2014-05-05 13:00:00	SPY	ETF	188.02	188.09	187.9	187.99	2416707.0
2014-05-05 13:30:00	SPY	ETF	188.0	188.14	187.98	188.11	1403992.0
2014-05-05 14:00:00	SPY	ETF	188.11	188.28	188.11	188.2201	2185272.0
2014-05-05 14:30:00	SPY	ETF	188.22	188.55	188.17	188.44	3211596.0
2014-05-05 15:00:00	SPY	ETF	188.45	188.48	188.32	188.41	2593978.0
2014-05-05 15:30:00	SPY	ETF	188.4	188.49	188.28	188.44	7816053.0
2014-05-05 16:00:00	SPY	ETF	188.43	188.4483	187.55	188.2	5488122.0
2014-05-05 16:30:00	SPY	ETF	188.19	188.29	188.18	188.29	2522211.0
2014-05-05 17:00:00	SPY	ETF	188.29	188.4	188.29	188.37	124580.0
2014-05-05 17:30:00	SPY	ETF	188.37	188.37	188.35	188.35	6871.0
2014-05-05 18:00:00	SPY	ETF	188.35	188.35	188.24	188.31	15694.0
2014-05-05 18:30:00	SPY	ETF	188.3	188.3	188.26	188.27	1550.0
2014-05-05 19:00:00	SPY	ETF	188.3	188.3	188.26	188.26	3659.0
2014-05-05 19:30:00	SPY	ETF	188.27	188.32	188.27	188.28	38615.0
2014-05-05 04:00:00	QQQ	ETF	87.4	87.4	87.36	87.36	200.0
2014-05-05 04:30:00	QQQ	ETF	87.28	87.3	87.21	87.21	1400.0
2014-05-05 05:00:00	QQQ	ETF	87.2	87.2	86.97	86.97	5700.0
2014-05-05 05:30:00	QQQ	ETF	87.01	87.01	87.01	87.01	100.0
2014-05-05 06:30:00	QQQ	ETF	87.26	87.26	87.26	87.26	100.0
2014-05-05 07:00:00	QQQ	ETF	87.15	87.15	87.01	87.09	45850.0
2014-05-05 07:30:00	QQQ	ETF	87.12	87.22	87.11	87.15	4000.0
2014-05-05 08:00:00	QQQ	ETF	87.16	87.17	87.1	87.1	87278.0
2014-05-05 08:30:00	QQQ	ETF	87.11	87.13	87.05	87.06	95541.0
2014-05-05 09:00:00	QQQ	ETF	87.06	87.06	86.87	86.98	336148.0
2014-05-05 09:30:00	QQQ	ETF	86.98	87.38	86.76	87.38	5386065.0
2014-05-05 10:00:00	QQQ	ETF	87.38	87.73	87.2401	87.54	4351842.0
2014-05-05 10:30:00	QQQ	ETF	87.54	87.84	87.53	87.66	2778258.0
2014-05-05 11:00:00	QQQ	ETF	87.67	87.71	87.55	87.67	1243464.0
2014-05-05 11:30:00	QQQ	ETF	87.68	87.8	87.65	87.74	901530.0
2014-05-05 12:00:00	QQQ	ETF	87.74	87.775	87.6485	87.7	428914.0
2014-05-05 12:30:00	QQQ	ETF	87.7	87.725	87.58	87.599	1787127.0
2014-05-05 13:00:00	QQQ	ETF	87.59	87.66	87.531	87.61	886067.0

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

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