PREVIEW / etf_30min / 2022-11-30

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-30.parquet
  size:    694 KB
  rows:    28,329

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
2022-11-30 04:00:00	SPY	ETF	395.65	396.94	395.65	396.85	23173.0
2022-11-30 04:30:00	SPY	ETF	396.9	396.93	395.91	396.17	13264.0
2022-11-30 05:00:00	SPY	ETF	396.21	396.35	396.0	396.14	5876.0
2022-11-30 05:30:00	SPY	ETF	396.23	396.43	395.96	395.98	4342.0
2022-11-30 06:00:00	SPY	ETF	396.14	396.14	395.79	395.95	6234.0
2022-11-30 06:30:00	SPY	ETF	395.98	396.4	395.88	396.4	8129.0
2022-11-30 07:00:00	SPY	ETF	396.28	396.34	396.1	396.2	73374.0
2022-11-30 07:30:00	SPY	ETF	396.2	396.36	395.95	396.01	63416.0
2022-11-30 08:00:00	SPY	ETF	396.01	397.27	395.92	396.45	227629.0
2022-11-30 08:30:00	SPY	ETF	396.45	396.61	395.02	395.07	280193.0
2022-11-30 09:00:00	SPY	ETF	395.05	395.87	395.0	395.45	239769.0
2022-11-30 09:30:00	SPY	ETF	395.46	396.2094	394.865	395.21	4851727.0
2022-11-30 10:00:00	SPY	ETF	395.2	395.42	393.905	394.18	3812615.0
2022-11-30 10:30:00	SPY	ETF	394.185	394.79	393.8501	394.2	2088151.0
2022-11-30 11:00:00	SPY	ETF	394.21	395.29	393.76	395.115	2337059.0
2022-11-30 11:30:00	SPY	ETF	395.09	395.56	395.06	395.1536	2153665.0
2022-11-30 12:00:00	SPY	ETF	395.1533	395.3683	393.48	393.92	2565997.0
2022-11-30 12:30:00	SPY	ETF	393.9	394.35	393.5001	394.2218	1799970.0
2022-11-30 13:00:00	SPY	ETF	394.22	395.0	394.14	394.82	1727650.0
2022-11-30 13:30:00	SPY	ETF	394.8	400.0	394.06	399.72	10972602.0
2022-11-30 14:00:00	SPY	ETF	399.72	403.45	399.68	403.06	11161286.0
2022-11-30 14:30:00	SPY	ETF	403.09	403.49	401.97	403.26	6598261.0
2022-11-30 15:00:00	SPY	ETF	403.26	405.44	403.06	405.43	6999250.0
2022-11-30 15:30:00	SPY	ETF	405.42	407.55	405.34	407.47	29761214.0
2022-11-30 16:00:00	SPY	ETF	407.46	407.96	405.66	407.96	8826081.0
2022-11-30 16:30:00	SPY	ETF	407.95	408.45	407.94	408.41	453660.0
2022-11-30 17:00:00	SPY	ETF	408.35	408.51	408.13	408.16	170962.0
2022-11-30 17:30:00	SPY	ETF	408.16	408.39	408.16	408.35	73243.0
2022-11-30 18:00:00	SPY	ETF	408.39	408.7	407.9	408.02	138596.0
2022-11-30 18:30:00	SPY	ETF	408.0	408.37	407.81	408.27	47414.0
2022-11-30 19:00:00	SPY	ETF	408.27	408.45	408.05	408.26	40014.0
2022-11-30 19:30:00	SPY	ETF	408.25	408.26	407.9	408.0	152644.0
2022-11-30 04:00:00	QQQ	ETF	281.59	282.06	281.25	282.06	32974.0
2022-11-30 04:30:00	QQQ	ETF	282.03	282.1	281.28	281.54	25951.0
2022-11-30 05:00:00	QQQ	ETF	281.53	281.69	281.38	281.69	9509.0
2022-11-30 05:30:00	QQQ	ETF	281.66	281.85	281.48	281.57	7014.0
2022-11-30 06:00:00	QQQ	ETF	281.58	281.68	281.34	281.36	4346.0
2022-11-30 06:30:00	QQQ	ETF	281.3	281.86	281.3	281.86	13663.0
2022-11-30 07:00:00	QQQ	ETF	281.78	281.84	281.56	281.64	51916.0
2022-11-30 07:30:00	QQQ	ETF	281.65	281.77	281.43	281.46	67496.0
2022-11-30 08:00:00	QQQ	ETF	281.7613	282.35	280.78	282.01	203475.0
2022-11-30 08:30:00	QQQ	ETF	282.05	282.15	280.47	280.51	397818.0
2022-11-30 09:00:00	QQQ	ETF	280.52	281.32	280.48	280.84	580748.0
2022-11-30 09:30:00	QQQ	ETF	280.84	281.97	280.47	281.5899	3295444.0
2022-11-30 10:00:00	QQQ	ETF	281.59	281.905	280.53	281.35	2546065.0
2022-11-30 10:30:00	QQQ	ETF	281.37	281.4797	280.47	280.7	1759706.0
2022-11-30 11:00:00	QQQ	ETF	280.72	281.448	280.22	281.27	1623549.0
2022-11-30 11:30:00	QQQ	ETF	281.26	281.83	281.08	281.445	1474217.0
2022-11-30 12:00:00	QQQ	ETF	281.445	281.62	279.97	280.43	1749678.0
2022-11-30 12:30:00	QQQ	ETF	280.43	280.94	280.135	280.77	1209211.0

> showing 50 of 28,329 rows — these rows as CSV

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