PREVIEW / etf_30min / 2015-03-27

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-27.parquet
  size:    357 KB
  rows:    12,168

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
2015-03-27 04:00:00	SPY	ETF	205.44	205.64	205.44	205.6	1200.0
2015-03-27 04:30:00	SPY	ETF	205.42	205.51	205.17	205.24	39850.0
2015-03-27 05:00:00	SPY	ETF	205.2	205.29	204.9	204.91	16890.0
2015-03-27 05:30:00	SPY	ETF	204.81	204.89	204.6	204.72	24544.0
2015-03-27 06:00:00	SPY	ETF	204.84	205.1	204.84	205.04	8671.0
2015-03-27 06:30:00	SPY	ETF	205.09	205.09	204.88	204.99	16958.0
2015-03-27 07:00:00	SPY	ETF	204.99	205.21	204.99	205.2	97984.0
2015-03-27 07:30:00	SPY	ETF	205.21	205.36	205.15	205.18	172746.0
2015-03-27 08:00:00	SPY	ETF	204.61	205.33	204.61	205.3	210001.0
2015-03-27 08:30:00	SPY	ETF	205.28	205.28	204.95	205.16	374865.0
2015-03-27 09:00:00	SPY	ETF	205.15	205.16	204.88	205.14	638041.0
2015-03-27 09:30:00	SPY	ETF	205.13	205.66	205.13	205.59	16433273.0
2015-03-27 10:00:00	SPY	ETF	205.58	205.85	204.9	205.47	11941260.0
2015-03-27 10:30:00	SPY	ETF	205.47	205.92	205.04	205.88	8834466.0
2015-03-27 11:00:00	SPY	ETF	205.8849	205.95	205.53	205.61	6093600.0
2015-03-27 11:30:00	SPY	ETF	205.61	205.75	205.27	205.57	4385945.0
2015-03-27 12:00:00	SPY	ETF	205.58	205.6	205.25	205.38	4506852.0
2015-03-27 12:30:00	SPY	ETF	205.38	205.65	205.3	205.61	4894532.0
2015-03-27 13:00:00	SPY	ETF	205.62	205.66	205.32	205.46	2461263.0
2015-03-27 13:30:00	SPY	ETF	205.46	205.66	205.305	205.55	3775967.0
2015-03-27 14:00:00	SPY	ETF	205.545	205.67	205.37	205.507	4767940.0
2015-03-27 14:30:00	SPY	ETF	205.51	205.55	205.38	205.53	3461139.0
2015-03-27 15:00:00	SPY	ETF	205.52	205.72	205.375	205.48	6937489.0
2015-03-27 15:30:00	SPY	ETF	205.49	205.95	205.45	205.72	21295747.0
2015-03-27 16:00:00	SPY	ETF	205.71	205.79	205.54	205.75	7126782.0
2015-03-27 16:30:00	SPY	ETF	205.77	205.79	205.64	205.68	6193386.0
2015-03-27 17:00:00	SPY	ETF	205.74	205.75	205.7	205.74	17759.0
2015-03-27 17:30:00	SPY	ETF	205.73	205.78	205.7	205.751	1742221.0
2015-03-27 18:00:00	SPY	ETF	205.79	206.87	205.79	205.86	99261.0
2015-03-27 18:30:00	SPY	ETF	205.86	205.86	205.8	205.8	22487.0
2015-03-27 19:00:00	SPY	ETF	205.8	205.8	205.78	205.79	9010.0
2015-03-27 19:30:00	SPY	ETF	205.78	205.85	205.77	205.85	16281.0
2015-03-27 04:00:00	QQQ	ETF	105.25	105.26	105.25	105.26	10100.0
2015-03-27 05:30:00	QQQ	ETF	105.01	105.01	104.78	104.78	1750.0
2015-03-27 06:00:00	QQQ	ETF	105.22	105.22	105.22	105.22	250.0
2015-03-27 06:30:00	QQQ	ETF	105.03	105.12	104.97	105.12	23408.0
2015-03-27 07:00:00	QQQ	ETF	105.13	105.17	105.12	105.12	21065.0
2015-03-27 07:30:00	QQQ	ETF	105.16	105.25	105.15	105.2	4637.0
2015-03-27 08:00:00	QQQ	ETF	105.19	105.51	105.14	105.2	34329.0
2015-03-27 08:30:00	QQQ	ETF	105.18	105.18	105.02	105.08	39870.0
2015-03-27 09:00:00	QQQ	ETF	105.07	105.12	104.95	105.04	221175.0
2015-03-27 09:30:00	QQQ	ETF	105.08	105.56	105.07	105.42	4290416.0
2015-03-27 10:00:00	QQQ	ETF	105.42	105.61	104.92	105.2199	3292426.0
2015-03-27 10:30:00	QQQ	ETF	105.215	105.54	105.02	105.53	1513567.0
2015-03-27 11:00:00	QQQ	ETF	105.535	105.61	105.32	105.35	1006407.0
2015-03-27 11:30:00	QQQ	ETF	105.35	105.47	105.15	105.27	844400.0
2015-03-27 12:00:00	QQQ	ETF	105.28	105.28	105.0935	105.16	806589.0
2015-03-27 12:30:00	QQQ	ETF	105.16	105.32	105.1101	105.29	935645.0
2015-03-27 13:00:00	QQQ	ETF	105.3	105.33	105.157	105.235	503469.0
2015-03-27 13:30:00	QQQ	ETF	105.24	105.34	105.13	105.266	959311.0

> showing 50 of 12,168 rows — these rows as CSV

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