PREVIEW / etf_30min / 2011-02-09

all etf 30-min files

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

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-02-09 04:00:00	SPY	ETF	132.29	132.29	132.21	132.21	1500.0
2011-02-09 04:30:00	SPY	ETF	132.22	132.23	132.18	132.18	600.0
2011-02-09 05:30:00	SPY	ETF	132.23	132.24	132.1	132.1	27255.0
2011-02-09 06:00:00	SPY	ETF	132.1	132.1	132.06	132.06	1000.0
2011-02-09 06:30:00	SPY	ETF	132.1	132.16	132.06	132.06	35900.0
2011-02-09 07:00:00	SPY	ETF	132.14	132.25	132.14	132.21	257390.0
2011-02-09 07:30:00	SPY	ETF	132.21	132.21	132.08	132.14	131755.0
2011-02-09 08:00:00	SPY	ETF	132.2	132.2	131.97	132.06	974472.0
2011-02-09 08:30:00	SPY	ETF	132.06	132.23	132.06	132.17	467649.0
2011-02-09 09:00:00	SPY	ETF	132.16	132.22	132.1	132.22	1126691.0
2011-02-09 09:30:00	SPY	ETF	132.21	132.38	132.14	132.32	14203172.0
2011-02-09 10:00:00	SPY	ETF	132.32	132.52	132.28	132.39	8974785.0
2011-02-09 10:30:00	SPY	ETF	132.39	132.63	132.3599	132.45	8120774.0
2011-02-09 11:00:00	SPY	ETF	132.46	132.49	131.88	131.95	16374897.0
2011-02-09 11:30:00	SPY	ETF	131.95	132.09	131.9	131.9	10075755.0
2011-02-09 12:00:00	SPY	ETF	131.9	132.03	131.85	132.01	9970054.0
2011-02-09 12:30:00	SPY	ETF	132.02	132.17	131.99	132.03	6453704.0
2011-02-09 13:00:00	SPY	ETF	132.03	132.31	132.02	132.28	6476720.0
2011-02-09 13:30:00	SPY	ETF	132.28	132.295	132.09	132.09	3894902.0
2011-02-09 14:00:00	SPY	ETF	132.1	132.1	131.77	131.93	8343774.0
2011-02-09 14:30:00	SPY	ETF	131.92	131.94	131.61	131.749	9872055.0
2011-02-09 15:00:00	SPY	ETF	131.74	132.05	131.73	132.04	9419370.0
2011-02-09 15:30:00	SPY	ETF	132.049	132.28	131.96	132.27	17196882.0
2011-02-09 16:00:00	SPY	ETF	132.28	132.6117	132.1071	132.25	9352986.0
2011-02-09 16:30:00	SPY	ETF	132.25	132.6117	132.19	132.27	3440940.0
2011-02-09 17:00:00	SPY	ETF	132.27	132.27	132.17	132.2	271521.0
2011-02-09 17:30:00	SPY	ETF	132.2	132.21	132.15	132.17	48199.0
2011-02-09 18:00:00	SPY	ETF	132.18	132.32	132.16	132.2	135295.0
2011-02-09 18:30:00	SPY	ETF	132.2	132.2	132.17	132.17	20593.0
2011-02-09 19:00:00	SPY	ETF	132.17	132.32	132.1	132.15	117667.0
2011-02-09 19:30:00	SPY	ETF	132.14	132.16	132.09	132.09	23407.0
2011-02-09 05:30:00	QQQ	ETF	57.89	57.89	57.85	57.85	3200.0
2011-02-09 06:00:00	QQQ	ETF	57.85	57.86	57.85	57.86	400.0
2011-02-09 06:30:00	QQQ	ETF	57.86	57.88	57.86	57.88	595.0
2011-02-09 07:00:00	QQQ	ETF	57.91	57.92	57.9	57.92	3800.0
2011-02-09 07:30:00	QQQ	ETF	57.9	57.9	57.82	57.86	313418.0
2011-02-09 08:00:00	QQQ	ETF	57.87	57.9	57.82	57.85	474208.0
2011-02-09 08:30:00	QQQ	ETF	57.85	57.91	57.85	57.89	64803.0
2011-02-09 09:00:00	QQQ	ETF	57.88	57.93	57.87	57.93	347005.0
2011-02-09 09:30:00	QQQ	ETF	57.92	58.04	57.89	58.0	5066301.0
2011-02-09 10:00:00	QQQ	ETF	58.01	58.07	57.93	58.04	6842655.0
2011-02-09 10:30:00	QQQ	ETF	58.03	58.12	58.02	58.05	2878730.0
2011-02-09 11:00:00	QQQ	ETF	58.06	58.08	57.84	57.87	7842236.0
2011-02-09 11:30:00	QQQ	ETF	57.88	57.97	57.85	57.89	1962874.0
2011-02-09 12:00:00	QQQ	ETF	57.895	57.96	57.87	57.9404	2163431.0
2011-02-09 12:30:00	QQQ	ETF	57.945	58.04	57.94	57.96	3926261.0
2011-02-09 13:00:00	QQQ	ETF	57.9525	58.07	57.95	58.069	1974312.0
2011-02-09 13:30:00	QQQ	ETF	58.063	58.07	57.99	58.0	1421666.0
2011-02-09 14:00:00	QQQ	ETF	58.0	58.0	57.78	57.85	5159699.0
2011-02-09 14:30:00	QQQ	ETF	57.85	57.9	57.75	57.82	3782376.0

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

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