PREVIEW / etf_30min / 2016-09-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-23.parquet
  size:    391 KB
  rows:    13,402

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
2016-09-23 04:00:00	SPY	ETF	216.91	216.91	216.65	216.65	20423.0
2016-09-23 04:30:00	SPY	ETF	216.65	216.74	216.65	216.7	23724.0
2016-09-23 05:00:00	SPY	ETF	216.72	216.8	216.7	216.78	17557.0
2016-09-23 05:30:00	SPY	ETF	216.8	216.92	216.79	216.82	8477.0
2016-09-23 06:00:00	SPY	ETF	216.79	216.9	216.77	216.84	9641.0
2016-09-23 06:30:00	SPY	ETF	216.81	216.83	216.66	216.66	17061.0
2016-09-23 07:00:00	SPY	ETF	216.73	216.8	216.66	216.66	80846.0
2016-09-23 07:30:00	SPY	ETF	216.66	216.75	216.61	216.69	140931.0
2016-09-23 08:00:00	SPY	ETF	216.7	216.79	216.64	216.75	79016.0
2016-09-23 08:30:00	SPY	ETF	216.74	216.92	216.72	216.92	354101.0
2016-09-23 09:00:00	SPY	ETF	216.91	216.97	216.71	216.71	397291.0
2016-09-23 09:30:00	SPY	ETF	216.72	216.88	216.45	216.58	7592620.0
2016-09-23 10:00:00	SPY	ETF	216.575	216.74	216.46	216.65	4462196.0
2016-09-23 10:30:00	SPY	ETF	216.66	216.79	216.52	216.69	2708659.0
2016-09-23 11:00:00	SPY	ETF	216.69	216.8	216.52	216.64	2481118.0
2016-09-23 11:30:00	SPY	ETF	216.635	216.8	216.41	216.48	2726905.0
2016-09-23 12:00:00	SPY	ETF	216.47	216.6	216.43	216.6	2152914.0
2016-09-23 12:30:00	SPY	ETF	216.595	216.63	216.42	216.51	3508803.0
2016-09-23 13:00:00	SPY	ETF	216.5	216.515	216.24	216.37	4058998.0
2016-09-23 13:30:00	SPY	ETF	216.37	216.38	215.88	215.94	5298457.0
2016-09-23 14:00:00	SPY	ETF	215.94	216.26	215.9	216.2	6530634.0
2016-09-23 14:30:00	SPY	ETF	216.2	216.325	216.1	216.29	3592513.0
2016-09-23 15:00:00	SPY	ETF	216.28	216.41	216.11	216.386	4133220.0
2016-09-23 15:30:00	SPY	ETF	216.39	216.57	215.97	215.98	13057665.0
2016-09-23 16:00:00	SPY	ETF	216.0	216.22	215.965	216.08	7875104.0
2016-09-23 16:30:00	SPY	ETF	216.09	216.09	215.99	216.01	356293.0
2016-09-23 17:00:00	SPY	ETF	215.99	216.01	215.94	215.99	732868.0
2016-09-23 17:30:00	SPY	ETF	215.99	216.04	215.87	215.89	149637.0
2016-09-23 18:00:00	SPY	ETF	215.9	215.95	215.85	215.93	20995.0
2016-09-23 18:30:00	SPY	ETF	215.9	215.93	215.89	215.92	19196.0
2016-09-23 19:00:00	SPY	ETF	215.9	215.93	215.88	215.89	15247.0
2016-09-23 19:30:00	SPY	ETF	215.91	215.91	215.84	215.84	23731.0
2016-09-23 04:00:00	QQQ	ETF	118.97	118.97	118.96	118.96	2700.0
2016-09-23 04:30:00	QQQ	ETF	118.92	118.92	118.91	118.91	4750.0
2016-09-23 05:00:00	QQQ	ETF	118.89	118.89	118.89	118.89	1998.0
2016-09-23 05:30:00	QQQ	ETF	119.01	119.01	118.95	118.95	565.0
2016-09-23 06:00:00	QQQ	ETF	118.95	118.95	118.92	118.92	550.0
2016-09-23 06:30:00	QQQ	ETF	118.93	118.94	118.89	118.91	11500.0
2016-09-23 07:00:00	QQQ	ETF	118.9	118.93	118.84	118.84	52643.0
2016-09-23 07:30:00	QQQ	ETF	118.83	118.86	118.8	118.85	140313.0
2016-09-23 08:00:00	QQQ	ETF	118.86	118.88	118.83	118.87	19402.0
2016-09-23 08:30:00	QQQ	ETF	118.86	118.98	118.85	118.96	31001.0
2016-09-23 09:00:00	QQQ	ETF	118.95	119.01	118.9	118.91	172719.0
2016-09-23 09:30:00	QQQ	ETF	118.92	119.0	118.68	118.69	2708471.0
2016-09-23 10:00:00	QQQ	ETF	118.69	118.76	118.56	118.6497	1151735.0
2016-09-23 10:30:00	QQQ	ETF	118.66	118.76	118.525	118.67	712982.0
2016-09-23 11:00:00	QQQ	ETF	118.6763	118.809	118.64	118.76	734966.0
2016-09-23 11:30:00	QQQ	ETF	118.75	118.84	118.7	118.72	849368.0
2016-09-23 12:00:00	QQQ	ETF	118.715	118.84	118.69	118.81	642660.0
2016-09-23 12:30:00	QQQ	ETF	118.82	118.85	118.73	118.78	717692.0

> showing 50 of 13,402 rows — these rows as CSV

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