PREVIEW / etf_30min / 2017-10-11

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-11.parquet
  size:    429 KB
  rows:    14,860

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-10-11 04:00:00	SPY	ETF	254.28	254.33	254.28	254.31	4130.0
2017-10-11 04:30:00	SPY	ETF	254.36	254.36	254.28	254.28	1800.0
2017-10-11 05:00:00	SPY	ETF	254.33	254.33	254.24	254.24	2100.0
2017-10-11 05:30:00	SPY	ETF	254.26	254.33	254.26	254.33	2450.0
2017-10-11 06:00:00	SPY	ETF	254.36	254.41	254.36	254.41	1700.0
2017-10-11 06:30:00	SPY	ETF	254.41	254.46	254.41	254.43	4703.0
2017-10-11 07:00:00	SPY	ETF	254.38	254.41	254.3	254.3	18631.0
2017-10-11 07:30:00	SPY	ETF	254.32	254.32	254.15	254.22	114893.0
2017-10-11 08:00:00	SPY	ETF	254.23	254.6	254.15	254.38	126135.0
2017-10-11 08:30:00	SPY	ETF	254.38	254.42	254.28	254.38	44175.0
2017-10-11 09:00:00	SPY	ETF	254.39	254.53	254.37	254.5	157630.0
2017-10-11 09:30:00	SPY	ETF	254.51	254.6425	254.32	254.43	3043093.0
2017-10-11 10:00:00	SPY	ETF	254.44	254.64	254.385	254.575	1951774.0
2017-10-11 10:30:00	SPY	ETF	254.58	254.65	254.54	254.56	1381450.0
2017-10-11 11:00:00	SPY	ETF	254.55	254.7	254.51	254.54	4068680.0
2017-10-11 11:30:00	SPY	ETF	254.545	254.66	254.515	254.58	901371.0
2017-10-11 12:00:00	SPY	ETF	254.59	254.78	254.58	254.77	1507258.0
2017-10-11 12:30:00	SPY	ETF	254.77	254.79	254.7	254.705	989061.0
2017-10-11 13:00:00	SPY	ETF	254.7	254.81	254.65	254.69	1183877.0
2017-10-11 13:30:00	SPY	ETF	254.69	254.71	254.6299	254.645	2222571.0
2017-10-11 14:00:00	SPY	ETF	254.64	254.89	254.62	254.66	1857514.0
2017-10-11 14:30:00	SPY	ETF	254.67	254.8	254.6	254.745	2496522.0
2017-10-11 15:00:00	SPY	ETF	254.745	254.97	254.73	254.8864	3926768.0
2017-10-11 15:30:00	SPY	ETF	254.88	255.02	254.87	255.0	8580854.0
2017-10-11 16:00:00	SPY	ETF	255.01	255.05	254.95	254.98	10798470.0
2017-10-11 16:30:00	SPY	ETF	254.97	255.02	254.94	254.95	727231.0
2017-10-11 17:00:00	SPY	ETF	254.96	255.02	254.96	254.99	216810.0
2017-10-11 17:30:00	SPY	ETF	254.97	254.98	254.95	254.96	44107.0
2017-10-11 18:00:00	SPY	ETF	254.95	254.97	254.9	254.92	85502.0
2017-10-11 18:30:00	SPY	ETF	254.92	254.92	254.89	254.92	18022.0
2017-10-11 19:00:00	SPY	ETF	254.92	254.92	254.91	254.91	5005.0
2017-10-11 19:30:00	SPY	ETF	254.9	254.91	254.88	254.88	29443.0
2017-10-11 04:00:00	QQQ	ETF	147.43	147.46	147.41	147.46	10420.0
2017-10-11 04:30:00	QQQ	ETF	147.46	147.46	147.43	147.44	3500.0
2017-10-11 05:30:00	QQQ	ETF	147.41	147.41	147.4	147.4	800.0
2017-10-11 06:00:00	QQQ	ETF	147.46	147.46	147.46	147.46	2500.0
2017-10-11 06:30:00	QQQ	ETF	147.56	147.56	147.53	147.54	13500.0
2017-10-11 07:00:00	QQQ	ETF	147.5	147.54	147.48	147.48	41269.0
2017-10-11 07:30:00	QQQ	ETF	147.4	147.41	147.29	147.36	78473.0
2017-10-11 08:00:00	QQQ	ETF	147.34	147.41	147.31	147.41	54720.0
2017-10-11 08:30:00	QQQ	ETF	147.42	147.48	147.39	147.46	41043.0
2017-10-11 09:00:00	QQQ	ETF	147.47	147.55	147.47	147.54	54361.0
2017-10-11 09:30:00	QQQ	ETF	147.53	147.665	147.34	147.51	1814177.0
2017-10-11 10:00:00	QQQ	ETF	147.52	147.81	147.48	147.73	971822.0
2017-10-11 10:30:00	QQQ	ETF	147.73	147.8068	147.63	147.67	512536.0
2017-10-11 11:00:00	QQQ	ETF	147.65	147.7885	147.55	147.575	459673.0
2017-10-11 11:30:00	QQQ	ETF	147.57	147.705	147.57	147.67	317958.0
2017-10-11 12:00:00	QQQ	ETF	147.68	147.778	147.67	147.76	457044.0
2017-10-11 12:30:00	QQQ	ETF	147.76	147.79	147.6947	147.735	421474.0
2017-10-11 13:00:00	QQQ	ETF	147.735	147.835	147.67	147.7	364129.0

> showing 50 of 14,860 rows — these rows as CSV

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