PREVIEW / etf_30min / 2017-12-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-27.parquet
  size:    441 KB
  rows:    15,522

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
2017-12-27 04:00:00	SPY	ETF	267.4	267.45	267.35	267.35	1460.0
2017-12-27 04:30:00	SPY	ETF	267.34	267.34	267.34	267.34	700.0
2017-12-27 05:00:00	SPY	ETF	267.31	267.31	267.31	267.31	400.0
2017-12-27 05:30:00	SPY	ETF	267.45	267.45	267.45	267.45	2000.0
2017-12-27 06:00:00	SPY	ETF	267.48	267.5	267.38	267.5	7497.0
2017-12-27 06:30:00	SPY	ETF	267.48	267.48	267.4	267.4	23500.0
2017-12-27 07:00:00	SPY	ETF	267.4	267.46	267.36	267.36	8351.0
2017-12-27 07:30:00	SPY	ETF	267.42	267.42	267.3	267.35	6494.0
2017-12-27 08:00:00	SPY	ETF	267.47	267.48	267.28	267.48	36406.0
2017-12-27 08:30:00	SPY	ETF	267.47	267.57	267.41	267.57	285694.0
2017-12-27 09:00:00	SPY	ETF	267.56	267.56	267.33	267.37	137902.0
2017-12-27 09:30:00	SPY	ETF	267.38	267.43	267.16	267.335	3709917.0
2017-12-27 10:00:00	SPY	ETF	267.33	267.55	267.33	267.52	3128749.0
2017-12-27 10:30:00	SPY	ETF	267.515	267.67	267.47	267.66	4676816.0
2017-12-27 11:00:00	SPY	ETF	267.66	267.73	267.585	267.6136	3370765.0
2017-12-27 11:30:00	SPY	ETF	267.62	267.63	267.33	267.44	2939048.0
2017-12-27 12:00:00	SPY	ETF	267.43	267.49	267.31	267.32	2411393.0
2017-12-27 12:30:00	SPY	ETF	267.32	267.42	267.27	267.28	3516603.0
2017-12-27 13:00:00	SPY	ETF	267.27	267.4335	267.16	267.21	1884414.0
2017-12-27 13:30:00	SPY	ETF	267.2	267.34	267.17	267.329	2173751.0
2017-12-27 14:00:00	SPY	ETF	267.33	267.33	267.14	267.265	1413564.0
2017-12-27 14:30:00	SPY	ETF	267.27	267.27	267.06	267.18	1959306.0
2017-12-27 15:00:00	SPY	ETF	267.18	267.25	267.05	267.1	2444328.0
2017-12-27 15:30:00	SPY	ETF	267.095	267.35	267.01	267.33	10031844.0
2017-12-27 16:00:00	SPY	ETF	267.34	267.57	267.32	267.45	9109133.0
2017-12-27 16:30:00	SPY	ETF	267.47	267.53	267.32	267.49	1409750.0
2017-12-27 17:00:00	SPY	ETF	267.5	267.51	267.42	267.42	28701.0
2017-12-27 17:30:00	SPY	ETF	267.45	267.47	267.4	267.4	16899.0
2017-12-27 18:00:00	SPY	ETF	267.45	267.55	267.4	267.52	23768.0
2017-12-27 18:30:00	SPY	ETF	267.52	267.55	267.52	267.54	7093.0
2017-12-27 19:00:00	SPY	ETF	267.54	267.57	267.54	267.57	10208.0
2017-12-27 19:30:00	SPY	ETF	267.57	267.58	267.54	267.58	17304.0
2017-12-27 05:30:00	QQQ	ETF	156.69	156.74	156.69	156.74	1500.0
2017-12-27 06:00:00	QQQ	ETF	156.74	156.74	156.74	156.74	111.0
2017-12-27 06:30:00	QQQ	ETF	156.6	156.63	156.6	156.63	4500.0
2017-12-27 07:00:00	QQQ	ETF	156.58	156.63	156.55	156.57	4278.0
2017-12-27 07:30:00	QQQ	ETF	156.5	156.5	156.41	156.48	4800.0
2017-12-27 08:00:00	QQQ	ETF	156.63	156.71	156.4	156.71	28241.0
2017-12-27 08:30:00	QQQ	ETF	156.7	156.73	156.62	156.73	29110.0
2017-12-27 09:00:00	QQQ	ETF	156.73	156.73	156.49	156.49	19347.0
2017-12-27 09:30:00	QQQ	ETF	156.52	156.7895	156.42	156.76	1459301.0
2017-12-27 10:00:00	QQQ	ETF	156.77	156.94	156.77	156.9	867431.0
2017-12-27 10:30:00	QQQ	ETF	156.9	156.935	156.81	156.88	486140.0
2017-12-27 11:00:00	QQQ	ETF	156.88	156.96	156.71	156.8	1779962.0
2017-12-27 11:30:00	QQQ	ETF	156.8	156.8099	156.49	156.53	1630672.0
2017-12-27 12:00:00	QQQ	ETF	156.52	156.67	156.45	156.6086	780298.0
2017-12-27 12:30:00	QQQ	ETF	156.61	156.71	156.54	156.5767	399259.0
2017-12-27 13:00:00	QQQ	ETF	156.57	156.62	156.52	156.56	608806.0
2017-12-27 13:30:00	QQQ	ETF	156.57	156.62	156.525	156.595	610316.0
2017-12-27 14:00:00	QQQ	ETF	156.59	156.62	156.49	156.55	2002841.0

> showing 50 of 15,522 rows — these rows as CSV

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