PREVIEW / etf_30min / 2019-07-10

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-10.parquet
  size:    507 KB
  rows:    17,690

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-07-10 04:00:00	SPY	ETF	296.83	296.89	296.67	296.67	5040.0
2019-07-10 04:30:00	SPY	ETF	296.67	296.68	296.6	296.62	3832.0
2019-07-10 05:00:00	SPY	ETF	296.7	296.87	296.59	296.78	7000.0
2019-07-10 05:30:00	SPY	ETF	296.78	296.78	296.33	296.48	8527.0
2019-07-10 06:00:00	SPY	ETF	296.43	296.43	296.06	296.28	9060.0
2019-07-10 06:30:00	SPY	ETF	296.26	296.41	296.18	296.39	12311.0
2019-07-10 07:00:00	SPY	ETF	296.41	296.55	296.36	296.52	50646.0
2019-07-10 07:30:00	SPY	ETF	296.55	296.59	296.42	296.5	37071.0
2019-07-10 08:00:00	SPY	ETF	296.5	297.0	296.41	296.64	215009.0
2019-07-10 08:30:00	SPY	ETF	296.64	298.54	296.63	298.35	1402551.0
2019-07-10 09:00:00	SPY	ETF	298.37	298.55	298.22	298.39	321771.0
2019-07-10 09:30:00	SPY	ETF	298.37	299.66	298.3	299.38	7747508.0
2019-07-10 10:00:00	SPY	ETF	299.39	299.48	298.59	298.64	4426913.0
2019-07-10 10:30:00	SPY	ETF	298.64	299.07	298.28	298.32	4411546.0
2019-07-10 11:00:00	SPY	ETF	298.31	298.45	297.78	298.03	4271043.0
2019-07-10 11:30:00	SPY	ETF	298.04	298.69	297.98	298.61	2907344.0
2019-07-10 12:00:00	SPY	ETF	298.62	298.77	298.295	298.49	1744664.0
2019-07-10 12:30:00	SPY	ETF	298.48	298.76	298.475	298.7599	1731371.0
2019-07-10 13:00:00	SPY	ETF	298.755	298.89	298.68	298.7899	1301574.0
2019-07-10 13:30:00	SPY	ETF	298.79	299.09	298.77	298.92	2883872.0
2019-07-10 14:00:00	SPY	ETF	298.93	299.25	298.41	298.415	5775872.0
2019-07-10 14:30:00	SPY	ETF	298.41	298.64	298.29	298.5489	1970107.0
2019-07-10 15:00:00	SPY	ETF	298.55	298.63	298.27	298.44	2656191.0
2019-07-10 15:30:00	SPY	ETF	298.44	298.77	298.415	298.61	6029278.0
2019-07-10 16:00:00	SPY	ETF	298.61	298.72	298.56	298.69	6837618.0
2019-07-10 16:30:00	SPY	ETF	298.67	298.68	298.54	298.54	168118.0
2019-07-10 17:00:00	SPY	ETF	298.61	298.61	298.51	298.56	208497.0
2019-07-10 17:30:00	SPY	ETF	298.56	298.61	298.38	298.47	155978.0
2019-07-10 18:00:00	SPY	ETF	298.49	298.68	298.46	298.68	113865.0
2019-07-10 18:30:00	SPY	ETF	298.7	298.85	298.68	298.74	26609.0
2019-07-10 19:00:00	SPY	ETF	298.75	298.75	298.68	298.68	3431.0
2019-07-10 19:30:00	SPY	ETF	298.65	298.73	298.56	298.62	29640.0
2019-07-10 04:00:00	QQQ	ETF	190.36	190.45	190.33	190.33	9230.0
2019-07-10 04:30:00	QQQ	ETF	190.25	190.37	190.17	190.37	4700.0
2019-07-10 05:00:00	QQQ	ETF	190.23	190.43	190.18	190.37	11500.0
2019-07-10 05:30:00	QQQ	ETF	190.37	190.38	189.95	190.1	49927.0
2019-07-10 06:00:00	QQQ	ETF	190.07	190.07	189.81	189.94	33100.0
2019-07-10 06:30:00	QQQ	ETF	189.94	190.07	189.85	190.07	23404.0
2019-07-10 07:00:00	QQQ	ETF	190.08	190.21	190.08	190.18	53943.0
2019-07-10 07:30:00	QQQ	ETF	190.21	190.3	190.1	190.21	60610.0
2019-07-10 08:00:00	QQQ	ETF	190.12	190.65	190.03	190.34	142036.0
2019-07-10 08:30:00	QQQ	ETF	190.45	192.16	190.45	191.96	723196.0
2019-07-10 09:00:00	QQQ	ETF	191.99	192.06	191.78	191.81	148064.0
2019-07-10 09:30:00	QQQ	ETF	191.79	193.09	191.62	192.98	4598794.0
2019-07-10 10:00:00	QQQ	ETF	192.97	193.09	192.11	192.16	1776819.0
2019-07-10 10:30:00	QQQ	ETF	192.18	192.63	191.85	191.9	2152117.0
2019-07-10 11:00:00	QQQ	ETF	191.91	192.03	191.47	191.75	2104398.0
2019-07-10 11:30:00	QQQ	ETF	191.75	192.4	191.71	192.34	1213241.0
2019-07-10 12:00:00	QQQ	ETF	192.34	192.47	192.0833	192.185	702832.0
2019-07-10 12:30:00	QQQ	ETF	192.181	192.38	192.18	192.34	395895.0

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

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