PREVIEW / etf_30min / 2013-05-28

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-28.parquet
  size:    334 KB
  rows:    11,181

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-05-28 04:00:00	SPY	ETF	166.68	166.91	166.68	166.79	40067.0
2013-05-28 04:30:00	SPY	ETF	166.74	166.77	166.74	166.75	4200.0
2013-05-28 05:00:00	SPY	ETF	166.77	166.77	166.68	166.73	17855.0
2013-05-28 05:30:00	SPY	ETF	166.78	166.83	166.78	166.78	1700.0
2013-05-28 06:00:00	SPY	ETF	166.75	166.78	166.69	166.7	4800.0
2013-05-28 06:30:00	SPY	ETF	166.65	166.74	166.61	166.67	106690.0
2013-05-28 07:00:00	SPY	ETF	166.69	166.88	166.65	166.84	107898.0
2013-05-28 07:30:00	SPY	ETF	166.83	166.96	166.72	166.75	1093425.0
2013-05-28 08:00:00	SPY	ETF	166.72	166.98	166.67	166.98	649796.0
2013-05-28 08:30:00	SPY	ETF	166.97	166.99	166.88	166.95	390741.0
2013-05-28 09:00:00	SPY	ETF	166.95	167.15	165.293	167.06	1394590.0
2013-05-28 09:30:00	SPY	ETF	167.04	167.49	166.93	167.49	17810239.0
2013-05-28 10:00:00	SPY	ETF	167.48	167.78	167.35	167.69	12147990.0
2013-05-28 10:30:00	SPY	ETF	167.6918	167.72	167.25	167.321	8771810.0
2013-05-28 11:00:00	SPY	ETF	167.325	167.358	167.02	167.24	8986917.0
2013-05-28 11:30:00	SPY	ETF	167.24	167.27	166.74	166.76	7874153.0
2013-05-28 12:00:00	SPY	ETF	166.76	166.99	166.71	166.86	4309866.0
2013-05-28 12:30:00	SPY	ETF	166.851	166.98	166.71	166.85	3814525.0
2013-05-28 13:00:00	SPY	ETF	166.85	167.02	166.54	166.59	5873924.0
2013-05-28 13:30:00	SPY	ETF	166.58	166.64	166.02	166.13	12097472.0
2013-05-28 14:00:00	SPY	ETF	166.13	166.22	165.86	166.09	9542275.0
2013-05-28 14:30:00	SPY	ETF	166.09	166.35	165.81	166.22	7927754.0
2013-05-28 15:00:00	SPY	ETF	166.215	166.42	166.09	166.28	9656771.0
2013-05-28 15:30:00	SPY	ETF	166.28	166.65	166.25	166.3	17133540.0
2013-05-28 16:00:00	SPY	ETF	166.32	166.4711	165.92	166.06	9352354.0
2013-05-28 16:30:00	SPY	ETF	166.07	166.29	166.07	166.19	1138157.0
2013-05-28 17:00:00	SPY	ETF	166.2	166.2	166.11	166.14	573554.0
2013-05-28 17:30:00	SPY	ETF	166.11	166.11	165.98	165.98	84058.0
2013-05-28 18:00:00	SPY	ETF	165.98	166.0	165.8	165.92	193856.0
2013-05-28 18:30:00	SPY	ETF	165.92	165.99	165.88	165.94	46761.0
2013-05-28 19:00:00	SPY	ETF	165.94	166.03	165.94	166.0	10600.0
2013-05-28 19:30:00	SPY	ETF	166.02	166.06	166.01	166.03	41699.0
2013-05-28 04:00:00	QQQ	ETF	74.08	74.17	74.08	74.15	4400.0
2013-05-28 04:30:00	QQQ	ETF	74.17	74.17	74.13	74.13	530.0
2013-05-28 06:00:00	QQQ	ETF	74.12	74.12	74.11	74.11	2100.0
2013-05-28 06:30:00	QQQ	ETF	74.06	74.08	74.06	74.08	911.0
2013-05-28 07:00:00	QQQ	ETF	74.08	74.16	74.08	74.12	15580.0
2013-05-28 07:30:00	QQQ	ETF	74.12	74.15	74.1	74.1	6584.0
2013-05-28 08:00:00	QQQ	ETF	74.08	74.2	74.06	74.12	102077.0
2013-05-28 08:30:00	QQQ	ETF	74.12	74.14	74.1	74.13	71363.0
2013-05-28 09:00:00	QQQ	ETF	74.14	74.28	74.11	74.26	265085.0
2013-05-28 09:30:00	QQQ	ETF	74.25	74.45	74.12	74.44	3737967.0
2013-05-28 10:00:00	QQQ	ETF	74.44	74.54	74.38	74.4998	3194805.0
2013-05-28 10:30:00	QQQ	ETF	74.5	74.505	74.27	74.33	2009681.0
2013-05-28 11:00:00	QQQ	ETF	74.34	74.3894	74.22	74.34	2143687.0
2013-05-28 11:30:00	QQQ	ETF	74.35	74.36	74.09	74.1	1381827.0
2013-05-28 12:00:00	QQQ	ETF	74.101	74.19	74.08	74.11	915724.0
2013-05-28 12:30:00	QQQ	ETF	74.11	74.1474	74.02	74.11	1125665.0
2013-05-28 13:00:00	QQQ	ETF	74.115	74.19	73.94	73.96	1336669.0
2013-05-28 13:30:00	QQQ	ETF	73.97	73.985	73.73	73.78	2425660.0

> showing 50 of 11,181 rows — these rows as CSV

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