PREVIEW / etf_30min / 2013-04-02

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-02.parquet
  size:    310 KB
  rows:    10,556

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-04-02 04:00:00	SPY	ETF	156.05	156.39	156.05	156.39	7560.0
2013-04-02 04:30:00	SPY	ETF	156.39	156.54	156.39	156.54	5200.0
2013-04-02 05:00:00	SPY	ETF	156.49	156.56	156.49	156.55	11800.0
2013-04-02 05:30:00	SPY	ETF	156.52	156.68	156.51	156.68	17050.0
2013-04-02 06:00:00	SPY	ETF	156.65	156.76	156.64	156.69	31100.0
2013-04-02 06:30:00	SPY	ETF	156.72	156.75	156.66	156.7	63400.0
2013-04-02 07:00:00	SPY	ETF	156.67	156.7	156.64	156.67	140550.0
2013-04-02 07:30:00	SPY	ETF	156.66	156.71	156.64	156.67	104575.0
2013-04-02 08:00:00	SPY	ETF	156.69	156.79	156.61	156.62	327628.0
2013-04-02 08:30:00	SPY	ETF	156.62	156.67	156.56	156.64	1105364.0
2013-04-02 09:00:00	SPY	ETF	156.64	156.7	156.05	156.6	1501160.0
2013-04-02 09:30:00	SPY	ETF	156.61	156.95	156.51	156.86	12311640.0
2013-04-02 10:00:00	SPY	ETF	156.86	157.11	156.81	156.95	9484639.0
2013-04-02 10:30:00	SPY	ETF	156.95	157.17	156.79	157.129	7820617.0
2013-04-02 11:00:00	SPY	ETF	157.125	157.21	157.06	157.09	5575632.0
2013-04-02 11:30:00	SPY	ETF	157.095	157.165	156.98	157.05	4602575.0
2013-04-02 12:00:00	SPY	ETF	157.05	157.17	157.01	157.11	2763521.0
2013-04-02 12:30:00	SPY	ETF	157.105	157.14	157.04	157.12	1959963.0
2013-04-02 13:00:00	SPY	ETF	157.125	157.15	156.91	156.94	2823377.0
2013-04-02 13:30:00	SPY	ETF	156.945	157.11	156.91	157.03	6266678.0
2013-04-02 14:00:00	SPY	ETF	157.035	157.08	156.84	156.88	4394439.0
2013-04-02 14:30:00	SPY	ETF	156.875	156.88	156.65	156.78	8462587.0
2013-04-02 15:00:00	SPY	ETF	156.78	156.9789	156.59	156.679	6607437.0
2013-04-02 15:30:00	SPY	ETF	156.67	156.86	156.37	156.8	16325633.0
2013-04-02 16:00:00	SPY	ETF	156.79	156.95	156.73	156.84	4709392.0
2013-04-02 16:30:00	SPY	ETF	156.84	156.95	156.82	156.93	1452261.0
2013-04-02 17:00:00	SPY	ETF	156.93	157.01	156.92	156.97	147014.0
2013-04-02 17:30:00	SPY	ETF	156.97	157.0	156.94	156.99	61720.0
2013-04-02 18:00:00	SPY	ETF	156.98	156.99	156.95	156.98	51759.0
2013-04-02 18:30:00	SPY	ETF	156.99	156.99	156.91	156.98	8801.0
2013-04-02 19:00:00	SPY	ETF	156.98	157.02	156.96	156.99	11620.0
2013-04-02 19:30:00	SPY	ETF	157.0	157.02	156.96	156.97	52458.0
2013-04-02 04:00:00	QQQ	ETF	68.6	68.61	68.6	68.61	1500.0
2013-04-02 04:30:00	QQQ	ETF	68.74	68.74	68.74	68.74	200.0
2013-04-02 05:00:00	QQQ	ETF	68.73	68.73	68.73	68.73	600.0
2013-04-02 06:00:00	QQQ	ETF	68.85	68.88	68.85	68.88	1200.0
2013-04-02 06:30:00	QQQ	ETF	68.83	68.83	68.83	68.83	200.0
2013-04-02 07:00:00	QQQ	ETF	68.83	68.85	68.83	68.85	5600.0
2013-04-02 07:30:00	QQQ	ETF	68.86	68.88	68.85	68.88	8000.0
2013-04-02 08:00:00	QQQ	ETF	68.86	68.89	68.8	68.82	221400.0
2013-04-02 08:30:00	QQQ	ETF	68.83	68.83	68.77	68.8	717379.0
2013-04-02 09:00:00	QQQ	ETF	68.82	68.82	68.78	68.81	598674.0
2013-04-02 09:30:00	QQQ	ETF	68.81	69.11	68.77	69.06	4573268.0
2013-04-02 10:00:00	QQQ	ETF	69.07	69.181	69.02	69.11	2165968.0
2013-04-02 10:30:00	QQQ	ETF	69.108	69.24	69.02	69.18	2266599.0
2013-04-02 11:00:00	QQQ	ETF	69.19	69.27	69.16	69.21	1208070.0
2013-04-02 11:30:00	QQQ	ETF	69.2	69.24	69.1201	69.165	972219.0
2013-04-02 12:00:00	QQQ	ETF	69.17	69.265	69.15	69.23	640694.0
2013-04-02 12:30:00	QQQ	ETF	69.23	69.24	69.19	69.238	394985.0
2013-04-02 13:00:00	QQQ	ETF	69.24	69.2499	69.14	69.17	754944.0

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

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