PREVIEW / etf_30min / 2013-05-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-09.parquet
  size:    310 KB
  rows:    10,608

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
2013-05-09 04:00:00	SPY	ETF	163.25	163.25	163.15	163.15	2900.0
2013-05-09 04:30:00	SPY	ETF	163.3	163.3	163.25	163.25	400.0
2013-05-09 05:00:00	SPY	ETF	163.17	163.17	163.17	163.17	1000.0
2013-05-09 05:30:00	SPY	ETF	163.22	163.29	163.17	163.29	3900.0
2013-05-09 06:00:00	SPY	ETF	163.27	163.27	163.24	163.27	6000.0
2013-05-09 06:30:00	SPY	ETF	163.32	163.32	163.27	163.32	17800.0
2013-05-09 07:00:00	SPY	ETF	163.34	163.34	163.16	163.16	72895.0
2013-05-09 07:30:00	SPY	ETF	163.16	163.26	163.13	163.16	134300.0
2013-05-09 08:00:00	SPY	ETF	163.26	163.26	163.05	163.09	358001.0
2013-05-09 08:30:00	SPY	ETF	163.11	163.26	162.91	163.16	738869.0
2013-05-09 09:00:00	SPY	ETF	163.17	163.33	163.15	163.26	583719.0
2013-05-09 09:30:00	SPY	ETF	163.27	163.47	163.18	163.365	9817908.0
2013-05-09 10:00:00	SPY	ETF	163.37	163.38	162.85	162.91	10855226.0
2013-05-09 10:30:00	SPY	ETF	162.91	163.14	162.9	162.975	5362609.0
2013-05-09 11:00:00	SPY	ETF	162.975	163.19	162.93	163.19	5467237.0
2013-05-09 11:30:00	SPY	ETF	163.185	163.23	163.09	163.12	4750071.0
2013-05-09 12:00:00	SPY	ETF	163.121	163.19	162.96	163.015	3215371.0
2013-05-09 12:30:00	SPY	ETF	163.011	163.34	163.01	163.33	3163018.0
2013-05-09 13:00:00	SPY	ETF	163.33	163.45	163.28	163.4221	5030656.0
2013-05-09 13:30:00	SPY	ETF	163.4223	163.7	163.42	163.61	5706783.0
2013-05-09 14:00:00	SPY	ETF	163.61	163.64	163.42	163.52	4471844.0
2013-05-09 14:30:00	SPY	ETF	163.525	163.55	162.71	162.72	9510372.0
2013-05-09 15:00:00	SPY	ETF	162.72	163.07	162.47	163.0	13162837.0
2013-05-09 15:30:00	SPY	ETF	162.99	163.12	162.47	162.88	14386045.0
2013-05-09 16:00:00	SPY	ETF	162.89	163.4393	162.8385	162.95	7830462.0
2013-05-09 16:30:00	SPY	ETF	162.95	163.11	162.838	163.09	884420.0
2013-05-09 17:00:00	SPY	ETF	163.09	163.12	163.07	163.07	142120.0
2013-05-09 17:30:00	SPY	ETF	163.07	163.1	163.05	163.06	40451.0
2013-05-09 18:00:00	SPY	ETF	163.08	163.16	163.07	163.15	94970.0
2013-05-09 18:30:00	SPY	ETF	163.15	163.16	163.09	163.1	19602.0
2013-05-09 19:00:00	SPY	ETF	163.1	163.15	163.07	163.14	9613.0
2013-05-09 19:30:00	SPY	ETF	163.15	163.18	163.13	163.16	47948.0
2013-05-09 04:00:00	QQQ	ETF	72.61	72.61	72.61	72.61	300.0
2013-05-09 06:00:00	QQQ	ETF	72.6	72.6	72.6	72.6	150.0
2013-05-09 07:00:00	QQQ	ETF	72.59	72.59	72.58	72.58	205.0
2013-05-09 07:30:00	QQQ	ETF	72.55	72.58	72.55	72.58	1200.0
2013-05-09 08:00:00	QQQ	ETF	72.59	72.59	72.44	72.45	140706.0
2013-05-09 08:30:00	QQQ	ETF	72.5	72.55	72.41	72.52	116059.0
2013-05-09 09:00:00	QQQ	ETF	72.53	72.57	72.52	72.54	141338.0
2013-05-09 09:30:00	QQQ	ETF	72.54	72.78	72.54	72.7	2721969.0
2013-05-09 10:00:00	QQQ	ETF	72.7	72.71	72.51	72.55	2478977.0
2013-05-09 10:30:00	QQQ	ETF	72.54	72.66	72.53	72.59	1281844.0
2013-05-09 11:00:00	QQQ	ETF	72.58	72.73	72.58	72.73	1472155.0
2013-05-09 11:30:00	QQQ	ETF	72.73	72.77	72.66	72.7401	951678.0
2013-05-09 12:00:00	QQQ	ETF	72.75	72.8	72.65	72.66	890451.0
2013-05-09 12:30:00	QQQ	ETF	72.665	72.83	72.66	72.82	740679.0
2013-05-09 13:00:00	QQQ	ETF	72.815	72.92	72.79	72.91	995175.0
2013-05-09 13:30:00	QQQ	ETF	72.9099	73.099	72.9099	73.05	1555660.0
2013-05-09 14:00:00	QQQ	ETF	73.05	73.06	72.94	72.99	993781.0
2013-05-09 14:30:00	QQQ	ETF	72.99	72.99	72.62	72.62	2311338.0

> showing 50 of 10,608 rows — these rows as CSV

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