PREVIEW / etf_30min / 2019-07-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-08.parquet
  size:    491 KB
  rows:    17,527

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-08 04:00:00	SPY	ETF	297.61	297.77	297.6	297.67	4478.0
2019-07-08 04:30:00	SPY	ETF	297.64	297.66	297.51	297.51	4036.0
2019-07-08 05:00:00	SPY	ETF	297.51	297.51	297.18	297.2	6460.0
2019-07-08 05:30:00	SPY	ETF	297.2	297.4	297.17	297.37	2537.0
2019-07-08 06:00:00	SPY	ETF	297.35	297.45	297.3	297.3	1820.0
2019-07-08 06:30:00	SPY	ETF	297.3	297.3	297.2	297.2	1300.0
2019-07-08 07:00:00	SPY	ETF	297.22	297.52	297.22	297.45	36853.0
2019-07-08 07:30:00	SPY	ETF	297.5	297.5	297.22	297.22	44507.0
2019-07-08 08:00:00	SPY	ETF	297.4	297.49	296.92	297.27	174116.0
2019-07-08 08:30:00	SPY	ETF	297.29	297.34	297.08	297.1	131568.0
2019-07-08 09:00:00	SPY	ETF	297.09	297.16	296.99	297.0	214364.0
2019-07-08 09:30:00	SPY	ETF	297.01	297.03	296.45	296.57	4786098.0
2019-07-08 10:00:00	SPY	ETF	296.575	297.35	296.56	296.82	3059048.0
2019-07-08 10:30:00	SPY	ETF	296.82	296.99	296.5	296.71	3125146.0
2019-07-08 11:00:00	SPY	ETF	296.72	297.0635	296.69	296.79	1487771.0
2019-07-08 11:30:00	SPY	ETF	296.79	296.84	296.53	296.675	1688168.0
2019-07-08 12:00:00	SPY	ETF	296.68	296.7	296.34	296.39	1650125.0
2019-07-08 12:30:00	SPY	ETF	296.39	296.65	296.39	296.595	1831755.0
2019-07-08 13:00:00	SPY	ETF	296.59	296.7485	296.58	296.62	1181305.0
2019-07-08 13:30:00	SPY	ETF	296.62	296.82	296.46	296.615	1892438.0
2019-07-08 14:00:00	SPY	ETF	296.62	296.62	296.22	296.4968	1844870.0
2019-07-08 14:30:00	SPY	ETF	296.4968	298.2579	296.475	296.57	3942513.0
2019-07-08 15:00:00	SPY	ETF	296.57	296.98	296.48	296.82	2549470.0
2019-07-08 15:30:00	SPY	ETF	296.83	297.1	296.755	296.86	7549624.0
2019-07-08 16:00:00	SPY	ETF	296.85	297.01	296.68	296.74	6907264.0
2019-07-08 16:30:00	SPY	ETF	296.74	296.77	296.56	296.73	124483.0
2019-07-08 17:00:00	SPY	ETF	296.73	296.82	296.6	296.76	91898.0
2019-07-08 17:30:00	SPY	ETF	296.75	296.82	296.68	296.7	46148.0
2019-07-08 18:00:00	SPY	ETF	296.69	296.75	296.56	296.7	58011.0
2019-07-08 18:30:00	SPY	ETF	296.7	296.79	296.7	296.75	15399.0
2019-07-08 19:00:00	SPY	ETF	296.75	296.82	296.65	296.65	8713.0
2019-07-08 19:30:00	SPY	ETF	296.65	296.65	296.4	296.48	39993.0
2019-07-08 04:00:00	QQQ	ETF	190.26	190.5	190.26	190.45	8540.0
2019-07-08 04:30:00	QQQ	ETF	190.35	190.35	190.3	190.3	900.0
2019-07-08 05:00:00	QQQ	ETF	190.24	190.24	189.92	189.92	8756.0
2019-07-08 05:30:00	QQQ	ETF	189.92	190.04	189.92	190.01	9725.0
2019-07-08 06:00:00	QQQ	ETF	190.01	190.04	189.91	189.91	4143.0
2019-07-08 06:30:00	QQQ	ETF	189.88	189.93	189.78	189.84	4500.0
2019-07-08 07:00:00	QQQ	ETF	189.8	190.05	189.8	190.02	29743.0
2019-07-08 07:30:00	QQQ	ETF	190.07	190.07	189.93	189.93	14075.0
2019-07-08 08:00:00	QQQ	ETF	189.9101	190.15	189.77	190.01	27121.0
2019-07-08 08:30:00	QQQ	ETF	190.01	190.06	189.87	189.89	48659.0
2019-07-08 09:00:00	QQQ	ETF	189.85	189.99	189.82	189.85	90863.0
2019-07-08 09:30:00	QQQ	ETF	189.86	189.87	188.93	188.98	2630118.0
2019-07-08 10:00:00	QQQ	ETF	188.99	189.565	188.96	189.34	1615707.0
2019-07-08 10:30:00	QQQ	ETF	189.34	189.56	189.0901	189.42	1169735.0
2019-07-08 11:00:00	QQQ	ETF	189.42	189.7099	189.33	189.46	912321.0
2019-07-08 11:30:00	QQQ	ETF	189.47	189.48	189.12	189.275	759166.0
2019-07-08 12:00:00	QQQ	ETF	189.27	189.31	189.03	189.13	648718.0
2019-07-08 12:30:00	QQQ	ETF	189.14	189.45	189.14	189.4351	674456.0

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

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