PREVIEW / etf_30min / 2017-11-14

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-14.parquet
  size:    440 KB
  rows:    15,311

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-11-14 04:00:00	SPY	ETF	258.1	258.1	258.05	258.08	529.0
2017-11-14 04:30:00	SPY	ETF	258.05	258.05	257.95	257.95	683.0
2017-11-14 05:00:00	SPY	ETF	258.02	258.02	257.87	257.88	9770.0
2017-11-14 05:30:00	SPY	ETF	257.92	257.95	257.91	257.92	4600.0
2017-11-14 06:00:00	SPY	ETF	257.95	258.02	257.89	257.92	3200.0
2017-11-14 06:30:00	SPY	ETF	257.93	258.07	257.92	258.02	6810.0
2017-11-14 07:00:00	SPY	ETF	257.97	257.97	257.69	257.7	71495.0
2017-11-14 07:30:00	SPY	ETF	257.68	257.82	257.6	257.76	204463.0
2017-11-14 08:00:00	SPY	ETF	257.97	257.97	257.66	257.87	109789.0
2017-11-14 08:30:00	SPY	ETF	257.88	257.88	257.51	257.52	238744.0
2017-11-14 09:00:00	SPY	ETF	257.53	257.59	257.31	257.4	516114.0
2017-11-14 09:30:00	SPY	ETF	257.41	257.67	257.16	257.24	5957347.0
2017-11-14 10:00:00	SPY	ETF	257.235	257.26	256.52	257.08	7861462.0
2017-11-14 10:30:00	SPY	ETF	257.0785	257.85	256.89	257.695	5495030.0
2017-11-14 11:00:00	SPY	ETF	257.7	257.78	257.51	257.58	2839519.0
2017-11-14 11:30:00	SPY	ETF	257.58	257.77	257.48	257.74	2992552.0
2017-11-14 12:00:00	SPY	ETF	257.74	257.82	257.615	257.7	1677523.0
2017-11-14 12:30:00	SPY	ETF	257.7	257.84	257.14	257.31	4926493.0
2017-11-14 13:00:00	SPY	ETF	257.3	257.45	257.08	257.43	3107505.0
2017-11-14 13:30:00	SPY	ETF	257.43	257.66	257.3325	257.51	1774367.0
2017-11-14 14:00:00	SPY	ETF	257.52	257.69	257.45	257.615	1604757.0
2017-11-14 14:30:00	SPY	ETF	257.62	257.73	257.51	257.68	1851280.0
2017-11-14 15:00:00	SPY	ETF	257.68	257.81	257.56	257.57	2675359.0
2017-11-14 15:30:00	SPY	ETF	257.565	257.805	257.45	257.75	7079612.0
2017-11-14 16:00:00	SPY	ETF	257.74	257.86	257.72	257.83	8085352.0
2017-11-14 16:30:00	SPY	ETF	257.8	257.8	257.72	257.79	253671.0
2017-11-14 17:00:00	SPY	ETF	257.76	257.7726	257.68	257.71	844337.0
2017-11-14 17:30:00	SPY	ETF	257.72	257.72	257.68	257.71	15079.0
2017-11-14 18:00:00	SPY	ETF	257.7	257.71	257.56	257.62	69315.0
2017-11-14 18:30:00	SPY	ETF	257.62	257.62	257.5	257.51	22365.0
2017-11-14 19:00:00	SPY	ETF	257.55	257.55	257.21	257.28	40338.0
2017-11-14 19:30:00	SPY	ETF	257.28	257.28	256.96	257.23	87224.0
2017-11-14 04:00:00	QQQ	ETF	153.73	153.73	153.7	153.7	2000.0
2017-11-14 04:30:00	QQQ	ETF	153.79	153.79	153.64	153.79	2600.0
2017-11-14 05:30:00	QQQ	ETF	153.78	153.8	153.78	153.8	5500.0
2017-11-14 06:00:00	QQQ	ETF	153.79	153.8	153.79	153.8	5000.0
2017-11-14 06:30:00	QQQ	ETF	153.81	153.81	153.8	153.8	10000.0
2017-11-14 07:00:00	QQQ	ETF	153.72	153.72	153.58	153.58	36146.0
2017-11-14 07:30:00	QQQ	ETF	153.59	153.65	153.5	153.64	47358.0
2017-11-14 08:00:00	QQQ	ETF	153.76	153.76	153.54	153.72	46599.0
2017-11-14 08:30:00	QQQ	ETF	153.7	153.73	153.44	153.44	84939.0
2017-11-14 09:00:00	QQQ	ETF	153.45	153.5	153.28	153.31	224923.0
2017-11-14 09:30:00	QQQ	ETF	153.31	153.42	152.94	153.03	2864705.0
2017-11-14 10:00:00	QQQ	ETF	153.02	153.21	152.57	153.04	3663145.0
2017-11-14 10:30:00	QQQ	ETF	153.035	153.49	152.875	153.31	2122161.0
2017-11-14 11:00:00	QQQ	ETF	153.31	153.43	153.24	153.3046	1085049.0
2017-11-14 11:30:00	QQQ	ETF	153.32	153.46	153.23	153.44	866910.0
2017-11-14 12:00:00	QQQ	ETF	153.43	153.5	153.29	153.3	468564.0
2017-11-14 12:30:00	QQQ	ETF	153.3033	153.4	152.7599	152.88	869232.0
2017-11-14 13:00:00	QQQ	ETF	152.87	153.01	152.61	152.95	1006169.0

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

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