PREVIEW / etf_30min / 2011-06-17

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-17.parquet
  size:    280 KB
  rows:    9,331

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-06-17 04:00:00	SPY	ETF	126.71	126.71	126.44	126.45	4280.0
2011-06-17 04:30:00	SPY	ETF	126.35	126.62	126.35	126.42	1300.0
2011-06-17 05:00:00	SPY	ETF	126.49	127.1	126.47	127.07	7330.0
2011-06-17 05:30:00	SPY	ETF	127.05	127.24	127.0	127.24	7967.0
2011-06-17 06:00:00	SPY	ETF	127.15	127.55	126.98	127.52	5600.0
2011-06-17 06:30:00	SPY	ETF	127.46	127.84	127.42	127.73	72520.0
2011-06-17 07:00:00	SPY	ETF	127.76	127.99	127.75	127.84	431148.0
2011-06-17 07:30:00	SPY	ETF	127.87	128.19	127.78	128.07	596596.0
2011-06-17 08:00:00	SPY	ETF	127.92	128.15	127.8	127.92	1947843.0
2011-06-17 08:30:00	SPY	ETF	127.93	128.1	127.85	128.03	1382157.0
2011-06-17 09:00:00	SPY	ETF	128.02	128.02	127.82	127.93	2914938.0
2011-06-17 09:30:00	SPY	ETF	127.93	127.93	127.42	127.64	26035268.0
2011-06-17 10:00:00	SPY	ETF	127.64	127.94	127.18	127.36	22545826.0
2011-06-17 10:30:00	SPY	ETF	127.37	127.8222	127.29	127.57	15864296.0
2011-06-17 11:00:00	SPY	ETF	127.58	127.68	127.29	127.65	15653398.0
2011-06-17 11:30:00	SPY	ETF	127.66	127.68	127.38	127.561	13390474.0
2011-06-17 12:00:00	SPY	ETF	127.57	127.6	127.12	127.26	7779434.0
2011-06-17 12:30:00	SPY	ETF	127.25	127.3	126.95	127.08	12353957.0
2011-06-17 13:00:00	SPY	ETF	127.09	127.095	126.8	126.99	9445258.0
2011-06-17 13:30:00	SPY	ETF	126.99	127.19	126.88	126.97	8995586.0
2011-06-17 14:00:00	SPY	ETF	126.97	127.45	126.9499	127.43	13706593.0
2011-06-17 14:30:00	SPY	ETF	127.43	127.46	127.12	127.19	6993272.0
2011-06-17 15:00:00	SPY	ETF	127.2	127.28	126.62	126.92	19596329.0
2011-06-17 15:30:00	SPY	ETF	126.92	127.34	126.87	127.05	31084303.0
2011-06-17 16:00:00	SPY	ETF	127.06	127.5	126.6688	127.01	15795334.0
2011-06-17 16:30:00	SPY	ETF	127.0	127.03	126.97	127.0	1337083.0
2011-06-17 17:00:00	SPY	ETF	127.0	127.02	126.96	127.01	248927.0
2011-06-17 17:30:00	SPY	ETF	127.01	127.02	126.95	126.96	53315.0
2011-06-17 18:00:00	SPY	ETF	126.96	127.02	126.93	126.97	1579662.0
2011-06-17 18:30:00	SPY	ETF	126.97	127.05	126.96	127.0	50039.0
2011-06-17 19:00:00	SPY	ETF	126.95	127.0	126.95	127.0	4501.0
2011-06-17 19:30:00	SPY	ETF	126.98	127.22	126.98	127.14	130889.0
2011-06-17 04:00:00	QQQ	ETF	53.85	53.85	53.85	53.85	200.0
2011-06-17 06:30:00	QQQ	ETF	54.22	54.3	54.22	54.28	1090.0
2011-06-17 07:00:00	QQQ	ETF	54.32	54.4	54.28	54.36	44790.0
2011-06-17 07:30:00	QQQ	ETF	54.31	54.44	54.3	54.39	61275.0
2011-06-17 08:00:00	QQQ	ETF	54.38	54.41	54.3	54.31	573075.0
2011-06-17 08:30:00	QQQ	ETF	54.31	54.38	54.29	54.38	549253.0
2011-06-17 09:00:00	QQQ	ETF	54.38	54.46	54.31	54.45	822615.0
2011-06-17 09:30:00	QQQ	ETF	54.45	54.52	54.18	54.2	10122870.0
2011-06-17 10:00:00	QQQ	ETF	54.2	54.329	53.975	54.03	7290943.0
2011-06-17 10:30:00	QQQ	ETF	54.03	54.19	53.98	54.07	4369374.0
2011-06-17 11:00:00	QQQ	ETF	54.07	54.14	53.94	54.09	4203453.0
2011-06-17 11:30:00	QQQ	ETF	54.1	54.11	53.98	54.06	2595032.0
2011-06-17 12:00:00	QQQ	ETF	54.06	54.08	53.9	53.9425	2140147.0
2011-06-17 12:30:00	QQQ	ETF	53.94	53.98	53.795	53.859	3904931.0
2011-06-17 13:00:00	QQQ	ETF	53.86	53.87	53.73	53.83	1930773.0
2011-06-17 13:30:00	QQQ	ETF	53.8299	53.94	53.76	53.82	2967695.0
2011-06-17 14:00:00	QQQ	ETF	53.82	54.0	53.8	53.9895	2906691.0
2011-06-17 14:30:00	QQQ	ETF	53.9881	54.0	53.86	53.885	1685503.0

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

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