PREVIEW / etf_30min / 2019-02-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-19.parquet
  size:    506 KB
  rows:    17,798

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-02-19 04:00:00	SPY	ETF	277.56	277.56	276.97	277.06	19914.0
2019-02-19 04:30:00	SPY	ETF	277.05	277.12	276.98	277.02	4864.0
2019-02-19 05:00:00	SPY	ETF	277.03	277.14	277.03	277.07	4783.0
2019-02-19 05:30:00	SPY	ETF	277.1	277.22	277.06	277.13	5730.0
2019-02-19 06:00:00	SPY	ETF	277.12	277.14	276.64	276.65	33418.0
2019-02-19 06:30:00	SPY	ETF	276.68	276.75	276.56	276.75	33090.0
2019-02-19 07:00:00	SPY	ETF	276.7	276.83	276.57	276.68	178105.0
2019-02-19 07:30:00	SPY	ETF	276.68	277.0	276.67	276.85	103101.0
2019-02-19 08:00:00	SPY	ETF	276.6501	277.58	276.65	276.79	161505.0
2019-02-19 08:30:00	SPY	ETF	276.82	276.84	276.59	276.75	165788.0
2019-02-19 09:00:00	SPY	ETF	276.74	276.75	276.49	276.49	268816.0
2019-02-19 09:30:00	SPY	ETF	276.4813	277.38	276.47	277.32	5688044.0
2019-02-19 10:00:00	SPY	ETF	277.325	277.63	277.24	277.53	3372810.0
2019-02-19 10:30:00	SPY	ETF	277.52	277.55	277.05	277.21	4327567.0
2019-02-19 11:00:00	SPY	ETF	277.205	277.58	277.205	277.33	2271329.0
2019-02-19 11:30:00	SPY	ETF	277.33	278.24	277.3	278.22	4794077.0
2019-02-19 12:00:00	SPY	ETF	278.23	278.24	277.96	278.08	1841337.0
2019-02-19 12:30:00	SPY	ETF	278.08	278.1	277.9	277.9979	1641821.0
2019-02-19 13:00:00	SPY	ETF	277.9987	278.03	277.79	277.9	1873718.0
2019-02-19 13:30:00	SPY	ETF	277.9	277.97	277.74	277.95	2205446.0
2019-02-19 14:00:00	SPY	ETF	277.95	278.27	277.925	278.23	2817135.0
2019-02-19 14:30:00	SPY	ETF	278.23	278.58	278.23	278.53	3962192.0
2019-02-19 15:00:00	SPY	ETF	278.535	278.57	278.18	278.26	3323133.0
2019-02-19 15:30:00	SPY	ETF	278.26	278.48	277.71	277.85	13380528.0
2019-02-19 16:00:00	SPY	ETF	277.84	277.9	277.47	277.69	5491386.0
2019-02-19 16:30:00	SPY	ETF	277.67	277.85	277.61	277.65	174880.0
2019-02-19 17:00:00	SPY	ETF	277.67	277.7	277.58	277.6	50754.0
2019-02-19 17:30:00	SPY	ETF	277.6	277.6	277.55	277.6	52915.0
2019-02-19 18:00:00	SPY	ETF	277.6	277.73	277.5	277.68	186261.0
2019-02-19 18:30:00	SPY	ETF	277.69	277.74	277.65	277.69	25239.0
2019-02-19 19:00:00	SPY	ETF	277.69	277.77	277.61	277.65	30830.0
2019-02-19 19:30:00	SPY	ETF	277.65	277.75	277.55	277.72	29011.0
2019-02-19 04:00:00	QQQ	ETF	172.22	172.3	171.86	171.98	7208.0
2019-02-19 04:30:00	QQQ	ETF	171.94	171.94	171.87	171.87	9200.0
2019-02-19 05:00:00	QQQ	ETF	171.97	171.97	171.91	171.92	1845.0
2019-02-19 05:30:00	QQQ	ETF	171.94	172.0	171.89	171.97	2200.0
2019-02-19 06:00:00	QQQ	ETF	171.94	171.94	171.51	171.51	4850.0
2019-02-19 06:30:00	QQQ	ETF	171.61	171.62	171.48	171.58	30580.0
2019-02-19 07:00:00	QQQ	ETF	171.6	171.65	171.5	171.65	38541.0
2019-02-19 07:30:00	QQQ	ETF	171.59	171.73	171.56	171.64	27797.0
2019-02-19 08:00:00	QQQ	ETF	171.55	172.34	171.51	171.58	31163.0
2019-02-19 08:30:00	QQQ	ETF	171.6201	171.63	171.47	171.56	68072.0
2019-02-19 09:00:00	QQQ	ETF	171.52	171.6	171.4	171.4	67938.0
2019-02-19 09:30:00	QQQ	ETF	171.39	172.23	171.38	172.16	2281368.0
2019-02-19 10:00:00	QQQ	ETF	172.16	172.4	172.09	172.32	1268000.0
2019-02-19 10:30:00	QQQ	ETF	172.34	172.35	172.04	172.17	790128.0
2019-02-19 11:00:00	QQQ	ETF	172.18	172.34	172.07	172.1	869287.0
2019-02-19 11:30:00	QQQ	ETF	172.1	172.71	172.0801	172.7	1743047.0
2019-02-19 12:00:00	QQQ	ETF	172.71	172.72	172.505	172.61	708525.0
2019-02-19 12:30:00	QQQ	ETF	172.605	172.61	172.42	172.45	548160.0

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

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