PREVIEW / etf_30min / 2019-11-05

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-05.parquet
  size:    522 KB
  rows:    18,356

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-11-05 04:00:00	SPY	ETF	307.86	308.05	307.86	308.02	9671.0
2019-11-05 04:30:00	SPY	ETF	308.03	308.1	307.93	307.93	52708.0
2019-11-05 05:00:00	SPY	ETF	308.04	308.18	308.04	308.13	8110.0
2019-11-05 05:30:00	SPY	ETF	308.09	308.21	308.09	308.12	10525.0
2019-11-05 06:00:00	SPY	ETF	308.13	308.13	307.86	307.94	10071.0
2019-11-05 06:30:00	SPY	ETF	307.89	307.9	307.75	307.86	47420.0
2019-11-05 07:00:00	SPY	ETF	307.82	308.04	307.8	307.91	67629.0
2019-11-05 07:30:00	SPY	ETF	307.93	308.04	307.89	307.92	34534.0
2019-11-05 08:00:00	SPY	ETF	307.9899	308.01	307.79	307.88	74594.0
2019-11-05 08:30:00	SPY	ETF	307.9	308.09	307.37	308.05	364286.0
2019-11-05 09:00:00	SPY	ETF	308.04	308.13	307.48	307.58	260640.0
2019-11-05 09:30:00	SPY	ETF	307.59	307.67	307.2096	307.38	3861830.0
2019-11-05 10:00:00	SPY	ETF	307.46	307.9195	306.82	306.92	4877029.0
2019-11-05 10:30:00	SPY	ETF	306.91	307.135	306.71	306.91	2591058.0
2019-11-05 11:00:00	SPY	ETF	306.93	307.32	306.91	307.1246	2413043.0
2019-11-05 11:30:00	SPY	ETF	307.1293	307.26	306.83	307.01	1689374.0
2019-11-05 12:00:00	SPY	ETF	307.02	307.1687	306.72	306.81	2382305.0
2019-11-05 12:30:00	SPY	ETF	306.805	307.3	306.73	307.295	2487295.0
2019-11-05 13:00:00	SPY	ETF	307.29	307.42	307.18	307.2801	1729701.0
2019-11-05 13:30:00	SPY	ETF	307.28	307.42	307.17	307.31	1333463.0
2019-11-05 14:00:00	SPY	ETF	307.315	307.5	307.24	307.41	1045386.0
2019-11-05 14:30:00	SPY	ETF	307.41	307.5	307.27	307.38	1165720.0
2019-11-05 15:00:00	SPY	ETF	307.385	307.41	307.16	307.18	3748598.0
2019-11-05 15:30:00	SPY	ETF	307.17	307.39	306.836	307.0	8352766.0
2019-11-05 16:00:00	SPY	ETF	307.0	307.06	306.84	306.88	2555458.0
2019-11-05 16:30:00	SPY	ETF	306.87	307.03	306.81	306.87	325758.0
2019-11-05 17:00:00	SPY	ETF	306.87	307.03	306.78	306.78	302165.0
2019-11-05 17:30:00	SPY	ETF	306.78	307.03	306.74	306.83	85361.0
2019-11-05 18:00:00	SPY	ETF	306.84	306.9	306.78	306.81	59204.0
2019-11-05 18:30:00	SPY	ETF	306.82	306.97	306.82	306.88	13043.0
2019-11-05 19:00:00	SPY	ETF	306.89	306.95	306.73	306.73	22379.0
2019-11-05 19:30:00	SPY	ETF	306.75	306.8	306.57	306.57	23375.0
2019-11-05 04:00:00	QQQ	ETF	200.68	200.74	200.65	200.74	7500.0
2019-11-05 04:30:00	QQQ	ETF	200.73	200.78	200.7	200.7	11000.0
2019-11-05 05:00:00	QQQ	ETF	200.77	200.89	200.77	200.84	8605.0
2019-11-05 05:30:00	QQQ	ETF	200.84	200.88	200.83	200.83	7708.0
2019-11-05 06:00:00	QQQ	ETF	200.83	200.83	200.63	200.66	2905.0
2019-11-05 06:30:00	QQQ	ETF	200.62	200.66	200.52	200.65	6300.0
2019-11-05 07:00:00	QQQ	ETF	200.6	200.73	200.6	200.64	14123.0
2019-11-05 07:30:00	QQQ	ETF	200.65	200.68	200.58	200.61	26399.0
2019-11-05 08:00:00	QQQ	ETF	200.67	200.6998	200.52	200.59	30601.0
2019-11-05 08:30:00	QQQ	ETF	200.57	200.69	200.57	200.64	38985.0
2019-11-05 09:00:00	QQQ	ETF	200.66	200.72	200.31	200.33	123805.0
2019-11-05 09:30:00	QQQ	ETF	200.35	200.47	199.94	200.17	1876514.0
2019-11-05 10:00:00	QQQ	ETF	200.18	200.55	199.55	199.83	2184587.0
2019-11-05 10:30:00	QQQ	ETF	199.835	200.1	199.74	199.91	941908.0
2019-11-05 11:00:00	QQQ	ETF	199.93	200.356	199.925	200.24	1029060.0
2019-11-05 11:30:00	QQQ	ETF	200.24	200.35	200.0835	200.29	614249.0
2019-11-05 12:00:00	QQQ	ETF	200.2701	200.465	200.16	200.2762	508362.0
2019-11-05 12:30:00	QQQ	ETF	200.26	200.455	200.17	200.41	541891.0

> showing 50 of 18,356 rows — these rows as CSV

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