PREVIEW / etf_30min / 2013-01-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-16.parquet
  size:    297 KB
  rows:    10,229

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-01-16 04:00:00	SPY	ETF	146.84	146.84	146.41	146.45	18399.0
2013-01-16 04:30:00	SPY	ETF	146.5	146.5	146.45	146.45	300.0
2013-01-16 05:00:00	SPY	ETF	146.42	146.56	146.38	146.5	12868.0
2013-01-16 05:30:00	SPY	ETF	146.52	146.58	146.52	146.55	23100.0
2013-01-16 06:00:00	SPY	ETF	146.58	146.8	146.58	146.69	73195.0
2013-01-16 06:30:00	SPY	ETF	146.71	146.71	146.63	146.63	17739.0
2013-01-16 07:00:00	SPY	ETF	146.72	146.72	146.48	146.5	216272.0
2013-01-16 07:30:00	SPY	ETF	146.49	146.71	146.39	146.4	588898.0
2013-01-16 08:00:00	SPY	ETF	146.42	146.76	146.4	146.73	442624.0
2013-01-16 08:30:00	SPY	ETF	146.73	146.73	146.49	146.55	673482.0
2013-01-16 09:00:00	SPY	ETF	146.555	146.77	146.555	146.77	3112575.0
2013-01-16 09:30:00	SPY	ETF	146.77	146.87	146.61	146.82	15023686.0
2013-01-16 10:00:00	SPY	ETF	146.81	147.03	146.8	146.97	7384371.0
2013-01-16 10:30:00	SPY	ETF	146.98	146.99	146.82	146.82	3706855.0
2013-01-16 11:00:00	SPY	ETF	146.82	147.185	146.82	147.11	5481214.0
2013-01-16 11:30:00	SPY	ETF	147.11	147.17	147.02	147.05	3649570.0
2013-01-16 12:00:00	SPY	ETF	147.0502	147.12	147.01	147.0202	3285614.0
2013-01-16 12:30:00	SPY	ETF	147.02	147.07	146.89	146.985	3687969.0
2013-01-16 13:00:00	SPY	ETF	146.99	147.09	146.92	147.04	5752810.0
2013-01-16 13:30:00	SPY	ETF	147.05	147.25	147.04	147.17	5599126.0
2013-01-16 14:00:00	SPY	ETF	147.17	147.24	147.06	147.21	3348531.0
2013-01-16 14:30:00	SPY	ETF	147.21	147.28	147.155	147.25	3571636.0
2013-01-16 15:00:00	SPY	ETF	147.2501	147.26	147.05	147.07	5312530.0
2013-01-16 15:30:00	SPY	ETF	147.07	147.18	147.01	147.04	16483601.0
2013-01-16 16:00:00	SPY	ETF	147.03	147.1442	146.88	146.92	14515370.0
2013-01-16 16:30:00	SPY	ETF	146.92	147.1149	146.83	146.86	1141908.0
2013-01-16 17:00:00	SPY	ETF	146.87	146.89	146.83	146.88	72071.0
2013-01-16 17:30:00	SPY	ETF	146.88	146.88	146.82	146.87	18684.0
2013-01-16 18:00:00	SPY	ETF	146.88	146.89	146.83	146.83	25042.0
2013-01-16 18:30:00	SPY	ETF	146.81	146.83	146.71	146.75	15349.0
2013-01-16 19:00:00	SPY	ETF	146.77	146.88	146.77	146.88	38069.0
2013-01-16 19:30:00	SPY	ETF	146.85	146.95	146.78	146.95	23100.0
2013-01-16 05:00:00	QQQ	ETF	66.49	66.51	66.49	66.51	3700.0
2013-01-16 05:30:00	QQQ	ETF	66.51	66.51	66.51	66.51	5000.0
2013-01-16 06:30:00	QQQ	ETF	66.63	66.63	66.59	66.59	2500.0
2013-01-16 07:00:00	QQQ	ETF	66.61	66.61	66.52	66.54	140170.0
2013-01-16 07:30:00	QQQ	ETF	66.54	66.59	66.46	66.53	650600.0
2013-01-16 08:00:00	QQQ	ETF	66.54	66.65	66.48	66.64	849407.0
2013-01-16 08:30:00	QQQ	ETF	66.64	66.64	66.55	66.59	185152.0
2013-01-16 09:00:00	QQQ	ETF	66.59	66.75	66.59	66.75	80307.0
2013-01-16 09:30:00	QQQ	ETF	66.75	66.83	66.6	66.8	3879469.0
2013-01-16 10:00:00	QQQ	ETF	66.79	67.0	66.74	66.94	4218178.0
2013-01-16 10:30:00	QQQ	ETF	66.95	66.96	66.8	66.815	1797941.0
2013-01-16 11:00:00	QQQ	ETF	66.81	66.96	66.8	66.93	1203292.0
2013-01-16 11:30:00	QQQ	ETF	66.929	66.98	66.891	66.91	676714.0
2013-01-16 12:00:00	QQQ	ETF	66.9	66.9407	66.88	66.91	1604076.0
2013-01-16 12:30:00	QQQ	ETF	66.91	66.91	66.8	66.8201	569940.0
2013-01-16 13:00:00	QQQ	ETF	66.83	66.9	66.82	66.875	761462.0
2013-01-16 13:30:00	QQQ	ETF	66.871	67.01	66.87	66.99	2063150.0
2013-01-16 14:00:00	QQQ	ETF	66.99	67.08	66.93	67.06	1295080.0

> showing 50 of 10,229 rows — these rows as CSV

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