PREVIEW / etf_30min / 2012-09-28

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-28.parquet
  size:    285 KB
  rows:    9,543

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
2012-09-28 04:30:00	SPY	ETF	144.68	144.68	144.61	144.68	8100.0
2012-09-28 05:00:00	SPY	ETF	144.7	144.76	144.64	144.74	2700.0
2012-09-28 05:30:00	SPY	ETF	144.74	144.74	144.52	144.52	5800.0
2012-09-28 06:00:00	SPY	ETF	144.52	144.52	144.31	144.37	19600.0
2012-09-28 06:30:00	SPY	ETF	144.34	144.34	144.1	144.18	186734.0
2012-09-28 07:00:00	SPY	ETF	144.12	144.19	144.06	144.16	79708.0
2012-09-28 07:30:00	SPY	ETF	144.16	144.22	144.13	144.22	138540.0
2012-09-28 08:00:00	SPY	ETF	144.18	144.83	143.77	143.83	844262.0
2012-09-28 08:30:00	SPY	ETF	143.86	144.03	143.75	144.01	1742798.0
2012-09-28 09:00:00	SPY	ETF	144.01	144.7	143.98	144.08	874134.0
2012-09-28 09:30:00	SPY	ETF	144.09	144.15	143.53	143.66	19908808.0
2012-09-28 10:00:00	SPY	ETF	143.65	143.92	143.46	143.58	12411908.0
2012-09-28 10:30:00	SPY	ETF	143.58	143.83	143.51	143.75	7448860.0
2012-09-28 11:00:00	SPY	ETF	143.75	143.79	143.5	143.51	5853573.0
2012-09-28 11:30:00	SPY	ETF	143.52	143.88	143.5	143.83	9516104.0
2012-09-28 12:00:00	SPY	ETF	143.84	144.31	143.78	143.99	11888878.0
2012-09-28 12:30:00	SPY	ETF	143.99	144.14	143.98	144.1099	3816900.0
2012-09-28 13:00:00	SPY	ETF	144.1	144.19	143.89	144.19	3656963.0
2012-09-28 13:30:00	SPY	ETF	144.19	144.56	144.18	144.37	9880041.0
2012-09-28 14:00:00	SPY	ETF	144.36	144.47	144.08	144.1	6165874.0
2012-09-28 14:30:00	SPY	ETF	144.11	144.16	143.97	144.09	5416607.0
2012-09-28 15:00:00	SPY	ETF	144.09	144.17	143.86	143.94	6807285.0
2012-09-28 15:30:00	SPY	ETF	143.94	144.3	143.7	143.9	23565927.0
2012-09-28 16:00:00	SPY	ETF	143.93	144.648	143.91	144.01	13046593.0
2012-09-28 16:30:00	SPY	ETF	144.01	144.1	143.7678	144.05	2599827.0
2012-09-28 17:00:00	SPY	ETF	144.05	144.06	144.0	144.0	153983.0
2012-09-28 17:30:00	SPY	ETF	144.04	144.07	143.97	144.07	97942.0
2012-09-28 18:00:00	SPY	ETF	144.07	144.08	144.02	144.02	8215.0
2012-09-28 18:30:00	SPY	ETF	144.07	144.09	144.06	144.09	4120.0
2012-09-28 19:00:00	SPY	ETF	144.06	144.09	144.05	144.07	5206.0
2012-09-28 19:30:00	SPY	ETF	144.07	144.08	144.02	144.08	14383.0
2012-09-28 06:00:00	QQQ	ETF	69.09	69.09	69.05	69.05	3500.0
2012-09-28 06:30:00	QQQ	ETF	69.0	69.01	68.95	68.95	2320.0
2012-09-28 07:00:00	QQQ	ETF	68.92	68.95	68.92	68.95	11300.0
2012-09-28 07:30:00	QQQ	ETF	68.97	68.99	68.95	68.95	2900.0
2012-09-28 08:00:00	QQQ	ETF	68.98	69.02	68.82	68.84	232450.0
2012-09-28 08:30:00	QQQ	ETF	68.83	68.93	68.81	68.92	246745.0
2012-09-28 09:00:00	QQQ	ETF	68.92	69.16	68.9	68.92	418381.0
2012-09-28 09:30:00	QQQ	ETF	68.92	69.12	68.68	68.75	4293142.0
2012-09-28 10:00:00	QQQ	ETF	68.75	68.94	68.52	68.58	4188382.0
2012-09-28 10:30:00	QQQ	ETF	68.57	68.74	68.55	68.72	2085502.0
2012-09-28 11:00:00	QQQ	ETF	68.73	68.78	68.53	68.53	1905614.0
2012-09-28 11:30:00	QQQ	ETF	68.53	68.71	68.51	68.695	1564723.0
2012-09-28 12:00:00	QQQ	ETF	68.71	68.96	68.67	68.78	2096929.0
2012-09-28 12:30:00	QQQ	ETF	68.79	68.8678	68.75	68.8405	559863.0
2012-09-28 13:00:00	QQQ	ETF	68.85	68.8899	68.71	68.84	860419.0
2012-09-28 13:30:00	QQQ	ETF	68.845	69.05	68.845	68.93	1805910.0
2012-09-28 14:00:00	QQQ	ETF	68.93	68.99	68.71	68.72	945266.0
2012-09-28 14:30:00	QQQ	ETF	68.7299	68.81	68.64	68.77	949113.0
2012-09-28 15:00:00	QQQ	ETF	68.78	68.8301	68.67	68.7	903493.0

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

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