PREVIEW / etf_30min / 2019-07-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-24.parquet
  size:    498 KB
  rows:    17,333

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-24 04:00:00	SPY	ETF	299.35	299.47	299.15	299.2	10272.0
2019-07-24 04:30:00	SPY	ETF	299.17	299.17	298.9	298.95	5610.0
2019-07-24 05:00:00	SPY	ETF	298.95	299.15	298.95	299.12	5933.0
2019-07-24 05:30:00	SPY	ETF	299.02	299.07	298.87	298.95	10896.0
2019-07-24 06:00:00	SPY	ETF	299.05	299.17	299.05	299.16	6800.0
2019-07-24 06:30:00	SPY	ETF	299.15	299.39	299.15	299.39	37464.0
2019-07-24 07:00:00	SPY	ETF	299.38	299.43	299.23	299.35	33932.0
2019-07-24 07:30:00	SPY	ETF	299.35	299.35	299.2	299.26	103410.0
2019-07-24 08:00:00	SPY	ETF	299.2999	300.03	299.15	299.35	103038.0
2019-07-24 08:30:00	SPY	ETF	299.34	299.48	299.1	299.16	149475.0
2019-07-24 09:00:00	SPY	ETF	299.17	300.03	299.15	299.16	747990.0
2019-07-24 09:30:00	SPY	ETF	299.19	300.31	299.09	299.9393	4203620.0
2019-07-24 10:00:00	SPY	ETF	299.935	300.19	299.87	300.04	1967707.0
2019-07-24 10:30:00	SPY	ETF	300.04	300.51	300.02	300.14	2888750.0
2019-07-24 11:00:00	SPY	ETF	300.15	300.16	299.7	299.88	2733187.0
2019-07-24 11:30:00	SPY	ETF	299.8825	300.1	299.8	299.84	1438601.0
2019-07-24 12:00:00	SPY	ETF	299.86	300.19	299.85	300.06	2266511.0
2019-07-24 12:30:00	SPY	ETF	300.05	300.47	300.05	300.425	1335470.0
2019-07-24 13:00:00	SPY	ETF	300.42	300.47	300.31	300.38	1558952.0
2019-07-24 13:30:00	SPY	ETF	300.37	300.45	300.225	300.41	1993358.0
2019-07-24 14:00:00	SPY	ETF	300.41	300.72	300.39	300.68	2326037.0
2019-07-24 14:30:00	SPY	ETF	300.69	300.93	300.62	300.91	2437335.0
2019-07-24 15:00:00	SPY	ETF	300.91	301.16	300.8	301.14	2975572.0
2019-07-24 15:30:00	SPY	ETF	301.14	301.42	301.08	301.38	9270488.0
2019-07-24 16:00:00	SPY	ETF	301.4	301.44	299.9604	301.15	5973962.0
2019-07-24 16:30:00	SPY	ETF	301.11	301.44	300.98	300.98	634179.0
2019-07-24 17:00:00	SPY	ETF	300.98	301.38	300.91	300.94	463168.0
2019-07-24 17:30:00	SPY	ETF	300.99	301.44	300.88	301.07	70583.0
2019-07-24 18:00:00	SPY	ETF	301.04	301.25	301.02	301.25	42435.0
2019-07-24 18:30:00	SPY	ETF	301.22	301.24	301.15	301.15	3018.0
2019-07-24 19:00:00	SPY	ETF	301.16	301.19	301.15	301.16	1819.0
2019-07-24 19:30:00	SPY	ETF	301.2	301.39	301.2	301.33	21717.0
2019-07-24 04:00:00	QQQ	ETF	193.23	193.23	193.03	193.1	14040.0
2019-07-24 04:30:00	QQQ	ETF	193.12	193.12	192.79	192.88	25096.0
2019-07-24 05:00:00	QQQ	ETF	192.88	192.99	192.85	192.88	6200.0
2019-07-24 05:30:00	QQQ	ETF	192.91	192.91	192.75	192.89	7004.0
2019-07-24 06:00:00	QQQ	ETF	192.9	193.06	192.9	193.06	9388.0
2019-07-24 06:30:00	QQQ	ETF	193.03	193.33	192.98	193.3	11546.0
2019-07-24 07:00:00	QQQ	ETF	193.31	193.38	193.16	193.37	23746.0
2019-07-24 07:30:00	QQQ	ETF	193.3	193.45	193.27	193.36	29663.0
2019-07-24 08:00:00	QQQ	ETF	193.25	193.79	192.98	193.36	79631.0
2019-07-24 08:30:00	QQQ	ETF	193.37	193.5	193.1	193.14	89501.0
2019-07-24 09:00:00	QQQ	ETF	193.15	193.23	193.07	193.09	79660.0
2019-07-24 09:30:00	QQQ	ETF	193.07	194.05	193.03	193.7783	1936956.0
2019-07-24 10:00:00	QQQ	ETF	193.8	194.03	193.655	193.96	914094.0
2019-07-24 10:30:00	QQQ	ETF	193.97	194.4	193.91	194.02	1025605.0
2019-07-24 11:00:00	QQQ	ETF	194.02	194.11	193.78	194.01	849929.0
2019-07-24 11:30:00	QQQ	ETF	194.0	194.26	193.95	194.01	598282.0
2019-07-24 12:00:00	QQQ	ETF	194.01	194.26	193.99	194.14	834738.0
2019-07-24 12:30:00	QQQ	ETF	194.15	194.39	194.15	194.32	643297.0

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

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