PREVIEW / etf_30min / 2020-11-25

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-25.parquet
  size:    581 KB
  rows:    21,712

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-25 04:00:00	SPY	ETF	363.26	363.6	362.68	362.75	29160.0
2020-11-25 04:30:00	SPY	ETF	362.65	363.29	362.65	363.22	8666.0
2020-11-25 05:00:00	SPY	ETF	363.22	363.32	362.77	363.0	14694.0
2020-11-25 05:30:00	SPY	ETF	363.1	363.15	362.45	362.65	14394.0
2020-11-25 06:00:00	SPY	ETF	362.7	362.75	362.55	362.7	4331.0
2020-11-25 06:30:00	SPY	ETF	362.75	363.1	362.7	363.01	16211.0
2020-11-25 07:00:00	SPY	ETF	362.99	363.55	362.99	363.55	79368.0
2020-11-25 07:30:00	SPY	ETF	363.57	363.57	362.6	362.84	98832.0
2020-11-25 08:00:00	SPY	ETF	363.3299	364.1	362.51	362.93	255938.0
2020-11-25 08:30:00	SPY	ETF	362.85	363.3	362.51	362.93	136350.0
2020-11-25 09:00:00	SPY	ETF	362.93	363.26	362.92	363.13	178850.0
2020-11-25 09:30:00	SPY	ETF	363.13	363.16	361.83	362.16	5101560.0
2020-11-25 10:00:00	SPY	ETF	362.16	362.42	361.48	362.02	3887800.0
2020-11-25 10:30:00	SPY	ETF	362.03	362.49	361.81	362.045	2927780.0
2020-11-25 11:00:00	SPY	ETF	362.05	362.45	362.0	362.13	2090693.0
2020-11-25 11:30:00	SPY	ETF	362.12	362.35	361.63	362.15	2735890.0
2020-11-25 12:00:00	SPY	ETF	362.17	362.34	361.99	362.09	1225653.0
2020-11-25 12:30:00	SPY	ETF	362.09	362.72	362.09	362.6936	2363460.0
2020-11-25 13:00:00	SPY	ETF	362.7	362.9	362.34	362.37	1206233.0
2020-11-25 13:30:00	SPY	ETF	362.375	362.81	362.17	362.6999	1226662.0
2020-11-25 14:00:00	SPY	ETF	362.7	362.7019	361.93	362.395	2229059.0
2020-11-25 14:30:00	SPY	ETF	362.4	362.59	362.05	362.459	1982538.0
2020-11-25 15:00:00	SPY	ETF	362.45	363.13	362.37	362.96	2796355.0
2020-11-25 15:30:00	SPY	ETF	362.955	363.16	362.4	362.65	5464671.0
2020-11-25 16:00:00	SPY	ETF	362.66	362.95	362.4	362.79	6533534.0
2020-11-25 16:30:00	SPY	ETF	362.74	362.94	362.67	362.82	192780.0
2020-11-25 17:00:00	SPY	ETF	362.94	362.96	362.72	362.96	13214.0
2020-11-25 17:30:00	SPY	ETF	362.97	362.98	362.85	362.9	11866.0
2020-11-25 18:00:00	SPY	ETF	363.0	363.15	362.88	363.09	48348.0
2020-11-25 18:30:00	SPY	ETF	362.66	363.18	362.66	363.12	14160.0
2020-11-25 19:00:00	SPY	ETF	363.1	363.17	362.6	363.04	27338.0
2020-11-25 19:30:00	SPY	ETF	363.06	363.4	363.06	363.1799	36221.0
2020-11-25 04:00:00	QQQ	ETF	295.52	295.59	294.99	295.12	31763.0
2020-11-25 04:30:00	QQQ	ETF	295.06	295.5	295.06	295.5	13623.0
2020-11-25 05:00:00	QQQ	ETF	295.52	295.53	295.17	295.34	10590.0
2020-11-25 05:30:00	QQQ	ETF	295.35	295.45	294.92	295.11	11914.0
2020-11-25 06:00:00	QQQ	ETF	295.16	295.24	294.97	295.08	55129.0
2020-11-25 06:30:00	QQQ	ETF	295.14	295.41	295.01	295.28	22844.0
2020-11-25 07:00:00	QQQ	ETF	295.27	295.72	295.27	295.69	85807.0
2020-11-25 07:30:00	QQQ	ETF	295.68	295.7	294.97	295.11	73970.0
2020-11-25 08:00:00	QQQ	ETF	295.1001	296.09	294.66	294.9	126618.0
2020-11-25 08:30:00	QQQ	ETF	294.74	295.62	294.74	295.26	101714.0
2020-11-25 09:00:00	QQQ	ETF	295.261	295.5	295.21	295.46	126671.0
2020-11-25 09:30:00	QQQ	ETF	295.46	296.22	295.13	295.74	2694292.0
2020-11-25 10:00:00	QQQ	ETF	295.72	295.82	294.59	294.98	1770778.0
2020-11-25 10:30:00	QQQ	ETF	294.99	295.74	294.89	295.49	914394.0
2020-11-25 11:00:00	QQQ	ETF	295.49	295.96	295.23	295.46	837178.0
2020-11-25 11:30:00	QQQ	ETF	295.45	295.73	294.82	295.14	1219705.0
2020-11-25 12:00:00	QQQ	ETF	295.14	295.73	294.959	295.54	715315.0
2020-11-25 12:30:00	QQQ	ETF	295.55	296.13	295.52	296.03	657552.0

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

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