PREVIEW / etf_30min / 2014-09-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-11.parquet
  size:    337 KB
  rows:    11,544

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
2014-09-11 04:00:00	SPY	ETF	199.85	199.88	199.78	199.78	29953.0
2014-09-11 04:30:00	SPY	ETF	199.73	199.73	199.44	199.56	13791.0
2014-09-11 05:00:00	SPY	ETF	199.56	199.56	199.53	199.54	7674.0
2014-09-11 05:30:00	SPY	ETF	199.58	199.64	199.58	199.64	4915.0
2014-09-11 06:00:00	SPY	ETF	199.63	199.73	199.63	199.7	3628.0
2014-09-11 06:30:00	SPY	ETF	199.69	199.69	199.5	199.52	53006.0
2014-09-11 07:00:00	SPY	ETF	199.52	199.57	199.4	199.57	96919.0
2014-09-11 07:30:00	SPY	ETF	199.58	199.62	199.31	199.34	228901.0
2014-09-11 08:00:00	SPY	ETF	199.34	199.87	199.25	199.42	526148.0
2014-09-11 08:30:00	SPY	ETF	199.38	199.46	199.11	199.19	706378.0
2014-09-11 09:00:00	SPY	ETF	199.16	199.33	199.16	199.27	609185.0
2014-09-11 09:30:00	SPY	ETF	199.27	199.89	199.2	199.87	8796422.0
2014-09-11 10:00:00	SPY	ETF	199.87	199.95	199.54	199.56	4651219.0
2014-09-11 10:30:00	SPY	ETF	199.56	199.56	199.12	199.46	6638979.0
2014-09-11 11:00:00	SPY	ETF	199.46	199.92	199.46	199.75	4781543.0
2014-09-11 11:30:00	SPY	ETF	199.75	199.97	199.72	199.84	4108170.0
2014-09-11 12:00:00	SPY	ETF	199.84	200.13	199.69	200.12	5153245.0
2014-09-11 12:30:00	SPY	ETF	200.12	200.13	199.75	199.86	2266332.0
2014-09-11 13:00:00	SPY	ETF	199.87	199.96	199.5	199.6201	2565064.0
2014-09-11 13:30:00	SPY	ETF	199.63	199.76	199.54	199.675	2751518.0
2014-09-11 14:00:00	SPY	ETF	199.675	200.07	199.64	200.031	2800580.0
2014-09-11 14:30:00	SPY	ETF	200.04	200.19	199.97	200.04	3181008.0
2014-09-11 15:00:00	SPY	ETF	200.04	200.19	199.9	200.12	3700587.0
2014-09-11 15:30:00	SPY	ETF	200.115	200.33	200.03	200.28	7997146.0
2014-09-11 16:00:00	SPY	ETF	200.29	200.3	199.8313	200.26	3531190.0
2014-09-11 16:30:00	SPY	ETF	200.27	200.5	200.26	200.5	711945.0
2014-09-11 17:00:00	SPY	ETF	200.49	200.52	200.46	200.48	91941.0
2014-09-11 17:30:00	SPY	ETF	200.46	200.49	200.45	200.49	10650.0
2014-09-11 18:00:00	SPY	ETF	200.5	200.5	200.33	200.34	49580.0
2014-09-11 18:30:00	SPY	ETF	200.34	200.35	200.32	200.32	3500.0
2014-09-11 19:00:00	SPY	ETF	200.35	200.35	200.32	200.34	10825.0
2014-09-11 19:30:00	SPY	ETF	200.35	200.35	200.32	200.33	16000.0
2014-09-11 04:30:00	QQQ	ETF	99.84	99.84	99.77	99.77	16000.0
2014-09-11 05:00:00	QQQ	ETF	99.8	99.8	99.76	99.76	700.0
2014-09-11 05:30:00	QQQ	ETF	99.82	99.82	99.82	99.82	1000.0
2014-09-11 06:00:00	QQQ	ETF	99.88	99.91	99.85	99.91	1052.0
2014-09-11 06:30:00	QQQ	ETF	99.89	99.89	99.8	99.8	8000.0
2014-09-11 07:00:00	QQQ	ETF	99.8	99.83	99.76	99.8	29460.0
2014-09-11 07:30:00	QQQ	ETF	99.86	99.88	99.73	99.74	95338.0
2014-09-11 08:00:00	QQQ	ETF	99.75	99.8	99.74	99.78	126718.0
2014-09-11 08:30:00	QQQ	ETF	99.77	100.07	99.58	99.6	232292.0
2014-09-11 09:00:00	QQQ	ETF	99.6	99.68	99.6	99.64	135803.0
2014-09-11 09:30:00	QQQ	ETF	99.64	99.93	99.55	99.91	3621220.0
2014-09-11 10:00:00	QQQ	ETF	99.911	99.94	99.66	99.69	2067964.0
2014-09-11 10:30:00	QQQ	ETF	99.68	99.685	99.38	99.535	2396344.0
2014-09-11 11:00:00	QQQ	ETF	99.54	99.81	99.51	99.68	1872034.0
2014-09-11 11:30:00	QQQ	ETF	99.69	99.77	99.64	99.6801	983046.0
2014-09-11 12:00:00	QQQ	ETF	99.69	99.83	99.586	99.825	1090964.0
2014-09-11 12:30:00	QQQ	ETF	99.825	99.83	99.53	99.61	960291.0
2014-09-11 13:00:00	QQQ	ETF	99.615	99.65	99.3	99.37	1724581.0

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

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