PREVIEW / etf_30min / 2011-07-20

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-20.parquet
  size:    280 KB
  rows:    9,437

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-07-20 04:00:00	SPY	ETF	133.0	133.12	133.0	133.12	1314.0
2011-07-20 04:30:00	SPY	ETF	133.1	133.1	133.1	133.1	700.0
2011-07-20 05:00:00	SPY	ETF	132.79	132.98	132.79	132.98	300.0
2011-07-20 05:30:00	SPY	ETF	133.09	133.09	133.09	133.09	200.0
2011-07-20 06:00:00	SPY	ETF	133.02	133.02	132.99	133.01	1685.0
2011-07-20 06:30:00	SPY	ETF	133.15	133.35	133.14	133.3	16590.0
2011-07-20 07:00:00	SPY	ETF	133.32	133.41	133.24	133.4	517112.0
2011-07-20 07:30:00	SPY	ETF	133.4	133.43	133.21	133.25	539187.0
2011-07-20 08:00:00	SPY	ETF	133.3	133.34	133.12	133.25	2194672.0
2011-07-20 08:30:00	SPY	ETF	133.24	133.32	133.19	133.22	1392153.0
2011-07-20 09:00:00	SPY	ETF	133.22	133.28	133.06	133.08	1829466.0
2011-07-20 09:30:00	SPY	ETF	133.07	133.15	132.58	132.63	17189158.0
2011-07-20 10:00:00	SPY	ETF	132.63	132.91	132.42	132.725	17182948.0
2011-07-20 10:30:00	SPY	ETF	132.725	132.94	132.63	132.8293	10462681.0
2011-07-20 11:00:00	SPY	ETF	132.82	132.99	132.77	132.78	6014794.0
2011-07-20 11:30:00	SPY	ETF	132.78	132.92	132.55	132.61	8813395.0
2011-07-20 12:00:00	SPY	ETF	132.61	132.71	132.51	132.61	4332126.0
2011-07-20 12:30:00	SPY	ETF	132.64	132.73	132.5	132.71	5271864.0
2011-07-20 13:00:00	SPY	ETF	132.71	132.89	132.61	132.88	4977310.0
2011-07-20 13:30:00	SPY	ETF	132.88	133.01	132.79	132.95	5067963.0
2011-07-20 14:00:00	SPY	ETF	132.9406	133.09	132.93	133.06	5149680.0
2011-07-20 14:30:00	SPY	ETF	133.06	133.1	132.75	132.86	10402062.0
2011-07-20 15:00:00	SPY	ETF	132.85	132.98	132.68	132.7287	7706882.0
2011-07-20 15:30:00	SPY	ETF	132.72	132.86	132.54	132.65	13866116.0
2011-07-20 16:00:00	SPY	ETF	132.65	132.79	132.6	132.62	11304149.0
2011-07-20 16:30:00	SPY	ETF	132.62	132.8456	132.19	132.21	1144559.0
2011-07-20 17:00:00	SPY	ETF	132.24	132.3	132.15	132.17	313064.0
2011-07-20 17:30:00	SPY	ETF	132.17	132.65	132.1	132.17	127324.0
2011-07-20 18:00:00	SPY	ETF	132.17	132.65	132.08	132.24	311595.0
2011-07-20 18:30:00	SPY	ETF	132.25	132.91	132.25	132.89	448765.0
2011-07-20 19:00:00	SPY	ETF	132.87	133.02	132.83	132.88	324427.0
2011-07-20 19:30:00	SPY	ETF	132.88	133.04	132.83	132.98	288354.0
2011-07-20 04:00:00	QQQ	ETF	59.22	59.22	59.17	59.17	1600.0
2011-07-20 04:30:00	QQQ	ETF	59.17	59.17	59.13	59.13	3890.0
2011-07-20 05:00:00	QQQ	ETF	59.1	59.16	59.1	59.16	300.0
2011-07-20 05:30:00	QQQ	ETF	59.17	59.17	59.17	59.17	100.0
2011-07-20 06:30:00	QQQ	ETF	59.2	59.29	59.2	59.28	1800.0
2011-07-20 07:00:00	QQQ	ETF	59.27	59.28	59.21	59.28	10700.0
2011-07-20 07:30:00	QQQ	ETF	59.28	59.29	59.21	59.24	81853.0
2011-07-20 08:00:00	QQQ	ETF	59.23	59.25	59.18	59.22	1630870.0
2011-07-20 08:30:00	QQQ	ETF	59.22	59.23	59.19	59.2	192964.0
2011-07-20 09:00:00	QQQ	ETF	59.21	59.24	59.16	59.18	1129725.0
2011-07-20 09:30:00	QQQ	ETF	59.17	59.19	58.73	58.83	7645755.0
2011-07-20 10:00:00	QQQ	ETF	58.83	58.889	58.6	58.72	6234483.0
2011-07-20 10:30:00	QQQ	ETF	58.72	58.86	58.65	58.83	2724584.0
2011-07-20 11:00:00	QQQ	ETF	58.82	58.91	58.74	58.75	2589246.0
2011-07-20 11:30:00	QQQ	ETF	58.75	58.8	58.55	58.57	3476434.0
2011-07-20 12:00:00	QQQ	ETF	58.57	58.63	58.5	58.54	1768560.0
2011-07-20 12:30:00	QQQ	ETF	58.54	58.65	58.52	58.61	2840985.0
2011-07-20 13:00:00	QQQ	ETF	58.62	58.76	58.57	58.748	1811586.0

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

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