PREVIEW / etf_30min / 2019-06-28

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-28.parquet
  size:    497 KB
  rows:    17,485

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
2019-06-28 04:00:00	SPY	ETF	292.37	292.59	292.35	292.56	8119.0
2019-06-28 04:30:00	SPY	ETF	292.59	292.68	292.53	292.53	3964.0
2019-06-28 05:00:00	SPY	ETF	292.58	292.66	292.5	292.58	10455.0
2019-06-28 05:30:00	SPY	ETF	292.6	292.73	292.53	292.63	14505.0
2019-06-28 06:00:00	SPY	ETF	292.63	292.63	292.51	292.51	9275.0
2019-06-28 06:30:00	SPY	ETF	292.51	292.53	292.4	292.4	9794.0
2019-06-28 07:00:00	SPY	ETF	292.49	292.49	292.37	292.37	63142.0
2019-06-28 07:30:00	SPY	ETF	292.36	292.47	292.32	292.45	13227.0
2019-06-28 08:00:00	SPY	ETF	292.5	292.62	292.05	292.53	129457.0
2019-06-28 08:30:00	SPY	ETF	292.52	292.67	292.47	292.62	139621.0
2019-06-28 09:00:00	SPY	ETF	292.62	292.63	292.5	292.58	137178.0
2019-06-28 09:30:00	SPY	ETF	292.58	292.83	292.01	292.215	4669882.0
2019-06-28 10:00:00	SPY	ETF	292.215	292.38	292.0702	292.1351	3350363.0
2019-06-28 10:30:00	SPY	ETF	292.135	292.46	292.04	292.32	2171106.0
2019-06-28 11:00:00	SPY	ETF	292.31	292.54	292.07	292.39	2008452.0
2019-06-28 11:30:00	SPY	ETF	292.385	292.7	292.3548	292.5426	1909223.0
2019-06-28 12:00:00	SPY	ETF	292.54	293.19	292.54	293.06	2947842.0
2019-06-28 12:30:00	SPY	ETF	293.06	293.14	292.95	293.0	2713570.0
2019-06-28 13:00:00	SPY	ETF	292.995	293.0	292.68	292.755	1550320.0
2019-06-28 13:30:00	SPY	ETF	292.7552	292.87	292.46	292.555	1464922.0
2019-06-28 14:00:00	SPY	ETF	292.55	292.69	292.48	292.58	2259375.0
2019-06-28 14:30:00	SPY	ETF	292.58	292.69	292.28	292.33	3028833.0
2019-06-28 15:00:00	SPY	ETF	292.33	292.51	292.27	292.3	3361271.0
2019-06-28 15:30:00	SPY	ETF	292.3	293.55	292.23	293.08	14535295.0
2019-06-28 16:00:00	SPY	ETF	293.07	294.25	292.95	293.97	7999141.0
2019-06-28 16:30:00	SPY	ETF	293.94	294.17	293.85	294.02	738277.0
2019-06-28 17:00:00	SPY	ETF	294.0	294.14	293.0	293.98	319277.0
2019-06-28 17:30:00	SPY	ETF	294.02	294.35	293.0	294.35	841361.0
2019-06-28 18:00:00	SPY	ETF	294.3	294.44	294.25	294.35	30791.0
2019-06-28 18:30:00	SPY	ETF	294.34	294.7	294.25	294.31	468296.0
2019-06-28 19:00:00	SPY	ETF	294.33	294.38	294.3	294.35	28700.0
2019-06-28 19:30:00	SPY	ETF	294.33	294.5	294.31	294.47	46428.0
2019-06-28 04:30:00	QQQ	ETF	187.0	187.0	186.96	186.96	3100.0
2019-06-28 05:00:00	QQQ	ETF	186.96	186.96	186.91	186.91	1100.0
2019-06-28 05:30:00	QQQ	ETF	186.9	187.02	186.89	187.02	8970.0
2019-06-28 06:00:00	QQQ	ETF	186.95	186.95	186.86	186.86	1400.0
2019-06-28 06:30:00	QQQ	ETF	186.82	186.82	186.76	186.76	2545.0
2019-06-28 07:00:00	QQQ	ETF	186.78	186.83	186.73	186.73	14330.0
2019-06-28 07:30:00	QQQ	ETF	186.7	186.83	186.67	186.81	11270.0
2019-06-28 08:00:00	QQQ	ETF	186.79	186.9	186.46	186.86	21012.0
2019-06-28 08:30:00	QQQ	ETF	186.79	187.0	186.79	186.94	35541.0
2019-06-28 09:00:00	QQQ	ETF	186.918	186.97	186.85	186.96	60164.0
2019-06-28 09:30:00	QQQ	ETF	186.95	187.15	186.07	186.2333	2424215.0
2019-06-28 10:00:00	QQQ	ETF	186.23	186.47	186.07	186.34	1030048.0
2019-06-28 10:30:00	QQQ	ETF	186.34	186.55	186.16	186.48	1120722.0
2019-06-28 11:00:00	QQQ	ETF	186.47	186.65	186.26	186.545	768474.0
2019-06-28 11:30:00	QQQ	ETF	186.545	186.72	186.5035	186.6599	709925.0
2019-06-28 12:00:00	QQQ	ETF	186.65	187.12	186.64	187.015	1102006.0
2019-06-28 12:30:00	QQQ	ETF	187.017	187.096	186.9115	186.99	947792.0
2019-06-28 13:00:00	QQQ	ETF	186.995	187.0	186.57	186.58	628999.0

> showing 50 of 17,485 rows — these rows as CSV

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