PREVIEW / etf_30min / 2022-05-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-18.parquet
  size:    692 KB
  rows:    27,260

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-05-18 04:00:00	SPY	ETF	406.99	406.99	406.23	406.49	21402.0
2022-05-18 04:30:00	SPY	ETF	406.55	406.65	406.13	406.65	7047.0
2022-05-18 05:00:00	SPY	ETF	406.66	406.89	406.51	406.64	10768.0
2022-05-18 05:30:00	SPY	ETF	406.57	407.45	406.57	407.45	7917.0
2022-05-18 06:00:00	SPY	ETF	407.56	407.68	407.12	407.37	9319.0
2022-05-18 06:30:00	SPY	ETF	406.89	406.89	406.04	406.3	148586.0
2022-05-18 07:00:00	SPY	ETF	406.29	406.4	404.88	404.99	250229.0
2022-05-18 07:30:00	SPY	ETF	405.09	405.4	404.65	404.72	420869.0
2022-05-18 08:00:00	SPY	ETF	406.3301	407.25	404.7	405.6	312568.0
2022-05-18 08:30:00	SPY	ETF	405.5404	405.56	403.49	403.49	466011.0
2022-05-18 09:00:00	SPY	ETF	403.54	403.9	403.13	403.5	489058.0
2022-05-18 09:30:00	SPY	ETF	403.5	403.8	400.87	401.16	5946968.0
2022-05-18 10:00:00	SPY	ETF	401.16	402.12	400.44	400.45	3929526.0
2022-05-18 10:30:00	SPY	ETF	400.44	401.14	399.93	400.77	4100901.0
2022-05-18 11:00:00	SPY	ETF	400.76	400.76	396.09	397.0341	5084704.0
2022-05-18 11:30:00	SPY	ETF	397.04	398.21	396.29	396.5	5022360.0
2022-05-18 12:00:00	SPY	ETF	396.51	396.7899	395.22	395.64	4269650.0
2022-05-18 12:30:00	SPY	ETF	395.64	397.16	395.34	397.05	4002348.0
2022-05-18 13:00:00	SPY	ETF	397.05	397.05	393.941	394.3699	5150826.0
2022-05-18 13:30:00	SPY	ETF	394.36	394.94	392.46	393.01	5760703.0
2022-05-18 14:00:00	SPY	ETF	393.0	393.82	392.33	393.72	5184396.0
2022-05-18 14:30:00	SPY	ETF	393.69	393.89	391.43	391.6851	5649831.0
2022-05-18 15:00:00	SPY	ETF	391.69	392.6839	390.7	390.85	5482123.0
2022-05-18 15:30:00	SPY	ETF	390.86	392.74	390.55	391.93	17861266.0
2022-05-18 16:00:00	SPY	ETF	391.91	392.39	390.25	390.5	6640990.0
2022-05-18 16:30:00	SPY	ETF	390.54	391.25	390.4	391.05	353215.0
2022-05-18 17:00:00	SPY	ETF	390.95	391.21	390.95	391.16	53404.0
2022-05-18 17:30:00	SPY	ETF	391.15	391.42	391.1	391.42	34775.0
2022-05-18 18:00:00	SPY	ETF	391.2	391.61	390.96	391.0	64175.0
2022-05-18 18:30:00	SPY	ETF	391.09	391.52	391.08	391.47	20696.0
2022-05-18 19:00:00	SPY	ETF	391.46	391.47	390.6	390.7	98543.0
2022-05-18 19:30:00	SPY	ETF	390.7	390.87	389.5	389.51	162475.0
2022-05-18 04:00:00	QQQ	ETF	304.66	304.96	303.98	304.24	31967.0
2022-05-18 04:30:00	QQQ	ETF	304.1	304.27	303.75	304.27	13717.0
2022-05-18 05:00:00	QQQ	ETF	304.14	304.5	304.06	304.42	5156.0
2022-05-18 05:30:00	QQQ	ETF	304.14	304.94	304.09	304.94	11766.0
2022-05-18 06:00:00	QQQ	ETF	305.0	305.23	304.77	304.92	25441.0
2022-05-18 06:30:00	QQQ	ETF	304.52	304.52	303.96	304.23	74569.0
2022-05-18 07:00:00	QQQ	ETF	304.28	304.4	302.74	302.83	318823.0
2022-05-18 07:30:00	QQQ	ETF	302.81	303.43	302.58	302.67	224384.0
2022-05-18 08:00:00	QQQ	ETF	303.7899	305.0	302.58	303.31	233979.0
2022-05-18 08:30:00	QQQ	ETF	303.37	303.37	301.43	301.45	461203.0
2022-05-18 09:00:00	QQQ	ETF	301.5	301.92	301.28	301.57	464255.0
2022-05-18 09:30:00	QQQ	ETF	301.54	302.25	299.61	299.8456	6378249.0
2022-05-18 10:00:00	QQQ	ETF	299.84	301.3	299.71	299.79	3747784.0
2022-05-18 10:30:00	QQQ	ETF	299.78	300.26	298.88	299.93	2790645.0
2022-05-18 11:00:00	QQQ	ETF	299.95	299.95	295.95	296.15	3208752.0
2022-05-18 11:30:00	QQQ	ETF	296.15	297.11	295.34	295.4301	4053722.0
2022-05-18 12:00:00	QQQ	ETF	295.46	295.7294	293.97	294.38	3124067.0
2022-05-18 12:30:00	QQQ	ETF	294.4	295.855	294.05	295.81	3858236.0

> showing 50 of 27,260 rows — these rows as CSV

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