PREVIEW / etf_30min / 2019-02-21

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-21.parquet
  size:    489 KB
  rows:    17,132

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-21 04:00:00	SPY	ETF	278.89	278.93	278.73	278.78	4173.0
2019-02-21 04:30:00	SPY	ETF	278.9	278.93	278.78	278.78	775.0
2019-02-21 05:00:00	SPY	ETF	278.85	278.97	278.75	278.75	4525.0
2019-02-21 05:30:00	SPY	ETF	278.76	278.85	278.75	278.85	1200.0
2019-02-21 06:00:00	SPY	ETF	278.87	278.97	278.87	278.9	2820.0
2019-02-21 06:30:00	SPY	ETF	278.85	278.85	278.65	278.7	5006.0
2019-02-21 07:00:00	SPY	ETF	278.75	278.81	278.26	278.3	69555.0
2019-02-21 07:30:00	SPY	ETF	278.33	278.34	277.92	278.21	94400.0
2019-02-21 08:00:00	SPY	ETF	278.7	279.5	277.98	278.21	82231.0
2019-02-21 08:30:00	SPY	ETF	278.19	278.26	277.75	278.1	265235.0
2019-02-21 09:00:00	SPY	ETF	278.1	278.24	277.68	277.73	364678.0
2019-02-21 09:30:00	SPY	ETF	277.7	277.98	276.95	277.3	8560048.0
2019-02-21 10:00:00	SPY	ETF	277.3	277.5	276.85	276.98	5360522.0
2019-02-21 10:30:00	SPY	ETF	276.99	277.44	276.97	277.17	3162171.0
2019-02-21 11:00:00	SPY	ETF	277.17	277.67	276.99	277.2	3191075.0
2019-02-21 11:30:00	SPY	ETF	277.2	277.91	277.12	277.72	2415728.0
2019-02-21 12:00:00	SPY	ETF	277.73	277.89	277.56	277.74	2044566.0
2019-02-21 12:30:00	SPY	ETF	277.74	278.05	277.74	278.0337	2460290.0
2019-02-21 13:00:00	SPY	ETF	278.0385	278.1	277.695	277.74	1881152.0
2019-02-21 13:30:00	SPY	ETF	277.75	277.78	277.58	277.75	1597241.0
2019-02-21 14:00:00	SPY	ETF	277.7401	277.8	276.88	277.1251	2960290.0
2019-02-21 14:30:00	SPY	ETF	277.12	277.18	276.37	276.61	4963988.0
2019-02-21 15:00:00	SPY	ETF	276.6125	276.96	276.52	276.72	4297428.0
2019-02-21 15:30:00	SPY	ETF	276.71	277.47	276.345	277.46	11271815.0
2019-02-21 16:00:00	SPY	ETF	277.47	277.57	277.34	277.44	8084008.0
2019-02-21 16:30:00	SPY	ETF	277.44	277.44	277.3	277.35	250204.0
2019-02-21 17:00:00	SPY	ETF	277.3	277.38	277.29	277.35	32265.0
2019-02-21 17:30:00	SPY	ETF	277.36	277.36	277.27	277.28	14843.0
2019-02-21 18:00:00	SPY	ETF	277.27	277.33	277.14	277.15	72436.0
2019-02-21 18:30:00	SPY	ETF	277.2	277.4	277.15	277.38	38602.0
2019-02-21 19:00:00	SPY	ETF	277.38	277.4	277.18	277.29	63323.0
2019-02-21 19:30:00	SPY	ETF	277.34	277.47	277.3	277.47	43876.0
2019-02-21 04:00:00	QQQ	ETF	172.63	172.66	172.55	172.63	5200.0
2019-02-21 04:30:00	QQQ	ETF	172.65	172.69	172.59	172.6	3400.0
2019-02-21 05:00:00	QQQ	ETF	172.71	172.77	172.68	172.68	2800.0
2019-02-21 05:30:00	QQQ	ETF	172.61	172.74	172.61	172.74	11200.0
2019-02-21 06:00:00	QQQ	ETF	172.69	172.84	172.69	172.78	11500.0
2019-02-21 06:30:00	QQQ	ETF	172.73	172.74	172.6	172.6	2100.0
2019-02-21 07:00:00	QQQ	ETF	172.63	172.71	172.22	172.28	50413.0
2019-02-21 07:30:00	QQQ	ETF	172.31	172.32	172.01	172.21	35824.0
2019-02-21 08:00:00	QQQ	ETF	172.61	173.16	172.1	172.25	54404.0
2019-02-21 08:30:00	QQQ	ETF	172.12	172.15	171.81	172.05	108539.0
2019-02-21 09:00:00	QQQ	ETF	172.06	172.17	171.75	171.78	105685.0
2019-02-21 09:30:00	QQQ	ETF	171.78	172.18	170.89	171.14	3590452.0
2019-02-21 10:00:00	QQQ	ETF	171.14	171.17	170.71	170.87	2700373.0
2019-02-21 10:30:00	QQQ	ETF	170.87	171.31	170.87	171.15	1371854.0
2019-02-21 11:00:00	QQQ	ETF	171.14	171.659	170.99	171.3921	1731561.0
2019-02-21 11:30:00	QQQ	ETF	171.41	171.981	171.3415	171.86	1328937.0
2019-02-21 12:00:00	QQQ	ETF	171.8662	172.081	171.82	172.06	1396510.0
2019-02-21 12:30:00	QQQ	ETF	172.065	172.26	172.01	172.21	1295367.0

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

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