PREVIEW / etf_30min / 2018-04-05

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-05.parquet
  size:    467 KB
  rows:    16,016

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
2018-04-05 04:00:00	SPY	ETF	265.7	265.83	265.38	265.38	31125.0
2018-04-05 04:30:00	SPY	ETF	265.45	265.5	265.13	265.24	8912.0
2018-04-05 05:00:00	SPY	ETF	265.1	265.17	264.88	265.03	9590.0
2018-04-05 05:30:00	SPY	ETF	264.96	265.28	264.7	265.28	17954.0
2018-04-05 06:00:00	SPY	ETF	265.15	265.34	265.04	265.12	15161.0
2018-04-05 06:30:00	SPY	ETF	265.21	265.3	264.99	264.99	28358.0
2018-04-05 07:00:00	SPY	ETF	265.02	265.47	264.92	265.35	120483.0
2018-04-05 07:30:00	SPY	ETF	265.35	265.4	265.18	265.24	103749.0
2018-04-05 08:00:00	SPY	ETF	265.3	266.33	264.97	265.43	433215.0
2018-04-05 08:30:00	SPY	ETF	265.45	265.72	265.22	265.54	274992.0
2018-04-05 09:00:00	SPY	ETF	265.55	265.65	265.31	265.54	532778.0
2018-04-05 09:30:00	SPY	ETF	265.55	265.69	264.55	265.4308	7971968.0
2018-04-05 10:00:00	SPY	ETF	265.4301	265.5995	264.81	265.07	6954802.0
2018-04-05 10:30:00	SPY	ETF	265.05	265.364	264.73	264.96	3869070.0
2018-04-05 11:00:00	SPY	ETF	264.97	266.47	264.97	266.336	6276738.0
2018-04-05 11:30:00	SPY	ETF	266.33	266.64	266.1	266.59	5382082.0
2018-04-05 12:00:00	SPY	ETF	266.59	266.64	265.67	265.91	4241220.0
2018-04-05 12:30:00	SPY	ETF	265.89	266.14	265.54	266.07	3516569.0
2018-04-05 13:00:00	SPY	ETF	266.06	266.39	264.87	265.06	4707998.0
2018-04-05 13:30:00	SPY	ETF	265.05	265.45	264.32	265.16	5090243.0
2018-04-05 14:00:00	SPY	ETF	265.17	265.55	264.83	265.17	4505429.0
2018-04-05 14:30:00	SPY	ETF	265.17	266.32	265.15	266.25	4699569.0
2018-04-05 15:00:00	SPY	ETF	266.2478	266.6	265.88	266.14	4449049.0
2018-04-05 15:30:00	SPY	ETF	266.15	266.38	265.23	265.65	11681897.0
2018-04-05 16:00:00	SPY	ETF	265.64	266.3	265.47	265.7	3178796.0
2018-04-05 16:30:00	SPY	ETF	265.7	265.79	256.25	265.62	1422439.0
2018-04-05 17:00:00	SPY	ETF	265.57	265.84	265.5	265.5	89959.0
2018-04-05 17:30:00	SPY	ETF	265.55	265.71	265.55	265.64	27948.0
2018-04-05 18:00:00	SPY	ETF	265.68	265.78	265.6	265.78	30857.0
2018-04-05 18:30:00	SPY	ETF	265.71	265.71	262.55	262.68	200379.0
2018-04-05 19:00:00	SPY	ETF	262.61	262.86	261.58	261.67	664598.0
2018-04-05 19:30:00	SPY	ETF	261.66	262.66	261.51	262.66	794626.0
2018-04-05 04:00:00	QQQ	ETF	161.27	161.4	161.09	161.09	20135.0
2018-04-05 04:30:00	QQQ	ETF	160.99	161.18	160.99	161.15	3634.0
2018-04-05 05:00:00	QQQ	ETF	161.0	161.02	160.85	160.9	12550.0
2018-04-05 05:30:00	QQQ	ETF	160.84	161.07	160.6	161.07	16780.0
2018-04-05 06:00:00	QQQ	ETF	161.04	161.04	160.79	160.9	9800.0
2018-04-05 06:30:00	QQQ	ETF	160.8	161.12	160.76	160.95	28367.0
2018-04-05 07:00:00	QQQ	ETF	160.95	161.44	160.94	161.38	81864.0
2018-04-05 07:30:00	QQQ	ETF	161.37	161.37	161.17	161.24	51300.0
2018-04-05 08:00:00	QQQ	ETF	161.33	161.69	160.94	161.31	167151.0
2018-04-05 08:30:00	QQQ	ETF	161.3	161.49	161.2	161.4	108745.0
2018-04-05 09:00:00	QQQ	ETF	161.39	161.48	161.19	161.32	157042.0
2018-04-05 09:30:00	QQQ	ETF	161.32	161.58	160.27	160.97	6160384.0
2018-04-05 10:00:00	QQQ	ETF	160.98	161.1	160.25	160.43	2934953.0
2018-04-05 10:30:00	QQQ	ETF	160.4095	160.809	160.22	160.6	2193509.0
2018-04-05 11:00:00	QQQ	ETF	160.61	161.405	160.61	161.22	2461206.0
2018-04-05 11:30:00	QQQ	ETF	161.225	161.52	161.07	161.39	1863314.0
2018-04-05 12:00:00	QQQ	ETF	161.39	161.41	160.51	160.73	1776786.0
2018-04-05 12:30:00	QQQ	ETF	160.7306	161.0	160.47	160.96	1518129.0

> showing 50 of 16,016 rows — these rows as CSV

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