PREVIEW / etf_30min / 2017-05-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-17.parquet
  size:    466 KB
  rows:    15,973

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-05-17 04:00:00	SPY	ETF	238.81	238.95	238.65	238.88	35984.0
2017-05-17 04:30:00	SPY	ETF	238.84	238.9	238.84	238.9	1300.0
2017-05-17 05:00:00	SPY	ETF	238.75	238.77	238.64	238.67	12340.0
2017-05-17 05:30:00	SPY	ETF	238.67	238.67	238.6	238.65	13500.0
2017-05-17 06:00:00	SPY	ETF	238.74	238.82	238.7	238.8	68542.0
2017-05-17 06:30:00	SPY	ETF	238.85	239.02	238.85	239.02	82646.0
2017-05-17 07:00:00	SPY	ETF	239.0	239.15	238.94	239.04	212648.0
2017-05-17 07:30:00	SPY	ETF	239.06	239.06	238.95	238.95	77756.0
2017-05-17 08:00:00	SPY	ETF	239.0	239.12	238.45	238.65	801259.0
2017-05-17 08:30:00	SPY	ETF	238.65	238.66	238.28	238.28	1349548.0
2017-05-17 09:00:00	SPY	ETF	238.28	238.3	237.86	238.11	1967215.0
2017-05-17 09:30:00	SPY	ETF	238.1	238.64	237.68	237.765	14396050.0
2017-05-17 10:00:00	SPY	ETF	237.76	237.97	237.5	237.61	16503184.0
2017-05-17 10:30:00	SPY	ETF	237.61	237.82	236.96	237.045	10654735.0
2017-05-17 11:00:00	SPY	ETF	237.05	237.63	236.91	237.5	11894986.0
2017-05-17 11:30:00	SPY	ETF	237.5025	237.76	237.3	237.73	8516106.0
2017-05-17 12:00:00	SPY	ETF	237.74	237.74	237.34	237.34	4505861.0
2017-05-17 12:30:00	SPY	ETF	237.34	237.67	237.23	237.65	5573634.0
2017-05-17 13:00:00	SPY	ETF	237.65	237.65	237.2	237.32	4114759.0
2017-05-17 13:30:00	SPY	ETF	237.33	237.37	236.86	236.975	6902642.0
2017-05-17 14:00:00	SPY	ETF	236.97	237.22	236.46	236.51	10509308.0
2017-05-17 14:30:00	SPY	ETF	236.51	236.71	236.07	236.52	14528127.0
2017-05-17 15:00:00	SPY	ETF	236.525	236.91	236.29	236.52	10503799.0
2017-05-17 15:30:00	SPY	ETF	236.53	236.82	235.75	235.85	23124218.0
2017-05-17 16:00:00	SPY	ETF	235.85	237.457	235.82	236.04	21085181.0
2017-05-17 16:30:00	SPY	ETF	236.04	236.08	235.82	235.93	858799.0
2017-05-17 17:00:00	SPY	ETF	235.94	236.0	235.88	235.92	408568.0
2017-05-17 17:30:00	SPY	ETF	235.92	238.6	235.78	235.78	227600.0
2017-05-17 18:00:00	SPY	ETF	235.78	236.14	235.75	236.04	436642.0
2017-05-17 18:30:00	SPY	ETF	236.06	236.3	235.92	236.24	60324.0
2017-05-17 19:00:00	SPY	ETF	236.25	236.37	236.2	236.37	49444.0
2017-05-17 19:30:00	SPY	ETF	236.34	236.38	236.25	236.34	37808.0
2017-05-17 04:00:00	QQQ	ETF	139.01	139.14	139.01	139.14	5250.0
2017-05-17 04:30:00	QQQ	ETF	139.1	139.1	139.08	139.08	300.0
2017-05-17 05:00:00	QQQ	ETF	139.02	139.02	139.02	139.02	500.0
2017-05-17 05:30:00	QQQ	ETF	139.01	139.01	138.94	138.97	6500.0
2017-05-17 06:00:00	QQQ	ETF	139.05	139.1	139.05	139.05	25950.0
2017-05-17 06:30:00	QQQ	ETF	139.1	139.15	139.09	139.13	27600.0
2017-05-17 07:00:00	QQQ	ETF	139.14	139.21	139.13	139.18	20150.0
2017-05-17 07:30:00	QQQ	ETF	139.13	139.13	139.06	139.06	43530.0
2017-05-17 08:00:00	QQQ	ETF	139.05	139.2	138.68	138.78	174948.0
2017-05-17 08:30:00	QQQ	ETF	138.78	138.83	138.66	138.66	206919.0
2017-05-17 09:00:00	QQQ	ETF	138.65	138.65	138.4	138.53	544528.0
2017-05-17 09:30:00	QQQ	ETF	138.55	138.77	138.09	138.13	5923556.0
2017-05-17 10:00:00	QQQ	ETF	138.12	138.2	137.82	137.99	5246583.0
2017-05-17 10:30:00	QQQ	ETF	137.98	138.05	137.18	137.25	4266685.0
2017-05-17 11:00:00	QQQ	ETF	137.26	137.55	137.03	137.4	3553801.0
2017-05-17 11:30:00	QQQ	ETF	137.4	137.68	137.2849	137.66	1764497.0
2017-05-17 12:00:00	QQQ	ETF	137.655	137.655	137.4	137.4	981479.0
2017-05-17 12:30:00	QQQ	ETF	137.405	137.66	137.34	137.64	961487.0

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

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