PREVIEW / etf_30min / 2020-11-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-27.parquet
  size:    365 KB
  rows:    12,812

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-11-27 04:00:00	SPY	ETF	363.6	363.74	363.5	363.64	13785.0
2020-11-27 04:30:00	SPY	ETF	363.5	363.5	363.16	363.19	10946.0
2020-11-27 05:00:00	SPY	ETF	363.35	363.39	363.02	363.02	8171.0
2020-11-27 05:30:00	SPY	ETF	363.12	363.25	363.12	363.23	30982.0
2020-11-27 06:00:00	SPY	ETF	363.28	363.31	363.2	363.31	2437.0
2020-11-27 06:30:00	SPY	ETF	363.35	363.49	363.35	363.38	5027.0
2020-11-27 07:00:00	SPY	ETF	363.38	363.55	363.36	363.55	19051.0
2020-11-27 07:30:00	SPY	ETF	363.46	363.7	363.44	363.67	175397.0
2020-11-27 08:00:00	SPY	ETF	363.4399	363.76	362.71	363.64	75533.0
2020-11-27 08:30:00	SPY	ETF	363.64	364.07	363.58	363.85	105951.0
2020-11-27 09:00:00	SPY	ETF	363.83	364.15	363.83	363.83	122465.0
2020-11-27 09:30:00	SPY	ETF	363.84	364.15	363.52	363.677	4009912.0
2020-11-27 10:00:00	SPY	ETF	363.68	364.18	363.6	364.0	5079658.0
2020-11-27 10:30:00	SPY	ETF	364.01	364.14	363.86	364.0	2168106.0
2020-11-27 11:00:00	SPY	ETF	363.98	364.13	363.68	363.8	2306981.0
2020-11-27 11:30:00	SPY	ETF	363.81	363.905	363.18	363.41	2155561.0
2020-11-27 12:00:00	SPY	ETF	363.41	363.5	362.72	362.745	2771042.0
2020-11-27 12:30:00	SPY	ETF	362.74	363.72	362.58	363.65	4928402.0
2020-11-27 13:00:00	SPY	ETF	363.64	363.76	363.37	363.75	1156180.0
2020-11-27 13:30:00	SPY	ETF	363.75	364.03	363.75	363.97	222156.0
2020-11-27 14:00:00	SPY	ETF	363.96	363.98	363.6701	363.68	128388.0
2020-11-27 14:30:00	SPY	ETF	363.68	363.68	363.54	363.5999	65537.0
2020-11-27 15:00:00	SPY	ETF	363.62	363.67	363.6	363.67	6020.0
2020-11-27 15:30:00	SPY	ETF	363.63	363.86	363.62	363.79	7578.0
2020-11-27 16:00:00	SPY	ETF	363.75	363.82	363.44	363.55	26760.0
2020-11-27 16:30:00	SPY	ETF	363.55	363.67	363.5	363.65	17188.0
2020-11-27 04:00:00	QQQ	ETF	297.45	297.67	297.41	297.5	16536.0
2020-11-27 04:30:00	QQQ	ETF	297.45	297.53	297.34	297.41	7619.0
2020-11-27 05:00:00	QQQ	ETF	297.34	297.34	297.17	297.22	6788.0
2020-11-27 05:30:00	QQQ	ETF	297.19	297.4	297.19	297.38	3450.0
2020-11-27 06:00:00	QQQ	ETF	297.43	297.5	297.36	297.49	7200.0
2020-11-27 06:30:00	QQQ	ETF	297.47	297.52	297.4	297.45	78400.0
2020-11-27 07:00:00	QQQ	ETF	297.45	297.52	297.35	297.36	46534.0
2020-11-27 07:30:00	QQQ	ETF	297.34	297.67	297.34	297.58	33826.0
2020-11-27 08:00:00	QQQ	ETF	297.45	297.98	297.09	297.89	134311.0
2020-11-27 08:30:00	QQQ	ETF	297.9	298.52	297.88	298.31	99311.0
2020-11-27 09:00:00	QQQ	ETF	298.3	298.572	298.18	298.25	162853.0
2020-11-27 09:30:00	QQQ	ETF	298.23	298.89	297.9	298.735	2112102.0
2020-11-27 10:00:00	QQQ	ETF	298.75	299.9	298.5568	299.68	1801673.0
2020-11-27 10:30:00	QQQ	ETF	299.6699	300.17	299.56	299.89	1502674.0
2020-11-27 11:00:00	QQQ	ETF	299.87	299.99	299.44	299.68	928070.0
2020-11-27 11:30:00	QQQ	ETF	299.67	299.885	298.62	298.835	1507832.0
2020-11-27 12:00:00	QQQ	ETF	298.83	299.19	298.35	298.5989	1480019.0
2020-11-27 12:30:00	QQQ	ETF	298.6	299.05	298.45	299.02	1649710.0
2020-11-27 13:00:00	QQQ	ETF	299.0	299.35	298.89	299.225	641784.0
2020-11-27 13:30:00	QQQ	ETF	299.25	299.33	299.13	299.19	24105.0
2020-11-27 14:00:00	QQQ	ETF	299.24	299.26	299.1	299.25	10543.0
2020-11-27 14:30:00	QQQ	ETF	299.23	299.34	298.88	298.9501	41180.0
2020-11-27 15:00:00	QQQ	ETF	298.96	299.1	298.89	299.07	10333.0
2020-11-27 15:30:00	QQQ	ETF	299.0	299.3	298.95	299.29	9442.0

> showing 50 of 12,812 rows — these rows as CSV

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