PREVIEW / etf_30min / 2011-06-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-02.parquet
  size:    279 KB
  rows:    9,245

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
2011-06-02 04:00:00	SPY	ETF	131.83	131.83	131.63	131.74	1400.0
2011-06-02 04:30:00	SPY	ETF	131.79	131.9	131.79	131.9	600.0
2011-06-02 05:00:00	SPY	ETF	131.9	131.9	131.9	131.9	100.0
2011-06-02 05:30:00	SPY	ETF	131.9	132.09	131.88	132.09	3200.0
2011-06-02 06:00:00	SPY	ETF	132.14	132.26	132.14	132.15	19410.0
2011-06-02 06:30:00	SPY	ETF	132.12	132.18	132.09	132.12	50080.0
2011-06-02 07:00:00	SPY	ETF	132.14	132.18	132.02	132.07	215294.0
2011-06-02 07:30:00	SPY	ETF	132.03	132.03	131.79	131.84	210378.0
2011-06-02 08:00:00	SPY	ETF	131.85	132.1754	131.78	131.87	673925.0
2011-06-02 08:30:00	SPY	ETF	131.87	132.09	131.8	131.98	1326146.0
2011-06-02 09:00:00	SPY	ETF	131.99	132.03	131.85	131.96	780410.0
2011-06-02 09:30:00	SPY	ETF	131.96	132.24	131.361	131.94	32772878.0
2011-06-02 10:00:00	SPY	ETF	131.94	132.16	131.75	131.94	17362332.0
2011-06-02 10:30:00	SPY	ETF	131.95	132.22	131.87	131.9	10150914.0
2011-06-02 11:00:00	SPY	ETF	131.9	132.0	131.36	131.4	12431712.0
2011-06-02 11:30:00	SPY	ETF	131.41	131.42	130.96	131.2984	18764359.0
2011-06-02 12:00:00	SPY	ETF	131.3	131.45	131.11	131.37	8020174.0
2011-06-02 12:30:00	SPY	ETF	131.37	131.74	131.18	131.62	8965569.0
2011-06-02 13:00:00	SPY	ETF	131.62	131.88	131.59	131.8	9244008.0
2011-06-02 13:30:00	SPY	ETF	131.8	131.97	131.52	131.92	11517921.0
2011-06-02 14:00:00	SPY	ETF	131.92	132.14	131.59	131.72	12850876.0
2011-06-02 14:30:00	SPY	ETF	131.72	132.1	131.67	132.09	6584113.0
2011-06-02 15:00:00	SPY	ETF	132.09	132.16	131.855	131.94	8708907.0
2011-06-02 15:30:00	SPY	ETF	131.9301	132.01	131.6	131.7	17504087.0
2011-06-02 16:00:00	SPY	ETF	131.71	131.79	131.68	131.75	13091545.0
2011-06-02 16:30:00	SPY	ETF	131.74	131.84	131.74	131.81	1265375.0
2011-06-02 17:00:00	SPY	ETF	131.81	131.85	131.73	131.75	247391.0
2011-06-02 17:30:00	SPY	ETF	131.75	131.79	131.72	131.77	37869.0
2011-06-02 18:00:00	SPY	ETF	131.77	131.77	131.64	131.64	95932.0
2011-06-02 18:30:00	SPY	ETF	131.66	131.69	131.64	131.64	16309.0
2011-06-02 19:00:00	SPY	ETF	131.63	131.68	131.62	131.63	33567.0
2011-06-02 19:30:00	SPY	ETF	131.62	131.67	131.6	131.64	28125.0
2011-06-02 05:00:00	QQQ	ETF	57.12	57.12	57.12	57.12	200.0
2011-06-02 05:30:00	QQQ	ETF	57.19	57.21	57.19	57.21	300.0
2011-06-02 06:00:00	QQQ	ETF	57.28	57.28	57.28	57.28	100.0
2011-06-02 06:30:00	QQQ	ETF	57.25	57.3	57.2	57.3	4575.0
2011-06-02 07:00:00	QQQ	ETF	57.23	57.27	57.22	57.22	7294.0
2011-06-02 07:30:00	QQQ	ETF	57.13	57.18	57.13	57.15	31313.0
2011-06-02 08:00:00	QQQ	ETF	57.13	57.19	57.12	57.16	68178.0
2011-06-02 08:30:00	QQQ	ETF	57.1	57.23	57.06	57.19	165606.0
2011-06-02 09:00:00	QQQ	ETF	57.2	57.22	57.16	57.21	116542.0
2011-06-02 09:30:00	QQQ	ETF	57.21	57.3	56.99	57.26	7396985.0
2011-06-02 10:00:00	QQQ	ETF	57.26	57.39	57.19	57.33	5305296.0
2011-06-02 10:30:00	QQQ	ETF	57.34	57.41	57.29	57.3	2824001.0
2011-06-02 11:00:00	QQQ	ETF	57.3	57.32	57.04	57.08	2352323.0
2011-06-02 11:30:00	QQQ	ETF	57.08	57.09	56.89	57.0414	4536631.0
2011-06-02 12:00:00	QQQ	ETF	57.05	57.11	57.0	57.06	2206065.0
2011-06-02 12:30:00	QQQ	ETF	57.059	57.17	56.97	57.13	1897064.0
2011-06-02 13:00:00	QQQ	ETF	57.14	57.25	57.11	57.21	2273668.0
2011-06-02 13:30:00	QQQ	ETF	57.2	57.26	57.09	57.23	1962766.0

> showing 50 of 9,245 rows — these rows as CSV

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