PREVIEW / etf_30min / 2011-03-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-02.parquet
  size:    278 KB
  rows:    9,242

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-03-02 04:00:00	SPY	ETF	130.54	130.61	130.0	130.0	4400.0
2011-03-02 04:30:00	SPY	ETF	130.52	130.52	130.0	130.46	3037.0
2011-03-02 05:00:00	SPY	ETF	130.6	130.81	130.6	130.79	1500.0
2011-03-02 05:30:00	SPY	ETF	130.8	130.85	130.58	130.58	10490.0
2011-03-02 06:00:00	SPY	ETF	130.65	130.74	130.65	130.69	8300.0
2011-03-02 06:30:00	SPY	ETF	130.76	130.96	130.75	130.84	40180.0
2011-03-02 07:00:00	SPY	ETF	130.88	131.02	130.79	130.89	266585.0
2011-03-02 07:30:00	SPY	ETF	130.89	131.0	130.69	130.85	218230.0
2011-03-02 08:00:00	SPY	ETF	130.81	130.88	130.0	130.33	1959224.0
2011-03-02 08:30:00	SPY	ETF	130.33	130.6	130.27	130.52	1390519.0
2011-03-02 09:00:00	SPY	ETF	130.52	130.87	130.52	130.75	2010022.0
2011-03-02 09:30:00	SPY	ETF	130.75	131.26	130.73	131.21	21681981.0
2011-03-02 10:00:00	SPY	ETF	131.21	131.43	131.07	131.19	18794624.0
2011-03-02 10:30:00	SPY	ETF	131.19	131.7	131.12	131.565	15079249.0
2011-03-02 11:00:00	SPY	ETF	131.58	131.82	131.291	131.31	12674847.0
2011-03-02 11:30:00	SPY	ETF	131.31	131.39	130.35	130.73	17883036.0
2011-03-02 12:00:00	SPY	ETF	130.72	131.13	130.6	131.07	17133594.0
2011-03-02 12:30:00	SPY	ETF	131.07	131.42	131.05	131.2691	7422078.0
2011-03-02 13:00:00	SPY	ETF	131.265	131.45	131.12	131.235	7157833.0
2011-03-02 13:30:00	SPY	ETF	131.24	131.3	130.91	131.035	8627841.0
2011-03-02 14:00:00	SPY	ETF	131.04	131.39	130.855	131.16	14872284.0
2011-03-02 14:30:00	SPY	ETF	131.16	131.61	131.12	131.45	14837560.0
2011-03-02 15:00:00	SPY	ETF	131.45	131.67	131.35	131.37	7097625.0
2011-03-02 15:30:00	SPY	ETF	131.37	131.38	131.04	131.2	17253701.0
2011-03-02 16:00:00	SPY	ETF	131.19	131.2232	130.95	131.08	6417245.0
2011-03-02 16:30:00	SPY	ETF	131.07	131.11	131.02	131.06	242618.0
2011-03-02 17:00:00	SPY	ETF	131.05	131.05	130.97	131.0	4096502.0
2011-03-02 17:30:00	SPY	ETF	131.03	131.04	131.0	131.0	6282.0
2011-03-02 18:00:00	SPY	ETF	131.01	131.21	130.95	131.06	85459.0
2011-03-02 18:30:00	SPY	ETF	131.07	131.11	131.04	131.05	17416.0
2011-03-02 19:00:00	SPY	ETF	131.04	131.22	131.04	131.22	70802.0
2011-03-02 19:30:00	SPY	ETF	131.22	131.22	131.16	131.17	43032.0
2011-03-02 04:30:00	QQQ	ETF	56.72	56.72	56.69	56.71	1400.0
2011-03-02 05:00:00	QQQ	ETF	56.75	56.81	56.75	56.81	2300.0
2011-03-02 05:30:00	QQQ	ETF	56.87	56.87	56.87	56.87	100.0
2011-03-02 06:30:00	QQQ	ETF	56.89	56.91	56.89	56.9	550.0
2011-03-02 07:00:00	QQQ	ETF	56.91	56.96	56.88	56.96	19662.0
2011-03-02 07:30:00	QQQ	ETF	56.93	56.93	56.84	56.87	13578.0
2011-03-02 08:00:00	QQQ	ETF	56.86	56.88	56.62	56.66	312167.0
2011-03-02 08:30:00	QQQ	ETF	56.68	56.82	56.65	56.77	452497.0
2011-03-02 09:00:00	QQQ	ETF	56.79	56.89	56.78	56.82	203001.0
2011-03-02 09:30:00	QQQ	ETF	56.82	57.09	56.79	57.09	6782204.0
2011-03-02 10:00:00	QQQ	ETF	57.08	57.24	57.02	57.1	6050639.0
2011-03-02 10:30:00	QQQ	ETF	57.1	57.43	57.06	57.3705	6674181.0
2011-03-02 11:00:00	QQQ	ETF	57.38	57.511	57.25	57.26	4684652.0
2011-03-02 11:30:00	QQQ	ETF	57.25	57.3	57.0	57.0	4465184.0
2011-03-02 12:00:00	QQQ	ETF	57.0011	57.18	56.95	57.16	3566608.0
2011-03-02 12:30:00	QQQ	ETF	57.1694	57.299	57.15	57.21	1986670.0
2011-03-02 13:00:00	QQQ	ETF	57.205	57.4	57.15	57.22	2749362.0
2011-03-02 13:30:00	QQQ	ETF	57.21	57.2401	57.04	57.09	2762820.0

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

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