PREVIEW / etf_30min / 2019-09-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-24.parquet
  size:    520 KB
  rows:    17,907

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-24 04:00:00	SPY	ETF	299.2	299.45	299.2	299.36	16378.0
2019-09-24 04:30:00	SPY	ETF	299.31	299.39	299.23	299.39	3684.0
2019-09-24 05:00:00	SPY	ETF	299.39	299.54	299.39	299.54	3311.0
2019-09-24 05:30:00	SPY	ETF	299.54	299.64	299.53	299.57	9225.0
2019-09-24 06:00:00	SPY	ETF	299.45	299.46	299.38	299.38	2152.0
2019-09-24 06:30:00	SPY	ETF	299.36	299.56	299.3	299.53	19100.0
2019-09-24 07:00:00	SPY	ETF	299.55	299.84	299.55	299.68	45774.0
2019-09-24 07:30:00	SPY	ETF	299.65	299.7	299.56	299.63	25982.0
2019-09-24 08:00:00	SPY	ETF	299.63	299.69	299.11	299.45	380036.0
2019-09-24 08:30:00	SPY	ETF	299.46	299.48	299.12	299.3	295169.0
2019-09-24 09:00:00	SPY	ETF	299.31	299.51	299.27	299.41	153319.0
2019-09-24 09:30:00	SPY	ETF	299.41	299.84	299.06	299.585	5181796.0
2019-09-24 10:00:00	SPY	ETF	299.585	299.61	298.62	298.88	6084199.0
2019-09-24 10:30:00	SPY	ETF	298.87	299.39	298.77	298.8865	3365996.0
2019-09-24 11:00:00	SPY	ETF	298.89	298.91	298.34	298.43	3606141.0
2019-09-24 11:30:00	SPY	ETF	298.43	298.45	297.21	297.5	5635379.0
2019-09-24 12:00:00	SPY	ETF	297.4902	297.89	295.96	296.35	5952965.0
2019-09-24 12:30:00	SPY	ETF	296.355	296.41	295.13	295.25	7918661.0
2019-09-24 13:00:00	SPY	ETF	295.24	295.81	294.835	295.03	5920044.0
2019-09-24 13:30:00	SPY	ETF	295.04	295.88	295.04	295.46	4536479.0
2019-09-24 14:00:00	SPY	ETF	295.4663	299.6	294.81	296.6	10910804.0
2019-09-24 14:30:00	SPY	ETF	296.6	296.76	295.53	295.76	7024043.0
2019-09-24 15:00:00	SPY	ETF	295.74	296.15	295.19	295.4499	5119729.0
2019-09-24 15:30:00	SPY	ETF	295.44	299.24	295.05	295.81	13243788.0
2019-09-24 16:00:00	SPY	ETF	295.81	298.38	295.7402	296.05	8087357.0
2019-09-24 16:30:00	SPY	ETF	296.06	296.2	295.93	296.11	565769.0
2019-09-24 17:00:00	SPY	ETF	296.19	296.23	295.9	295.98	175127.0
2019-09-24 17:30:00	SPY	ETF	295.97	296.03	295.87	296.03	1554366.0
2019-09-24 18:00:00	SPY	ETF	296.01	296.25	295.72	296.18	143135.0
2019-09-24 18:30:00	SPY	ETF	296.17	296.25	296.07	296.17	22068.0
2019-09-24 19:00:00	SPY	ETF	296.2	296.38	296.2	296.32	38818.0
2019-09-24 19:30:00	SPY	ETF	296.31	296.59	296.31	296.46	51003.0
2019-09-24 04:00:00	QQQ	ETF	191.25	191.35	191.22	191.27	4810.0
2019-09-24 04:30:00	QQQ	ETF	191.25	191.36	191.23	191.36	9220.0
2019-09-24 05:00:00	QQQ	ETF	191.34	191.45	191.33	191.45	4950.0
2019-09-24 05:30:00	QQQ	ETF	191.45	191.5	191.4	191.45	7530.0
2019-09-24 06:00:00	QQQ	ETF	191.43	191.43	191.31	191.33	6050.0
2019-09-24 06:30:00	QQQ	ETF	191.28	191.42	191.28	191.42	6159.0
2019-09-24 07:00:00	QQQ	ETF	191.46	191.62	191.43	191.52	42941.0
2019-09-24 07:30:00	QQQ	ETF	191.5	191.56	191.4	191.46	24967.0
2019-09-24 08:00:00	QQQ	ETF	191.5	191.53	191.08	191.36	47817.0
2019-09-24 08:30:00	QQQ	ETF	191.39	191.4	191.15	191.24	65900.0
2019-09-24 09:00:00	QQQ	ETF	191.24	191.39	191.23	191.37	85119.0
2019-09-24 09:30:00	QQQ	ETF	191.37	191.79	191.14	191.5618	2589431.0
2019-09-24 10:00:00	QQQ	ETF	191.58	191.585	190.67	190.82	2302022.0
2019-09-24 10:30:00	QQQ	ETF	190.838	191.08	190.34	190.53	1833513.0
2019-09-24 11:00:00	QQQ	ETF	190.54	190.57	190.05	190.19	1442461.0
2019-09-24 11:30:00	QQQ	ETF	190.18	190.21	188.942	189.3	2975461.0
2019-09-24 12:00:00	QQQ	ETF	189.28	189.59	187.96	188.29	2677041.0
2019-09-24 12:30:00	QQQ	ETF	188.3084	188.42	187.4	187.53	2880922.0

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

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