PREVIEW / etf_30min / 2022-05-20

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-20.parquet
  size:    688 KB
  rows:    27,319

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-20 04:00:00	SPY	ETF	389.5	393.66	389.5	393.66	28448.0
2022-05-20 04:30:00	SPY	ETF	393.8	394.32	393.8	393.9	29634.0
2022-05-20 05:00:00	SPY	ETF	393.7	394.66	393.67	394.31	14930.0
2022-05-20 05:30:00	SPY	ETF	394.23	394.28	393.5	393.74	14097.0
2022-05-20 06:00:00	SPY	ETF	393.6	394.1	393.56	394.05	11699.0
2022-05-20 06:30:00	SPY	ETF	393.92	394.0	393.52	393.57	62788.0
2022-05-20 07:00:00	SPY	ETF	393.66	393.69	392.63	393.37	208216.0
2022-05-20 07:30:00	SPY	ETF	393.39	394.57	393.39	393.98	135774.0
2022-05-20 08:00:00	SPY	ETF	394.58	394.58	391.6	393.83	386609.0
2022-05-20 08:30:00	SPY	ETF	393.83	393.97	392.66	393.31	204802.0
2022-05-20 09:00:00	SPY	ETF	393.29	393.99	393.06	393.25	404767.0
2022-05-20 09:30:00	SPY	ETF	393.25	397.03	391.66	392.76	6226956.0
2022-05-20 10:00:00	SPY	ETF	392.75	393.28	389.85	391.06	4977524.0
2022-05-20 10:30:00	SPY	ETF	391.08	391.16	387.47	387.561	3759268.0
2022-05-20 11:00:00	SPY	ETF	387.56	389.02	385.48	386.57	6034840.0
2022-05-20 11:30:00	SPY	ETF	386.56	387.4499	385.93	386.2	3306722.0
2022-05-20 12:00:00	SPY	ETF	386.2	386.3625	383.57	384.44	5592201.0
2022-05-20 12:30:00	SPY	ETF	384.445	384.87	381.87	382.97	6614431.0
2022-05-20 13:00:00	SPY	ETF	382.94	383.03	380.6	380.66	5310099.0
2022-05-20 13:30:00	SPY	ETF	380.655	384.07	380.54	383.46	6249258.0
2022-05-20 14:00:00	SPY	ETF	383.48	383.8	381.62	382.39	4747888.0
2022-05-20 14:30:00	SPY	ETF	382.3801	384.82	381.38	383.51	5730463.0
2022-05-20 15:00:00	SPY	ETF	383.55	385.28	382.36	385.27	5398227.0
2022-05-20 15:30:00	SPY	ETF	385.25	389.9303	384.47	389.6	21042664.0
2022-05-20 16:00:00	SPY	ETF	389.59	390.27	388.96	389.6	5551153.0
2022-05-20 16:30:00	SPY	ETF	389.64	390.11	389.55	389.95	963425.0
2022-05-20 17:00:00	SPY	ETF	389.95	390.05	389.84	390.0	125417.0
2022-05-20 17:30:00	SPY	ETF	390.0	390.17	389.96	390.05	57782.0
2022-05-20 18:00:00	SPY	ETF	390.1	390.26	390.0	390.15	54847.0
2022-05-20 18:30:00	SPY	ETF	390.19	390.47	390.15	390.43	12640.0
2022-05-20 19:00:00	SPY	ETF	390.42	390.54	389.63	390.34	117512.0
2022-05-20 19:30:00	SPY	ETF	390.37	391.0	390.32	390.62	28668.0
2022-05-20 04:00:00	QQQ	ETF	293.78	294.23	292.66	294.23	94227.0
2022-05-20 04:30:00	QQQ	ETF	294.23	294.69	294.16	294.17	34949.0
2022-05-20 05:00:00	QQQ	ETF	294.07	294.89	293.98	294.41	17076.0
2022-05-20 05:30:00	QQQ	ETF	294.3	294.3	293.71	293.89	67394.0
2022-05-20 06:00:00	QQQ	ETF	293.91	294.26	293.8	294.23	46613.0
2022-05-20 06:30:00	QQQ	ETF	294.12	294.12	293.51	293.55	26209.0
2022-05-20 07:00:00	QQQ	ETF	293.63	293.77	293.2	293.5	194631.0
2022-05-20 07:30:00	QQQ	ETF	293.57	294.59	293.57	294.02	264606.0
2022-05-20 08:00:00	QQQ	ETF	294.81	294.81	289.363	293.8	484496.0
2022-05-20 08:30:00	QQQ	ETF	293.8	293.93	292.75	293.29	269211.0
2022-05-20 09:00:00	QQQ	ETF	293.3	293.78	293.0	293.11	546014.0
2022-05-20 09:30:00	QQQ	ETF	293.13	293.8	291.23	292.44	6858416.0
2022-05-20 10:00:00	QQQ	ETF	292.44	292.8	289.56	291.235	4328860.0
2022-05-20 10:30:00	QQQ	ETF	291.24	291.38	287.5801	287.74	3488599.0
2022-05-20 11:00:00	QQQ	ETF	287.75	288.15	285.601	286.7881	4271001.0
2022-05-20 11:30:00	QQQ	ETF	286.775	287.5	286.08	286.12	2770199.0
2022-05-20 12:00:00	QQQ	ETF	286.09	286.31	283.52	283.8967	3793723.0
2022-05-20 12:30:00	QQQ	ETF	283.88	284.3	281.2401	282.2823	5098006.0

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

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