PREVIEW / etf_30min / 2019-06-20

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-20.parquet
  size:    524 KB
  rows:    18,579

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-06-20 04:00:00	SPY	ETF	295.02	295.31	295.02	295.3	26700.0
2019-06-20 04:30:00	SPY	ETF	295.34	295.68	295.34	295.59	11061.0
2019-06-20 05:00:00	SPY	ETF	295.61	295.89	295.61	295.89	7001.0
2019-06-20 05:30:00	SPY	ETF	295.86	295.99	295.86	295.94	12740.0
2019-06-20 06:00:00	SPY	ETF	295.94	295.94	295.85	295.86	18403.0
2019-06-20 06:30:00	SPY	ETF	295.86	295.86	295.7	295.7	78765.0
2019-06-20 07:00:00	SPY	ETF	295.67	295.91	295.66	295.88	63318.0
2019-06-20 07:30:00	SPY	ETF	295.9	296.18	295.9	296.05	364727.0
2019-06-20 08:00:00	SPY	ETF	295.96	296.21	294.47	296.1801	411104.0
2019-06-20 08:30:00	SPY	ETF	296.19	296.44	296.15	296.21	473180.0
2019-06-20 09:00:00	SPY	ETF	296.22	296.35	296.0	296.04	863490.0
2019-06-20 09:30:00	SPY	ETF	296.04	296.17	295.62	295.84	10372178.0
2019-06-20 10:00:00	SPY	ETF	295.85	296.11	293.1255	295.37	10170721.0
2019-06-20 10:30:00	SPY	ETF	295.385	295.48	294.9716	294.99	6962864.0
2019-06-20 11:00:00	SPY	ETF	294.99	295.28	294.65	294.72	4614733.0
2019-06-20 11:30:00	SPY	ETF	294.725	295.14	294.59	294.97	4794261.0
2019-06-20 12:00:00	SPY	ETF	295.0	295.02	293.61	294.4865	5805886.0
2019-06-20 12:30:00	SPY	ETF	294.48	294.75	294.23	294.65	3481581.0
2019-06-20 13:00:00	SPY	ETF	294.65	295.23	294.57	295.21	2496952.0
2019-06-20 13:30:00	SPY	ETF	295.22	295.27	294.91	295.0	2845593.0
2019-06-20 14:00:00	SPY	ETF	295.0	295.36	294.91	295.225	5325274.0
2019-06-20 14:30:00	SPY	ETF	295.2317	295.57	295.1999	295.5	3199892.0
2019-06-20 15:00:00	SPY	ETF	295.51	295.73	295.22	295.67	7313274.0
2019-06-20 15:30:00	SPY	ETF	295.66	296.3093	295.51	295.84	17640991.0
2019-06-20 16:00:00	SPY	ETF	295.84	296.09	295.77	295.86	24473623.0
2019-06-20 16:30:00	SPY	ETF	295.89	295.89	295.67	295.78	2605081.0
2019-06-20 17:00:00	SPY	ETF	295.76	295.86	295.73	295.73	193134.0
2019-06-20 17:30:00	SPY	ETF	295.75	295.75	295.73	295.75	20221.0
2019-06-20 18:00:00	SPY	ETF	295.71	295.75	294.8	295.68	757222.0
2019-06-20 18:30:00	SPY	ETF	295.69	295.7	295.48	295.61	65250.0
2019-06-20 19:00:00	SPY	ETF	295.56	295.69	295.44	295.69	26416.0
2019-06-20 19:30:00	SPY	ETF	295.68	295.78	295.66	295.68	19552.0
2019-06-20 04:00:00	QQQ	ETF	189.16	189.3	189.08	189.25	20530.0
2019-06-20 04:30:00	QQQ	ETF	189.33	189.55	189.33	189.51	14350.0
2019-06-20 05:00:00	QQQ	ETF	189.46	189.68	189.46	189.68	17500.0
2019-06-20 05:30:00	QQQ	ETF	189.66	189.77	189.58	189.59	10470.0
2019-06-20 06:00:00	QQQ	ETF	189.59	189.72	189.55	189.64	13590.0
2019-06-20 06:30:00	QQQ	ETF	189.61	189.61	189.5	189.59	15128.0
2019-06-20 07:00:00	QQQ	ETF	189.5	189.69	189.48	189.62	79040.0
2019-06-20 07:30:00	QQQ	ETF	189.67	189.85	189.64	189.67	77112.0
2019-06-20 08:00:00	QQQ	ETF	189.54	189.87	187.11	189.85	163117.0
2019-06-20 08:30:00	QQQ	ETF	189.86	190.19	189.86	189.96	385096.0
2019-06-20 09:00:00	QQQ	ETF	189.98	190.13	189.71	189.72	332928.0
2019-06-20 09:30:00	QQQ	ETF	189.74	189.76	189.08	189.46	5389888.0
2019-06-20 10:00:00	QQQ	ETF	189.47	189.64	188.75	188.85	2830531.0
2019-06-20 10:30:00	QQQ	ETF	188.87	188.99	188.58	188.615	1799290.0
2019-06-20 11:00:00	QQQ	ETF	188.62	188.95	188.27	188.37	2040299.0
2019-06-20 11:30:00	QQQ	ETF	188.375	188.68	188.2	188.5693	1567406.0
2019-06-20 12:00:00	QQQ	ETF	188.58	188.61	187.4401	188.145	2376892.0
2019-06-20 12:30:00	QQQ	ETF	188.14	188.29	187.86	188.155	1317311.0

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

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