PREVIEW / etf_30min / 2019-02-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-22.parquet
  size:    495 KB
  rows:    17,300

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-22 04:00:00	SPY	ETF	278.02	278.35	278.02	278.14	8575.0
2019-02-22 04:30:00	SPY	ETF	278.13	278.24	278.08	278.2	9495.0
2019-02-22 05:00:00	SPY	ETF	278.13	278.26	278.13	278.2	7627.0
2019-02-22 05:30:00	SPY	ETF	278.3	278.52	278.26	278.41	10231.0
2019-02-22 06:00:00	SPY	ETF	278.49	278.54	278.38	278.47	3780.0
2019-02-22 06:30:00	SPY	ETF	278.44	278.64	278.4	278.5	24166.0
2019-02-22 07:00:00	SPY	ETF	278.57	278.65	278.46	278.46	53076.0
2019-02-22 07:30:00	SPY	ETF	278.46	278.51	278.4	278.45	50313.0
2019-02-22 08:00:00	SPY	ETF	278.46	278.61	277.39	278.35	96180.0
2019-02-22 08:30:00	SPY	ETF	278.39	278.42	278.0	278.07	321460.0
2019-02-22 09:00:00	SPY	ETF	278.07	278.34	278.05	278.13	179380.0
2019-02-22 09:30:00	SPY	ETF	278.11	278.47	277.82	278.47	6231877.0
2019-02-22 10:00:00	SPY	ETF	278.46	278.64	278.29	278.415	3786407.0
2019-02-22 10:30:00	SPY	ETF	278.41	278.84	278.25	278.7367	4942131.0
2019-02-22 11:00:00	SPY	ETF	278.74	279.25	278.6	279.15	4937395.0
2019-02-22 11:30:00	SPY	ETF	279.14	279.27	278.935	279.1	2733077.0
2019-02-22 12:00:00	SPY	ETF	279.1	279.36	278.93	278.9701	3541206.0
2019-02-22 12:30:00	SPY	ETF	278.98	279.04	278.85	278.9717	3192365.0
2019-02-22 13:00:00	SPY	ETF	278.98	279.0	278.62	278.8621	3787096.0
2019-02-22 13:30:00	SPY	ETF	278.863	278.98	278.74	278.8917	2603346.0
2019-02-22 14:00:00	SPY	ETF	278.9	279.14	278.71	278.75	4962566.0
2019-02-22 14:30:00	SPY	ETF	278.75	278.82	278.04	278.22	8340391.0
2019-02-22 15:00:00	SPY	ETF	278.21	278.95	278.12	278.8717	3513336.0
2019-02-22 15:30:00	SPY	ETF	278.88	279.22	278.59	279.15	14149352.0
2019-02-22 16:00:00	SPY	ETF	279.15	279.2589	278.87	279.07	5134562.0
2019-02-22 16:30:00	SPY	ETF	279.09	279.41	279.09	279.41	1794064.0
2019-02-22 17:00:00	SPY	ETF	279.39	279.41	279.14	279.34	469692.0
2019-02-22 17:30:00	SPY	ETF	279.34	279.34	279.04	279.34	945690.0
2019-02-22 18:00:00	SPY	ETF	279.34	279.34	279.29	279.29	15231.0
2019-02-22 18:30:00	SPY	ETF	279.32	279.35	279.31	279.35	2246.0
2019-02-22 19:00:00	SPY	ETF	279.32	279.38	279.32	279.38	4029.0
2019-02-22 19:30:00	SPY	ETF	279.35	279.4	279.34	279.37	21574.0
2019-02-22 04:00:00	QQQ	ETF	171.93	172.13	171.93	172.08	4600.0
2019-02-22 04:30:00	QQQ	ETF	172.0	172.08	171.99	172.04	10270.0
2019-02-22 05:00:00	QQQ	ETF	172.01	172.09	172.01	172.06	6350.0
2019-02-22 05:30:00	QQQ	ETF	172.11	172.36	172.07	172.3	16151.0
2019-02-22 06:00:00	QQQ	ETF	172.29	172.35	172.23	172.27	9850.0
2019-02-22 06:30:00	QQQ	ETF	172.32	172.42	172.28	172.41	23700.0
2019-02-22 07:00:00	QQQ	ETF	172.4	172.49	172.36	172.37	57378.0
2019-02-22 07:30:00	QQQ	ETF	172.35	172.4	172.26	172.28	47410.0
2019-02-22 08:00:00	QQQ	ETF	172.34	172.44	171.62	172.18	68409.0
2019-02-22 08:30:00	QQQ	ETF	172.18	172.19	171.82	171.95	375204.0
2019-02-22 09:00:00	QQQ	ETF	171.94	172.16	171.92	171.99	199304.0
2019-02-22 09:30:00	QQQ	ETF	171.98	172.4499	171.9	172.445	2808413.0
2019-02-22 10:00:00	QQQ	ETF	172.43	172.6	172.11	172.28	2705175.0
2019-02-22 10:30:00	QQQ	ETF	172.28	172.73	172.15	172.64	2043251.0
2019-02-22 11:00:00	QQQ	ETF	172.65	172.96	172.53	172.91	1591250.0
2019-02-22 11:30:00	QQQ	ETF	172.91	173.01	172.73	172.86	1372140.0
2019-02-22 12:00:00	QQQ	ETF	172.85	173.0	172.63	172.72	1837208.0
2019-02-22 12:30:00	QQQ	ETF	172.725	172.7899	172.64	172.715	729883.0

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

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