PREVIEW / etf_30min / 2020-09-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-02.parquet
  size:    583 KB
  rows:    21,338

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
2020-09-02 04:00:00	SPY	ETF	354.51	354.86	354.44	354.79	17042.0
2020-09-02 04:30:00	SPY	ETF	354.9	355.26	354.85	355.1	16226.0
2020-09-02 05:00:00	SPY	ETF	355.23	355.41	355.05	355.32	12758.0
2020-09-02 05:30:00	SPY	ETF	355.37	355.53	355.03	355.5	12531.0
2020-09-02 06:00:00	SPY	ETF	355.47	355.62	355.09	355.1	35833.0
2020-09-02 06:30:00	SPY	ETF	355.03	355.27	355.01	355.1	78200.0
2020-09-02 07:00:00	SPY	ETF	355.0	355.12	354.87	354.92	54109.0
2020-09-02 07:30:00	SPY	ETF	354.99	355.11	354.69	354.69	113591.0
2020-09-02 08:00:00	SPY	ETF	354.68	355.4104	353.6	354.8	140067.0
2020-09-02 08:30:00	SPY	ETF	354.85	354.91	354.63	354.71	90760.0
2020-09-02 09:00:00	SPY	ETF	354.68	354.92	354.6	354.68	288132.0
2020-09-02 09:30:00	SPY	ETF	354.67	354.69	353.53	353.75	7589644.0
2020-09-02 10:00:00	SPY	ETF	353.76	354.97	353.43	354.95	4361671.0
2020-09-02 10:30:00	SPY	ETF	354.96	355.29	354.42	354.89	4628072.0
2020-09-02 11:00:00	SPY	ETF	354.88	355.08	354.11	354.45	3457106.0
2020-09-02 11:30:00	SPY	ETF	354.42	354.86	353.66	354.785	4243802.0
2020-09-02 12:00:00	SPY	ETF	354.785	355.51	354.54	355.4201	2928824.0
2020-09-02 12:30:00	SPY	ETF	355.43	355.78	355.34	355.575	2146101.0
2020-09-02 13:00:00	SPY	ETF	355.58	356.51	355.4	356.46	2589237.0
2020-09-02 13:30:00	SPY	ETF	356.45	356.739	356.36	356.43	2016656.0
2020-09-02 14:00:00	SPY	ETF	356.44	356.68	355.81	356.54	2858110.0
2020-09-02 14:30:00	SPY	ETF	356.53	356.93	356.35	356.75	2816350.0
2020-09-02 15:00:00	SPY	ETF	356.75	357.9	356.67	357.66	5306085.0
2020-09-02 15:30:00	SPY	ETF	357.66	358.75	357.48	357.68	17291712.0
2020-09-02 16:00:00	SPY	ETF	357.67	358.0	357.62	357.98	3115813.0
2020-09-02 16:30:00	SPY	ETF	357.93	358.1528	357.62	357.76	506959.0
2020-09-02 17:00:00	SPY	ETF	357.86	357.9	357.7	357.8999	277969.0
2020-09-02 17:30:00	SPY	ETF	357.85	357.89	357.82	357.87	22487.0
2020-09-02 18:00:00	SPY	ETF	357.82	357.86	357.5	357.85	77476.0
2020-09-02 18:30:00	SPY	ETF	357.82	358.12	357.72	358.11	36769.0
2020-09-02 19:00:00	SPY	ETF	358.13	358.49	358.06	358.38	58771.0
2020-09-02 19:30:00	SPY	ETF	358.38	358.63	358.27	358.43	76556.0
2020-09-02 04:00:00	QQQ	ETF	303.0	303.33	302.95	303.26	46276.0
2020-09-02 04:30:00	QQQ	ETF	303.28	303.55	303.27	303.51	20587.0
2020-09-02 05:00:00	QQQ	ETF	303.52	303.59	303.39	303.52	15454.0
2020-09-02 05:30:00	QQQ	ETF	303.5	304.02	303.26	303.99	17980.0
2020-09-02 06:00:00	QQQ	ETF	303.78	303.86	303.33	303.44	44349.0
2020-09-02 06:30:00	QQQ	ETF	303.4	303.53	303.0	303.29	152111.0
2020-09-02 07:00:00	QQQ	ETF	303.19	303.36	303.09	303.31	98399.0
2020-09-02 07:30:00	QQQ	ETF	303.3	303.47	303.0	303.02	99218.0
2020-09-02 08:00:00	QQQ	ETF	303.21	303.7804	299.92	303.39	197673.0
2020-09-02 08:30:00	QQQ	ETF	303.46	303.47	303.21	303.36	124160.0
2020-09-02 09:00:00	QQQ	ETF	303.31	303.54	303.11	303.21	200456.0
2020-09-02 09:30:00	QQQ	ETF	303.24	303.33	298.61	298.78	8093836.0
2020-09-02 10:00:00	QQQ	ETF	298.82	301.2	298.76	301.14	4959784.0
2020-09-02 10:30:00	QQQ	ETF	301.18	301.34	299.57	300.53	3096291.0
2020-09-02 11:00:00	QQQ	ETF	300.55	300.68	298.51	299.2499	3249742.0
2020-09-02 11:30:00	QQQ	ETF	299.25	299.87	296.89	299.105	4061069.0
2020-09-02 12:00:00	QQQ	ETF	299.1	300.58	298.78	300.42	2504757.0
2020-09-02 12:30:00	QQQ	ETF	300.42	301.05	300.31	300.73	1769418.0

> showing 50 of 21,338 rows — these rows as CSV

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