PREVIEW / etf_30min / 2019-09-25

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-25.parquet
  size:    509 KB
  rows:    17,524

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-09-25 04:00:00	SPY	ETF	295.41	295.6	295.38	295.53	11583.0
2019-09-25 04:30:00	SPY	ETF	295.3	295.34	294.99	295.0	11083.0
2019-09-25 05:00:00	SPY	ETF	295.07	295.27	294.65	295.0	12036.0
2019-09-25 05:30:00	SPY	ETF	295.04	295.38	294.86	295.36	5293.0
2019-09-25 06:00:00	SPY	ETF	295.32	295.45	295.3	295.39	6809.0
2019-09-25 06:30:00	SPY	ETF	295.34	295.5	295.23	295.5	41139.0
2019-09-25 07:00:00	SPY	ETF	295.5	295.51	295.24	295.34	69325.0
2019-09-25 07:30:00	SPY	ETF	295.4	295.5	295.21	295.35	60528.0
2019-09-25 08:00:00	SPY	ETF	295.35	296.62	295.31	295.89	215758.0
2019-09-25 08:30:00	SPY	ETF	295.86	296.13	295.73	296.07	202433.0
2019-09-25 09:00:00	SPY	ETF	296.07	296.25	295.87	295.94	350350.0
2019-09-25 09:30:00	SPY	ETF	295.96	296.36	295.11	295.18	6008425.0
2019-09-25 10:00:00	SPY	ETF	295.2	295.8	294.33	295.53	9837112.0
2019-09-25 10:30:00	SPY	ETF	295.525	296.61	295.39	296.26	5641719.0
2019-09-25 11:00:00	SPY	ETF	296.26	296.7	296.255	296.43	3658929.0
2019-09-25 11:30:00	SPY	ETF	296.42	296.65	296.11	296.44	2530935.0
2019-09-25 12:00:00	SPY	ETF	296.44	296.93	296.33	296.62	2623118.0
2019-09-25 12:30:00	SPY	ETF	296.635	296.83	296.3	296.4637	2248376.0
2019-09-25 13:00:00	SPY	ETF	296.47	296.79	296.38	296.56	1403724.0
2019-09-25 13:30:00	SPY	ETF	296.56	296.99	296.46	296.88	1429312.0
2019-09-25 14:00:00	SPY	ETF	296.87	297.36	296.865	297.235	3391189.0
2019-09-25 14:30:00	SPY	ETF	297.23	297.55	297.07	297.5099	2659136.0
2019-09-25 15:00:00	SPY	ETF	297.5	297.77	297.4	297.66	3574019.0
2019-09-25 15:30:00	SPY	ETF	297.655	298.11	297.53	297.6	9907502.0
2019-09-25 16:00:00	SPY	ETF	297.59	297.73	297.43	297.58	11181787.0
2019-09-25 16:30:00	SPY	ETF	297.6	297.64	297.51	297.56	1362990.0
2019-09-25 17:00:00	SPY	ETF	297.59	297.62	297.46	297.55	59048.0
2019-09-25 17:30:00	SPY	ETF	297.55	297.6	297.48	297.55	10901.0
2019-09-25 18:00:00	SPY	ETF	297.51	297.78	297.51	297.68	51041.0
2019-09-25 18:30:00	SPY	ETF	297.7	297.7	297.51	297.53	29491.0
2019-09-25 19:00:00	SPY	ETF	297.55	297.55	297.26	297.29	60473.0
2019-09-25 19:30:00	SPY	ETF	297.29	297.59	297.29	297.51	21004.0
2019-09-25 04:00:00	QQQ	ETF	187.37	187.56	187.32	187.53	4956.0
2019-09-25 04:30:00	QQQ	ETF	187.46	187.46	186.99	187.05	31138.0
2019-09-25 05:00:00	QQQ	ETF	187.02	187.2	186.72	187.08	26548.0
2019-09-25 05:30:00	QQQ	ETF	187.07	187.34	186.98	187.33	16506.0
2019-09-25 06:00:00	QQQ	ETF	187.31	187.39	187.28	187.35	7998.0
2019-09-25 06:30:00	QQQ	ETF	187.29	187.44	187.23	187.44	23082.0
2019-09-25 07:00:00	QQQ	ETF	187.46	187.46	187.24	187.38	71159.0
2019-09-25 07:30:00	QQQ	ETF	187.38	187.4	187.21	187.3	41603.0
2019-09-25 08:00:00	QQQ	ETF	187.35	187.85	187.25	187.79	100901.0
2019-09-25 08:30:00	QQQ	ETF	187.77	188.01	187.68	187.97	97810.0
2019-09-25 09:00:00	QQQ	ETF	187.97	188.15	187.72	187.79	172685.0
2019-09-25 09:30:00	QQQ	ETF	187.79	188.07	186.88	187.0576	3470522.0
2019-09-25 10:00:00	QQQ	ETF	187.07	187.57	186.21	187.45	4900273.0
2019-09-25 10:30:00	QQQ	ETF	187.45	188.34	187.29	188.1	3016130.0
2019-09-25 11:00:00	QQQ	ETF	188.11	188.73	188.09	188.41	1697373.0
2019-09-25 11:30:00	QQQ	ETF	188.405	188.51	188.06	188.35	1657577.0
2019-09-25 12:00:00	QQQ	ETF	188.35	188.84	188.29	188.705	1300369.0
2019-09-25 12:30:00	QQQ	ETF	188.7084	188.91	188.51	188.64	893705.0

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

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