PREVIEW / etf_30min / 2019-04-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-23.parquet
  size:    506 KB
  rows:    17,628

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-04-23 04:00:00	SPY	ETF	290.22	290.42	290.21	290.39	3134.0
2019-04-23 04:30:00	SPY	ETF	290.37	290.38	290.32	290.36	3510.0
2019-04-23 05:00:00	SPY	ETF	290.28	290.28	290.23	290.23	2570.0
2019-04-23 05:30:00	SPY	ETF	290.16	290.21	290.14	290.15	3530.0
2019-04-23 06:00:00	SPY	ETF	290.19	290.21	290.19	290.19	2900.0
2019-04-23 06:30:00	SPY	ETF	290.17	290.2	290.17	290.2	4925.0
2019-04-23 07:00:00	SPY	ETF	290.22	290.3	290.21	290.25	27368.0
2019-04-23 07:30:00	SPY	ETF	290.27	290.64	290.25	290.57	41730.0
2019-04-23 08:00:00	SPY	ETF	290.25	290.86	290.21	290.81	143394.0
2019-04-23 08:30:00	SPY	ETF	290.79	290.8	290.53	290.55	202484.0
2019-04-23 09:00:00	SPY	ETF	290.56	290.7899	290.46	290.69	359566.0
2019-04-23 09:30:00	SPY	ETF	290.68	291.08	290.42	291.03	4531795.0
2019-04-23 10:00:00	SPY	ETF	291.035	291.51	291.03	291.5	4898441.0
2019-04-23 10:30:00	SPY	ETF	291.51	291.63	291.25	291.57	2793441.0
2019-04-23 11:00:00	SPY	ETF	291.565	292.36	291.56	292.3	5276934.0
2019-04-23 11:30:00	SPY	ETF	292.29	292.66	292.26	292.63	5625165.0
2019-04-23 12:00:00	SPY	ETF	292.62	293.14	292.61	292.85	3718311.0
2019-04-23 12:30:00	SPY	ETF	292.84	292.88	292.72	292.83	1584078.0
2019-04-23 13:00:00	SPY	ETF	292.83	292.9685	292.7706	292.7706	1802485.0
2019-04-23 13:30:00	SPY	ETF	292.78	292.84	292.73	292.76	2102786.0
2019-04-23 14:00:00	SPY	ETF	292.76	292.94	292.62	292.8768	2006892.0
2019-04-23 14:30:00	SPY	ETF	292.875	293.0	292.83	292.92	1443984.0
2019-04-23 15:00:00	SPY	ETF	292.91	292.95	292.74	292.78	2662221.0
2019-04-23 15:30:00	SPY	ETF	292.78	292.98	292.56	292.85	8161845.0
2019-04-23 16:00:00	SPY	ETF	292.86	293.09	292.8465	293.07	3152231.0
2019-04-23 16:30:00	SPY	ETF	293.07	293.16	292.96	292.98	216583.0
2019-04-23 17:00:00	SPY	ETF	293.08	293.08	292.88	292.98	45012.0
2019-04-23 17:30:00	SPY	ETF	292.98	292.98	292.88	292.97	36937.0
2019-04-23 18:00:00	SPY	ETF	292.97	293.02	292.91	292.98	20892.0
2019-04-23 18:30:00	SPY	ETF	292.98	293.03	292.91	293.02	31687.0
2019-04-23 19:00:00	SPY	ETF	293.02	293.08	293.0	293.08	4737.0
2019-04-23 19:30:00	SPY	ETF	293.09	293.13	293.08	293.13	23755.0
2019-04-23 04:00:00	QQQ	ETF	187.85	188.05	187.85	187.98	6749.0
2019-04-23 04:30:00	QQQ	ETF	187.97	187.97	187.91	187.91	3400.0
2019-04-23 05:00:00	QQQ	ETF	187.89	187.92	187.89	187.92	600.0
2019-04-23 05:30:00	QQQ	ETF	187.88	187.89	187.82	187.87	15694.0
2019-04-23 06:00:00	QQQ	ETF	187.83	187.92	187.82	187.88	8400.0
2019-04-23 06:30:00	QQQ	ETF	187.88	187.88	187.76	187.81	10113.0
2019-04-23 07:00:00	QQQ	ETF	187.82	187.92	187.77	187.87	51816.0
2019-04-23 07:30:00	QQQ	ETF	187.86	188.13	187.84	188.13	41312.0
2019-04-23 08:00:00	QQQ	ETF	187.85	188.34	187.8	188.29	103365.0
2019-04-23 08:30:00	QQQ	ETF	188.31	188.31	188.13	188.18	50047.0
2019-04-23 09:00:00	QQQ	ETF	188.17	188.44	188.09	188.36	118799.0
2019-04-23 09:30:00	QQQ	ETF	188.37	189.16	188.13	189.045	3149591.0
2019-04-23 10:00:00	QQQ	ETF	189.05	189.44	189.02	189.41	1907364.0
2019-04-23 10:30:00	QQQ	ETF	189.41	189.4395	189.05	189.215	3621958.0
2019-04-23 11:00:00	QQQ	ETF	189.22	189.8285	189.07	189.7766	1961517.0
2019-04-23 11:30:00	QQQ	ETF	189.77	190.02	189.74	189.99	1674425.0
2019-04-23 12:00:00	QQQ	ETF	190.0	190.29	189.93	190.07	2586623.0
2019-04-23 12:30:00	QQQ	ETF	190.07	190.2285	189.95	190.185	780683.0

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

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