PREVIEW / etf_30min / 2022-05-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-12.parquet
  size:    716 KB
  rows:    28,571

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-12 04:00:00	SPY	ETF	392.49	392.49	390.43	390.96	45505.0
2022-05-12 04:30:00	SPY	ETF	390.93	391.51	389.35	390.05	66640.0
2022-05-12 05:00:00	SPY	ETF	390.1	390.35	389.48	389.86	44925.0
2022-05-12 05:30:00	SPY	ETF	389.64	390.47	388.81	389.8	54572.0
2022-05-12 06:00:00	SPY	ETF	389.73	390.89	389.53	390.8	56966.0
2022-05-12 06:30:00	SPY	ETF	390.89	391.19	389.76	390.93	32129.0
2022-05-12 07:00:00	SPY	ETF	390.91	392.09	390.42	391.32	320027.0
2022-05-12 07:30:00	SPY	ETF	391.28	391.32	388.14	388.57	385203.0
2022-05-12 08:00:00	SPY	ETF	388.47	392.85	388.21	389.2	327176.0
2022-05-12 08:30:00	SPY	ETF	389.02	390.41	388.03	389.56	488144.0
2022-05-12 09:00:00	SPY	ETF	389.68	390.7	389.1	389.35	377048.0
2022-05-12 09:30:00	SPY	ETF	389.37	391.28	386.92	388.6	12575440.0
2022-05-12 10:00:00	SPY	ETF	388.58	393.74	387.33	391.9898	9186583.0
2022-05-12 10:30:00	SPY	ETF	392.04	394.24	390.78	394.02	5825013.0
2022-05-12 11:00:00	SPY	ETF	394.03	395.8	392.58	392.9859	5451773.0
2022-05-12 11:30:00	SPY	ETF	393.01	393.35	388.66	388.697	5976903.0
2022-05-12 12:00:00	SPY	ETF	388.68	390.83	388.16	390.5099	5289170.0
2022-05-12 12:30:00	SPY	ETF	390.51	392.36	389.79	390.47	4050664.0
2022-05-12 13:00:00	SPY	ETF	390.44	391.1	388.67	389.34	2988318.0
2022-05-12 13:30:00	SPY	ETF	389.29	389.7617	386.34	387.04	4189919.0
2022-05-12 14:00:00	SPY	ETF	387.0	387.96	386.02	386.96	4804550.0
2022-05-12 14:30:00	SPY	ETF	386.9	387.17	385.15	385.7349	4830120.0
2022-05-12 15:00:00	SPY	ETF	385.75	390.35	385.37	388.17	9125824.0
2022-05-12 15:30:00	SPY	ETF	388.11	392.58	388.09	392.41	13840158.0
2022-05-12 16:00:00	SPY	ETF	392.38	392.6	391.66	392.05	4122611.0
2022-05-12 16:30:00	SPY	ETF	392.11	392.34	390.15	390.6	558903.0
2022-05-12 17:00:00	SPY	ETF	390.79	392.34	390.56	391.24	123697.0
2022-05-12 17:30:00	SPY	ETF	391.22	391.3	391.16	391.25	32580.0
2022-05-12 18:00:00	SPY	ETF	391.27	392.04	391.25	392.04	161641.0
2022-05-12 18:30:00	SPY	ETF	392.13	392.14	391.65	391.9	48749.0
2022-05-12 19:00:00	SPY	ETF	391.96	393.22	391.86	392.99	90796.0
2022-05-12 19:30:00	SPY	ETF	393.02	394.0	392.94	393.85	81520.0
2022-05-12 04:00:00	QQQ	ETF	290.78	291.0	289.15	289.49	77990.0
2022-05-12 04:30:00	QQQ	ETF	289.63	290.12	288.0	288.51	77354.0
2022-05-12 05:00:00	QQQ	ETF	288.53	288.92	288.02	288.32	65307.0
2022-05-12 05:30:00	QQQ	ETF	288.25	289.05	287.5	288.5	76935.0
2022-05-12 06:00:00	QQQ	ETF	288.44	289.35	288.22	289.35	40759.0
2022-05-12 06:30:00	QQQ	ETF	289.33	289.47	288.25	289.26	78916.0
2022-05-12 07:00:00	QQQ	ETF	289.26	290.45	288.84	289.44	252021.0
2022-05-12 07:30:00	QQQ	ETF	289.48	289.52	286.6	286.83	585244.0
2022-05-12 08:00:00	QQQ	ETF	286.79	292.45	286.64	287.19	498574.0
2022-05-12 08:30:00	QQQ	ETF	287.09	288.5	286.65	287.5	622902.0
2022-05-12 09:00:00	QQQ	ETF	287.47	288.72	287.04	287.43	727757.0
2022-05-12 09:30:00	QQQ	ETF	287.45	290.25	285.04	287.53	15358889.0
2022-05-12 10:00:00	QQQ	ETF	287.49	293.66	286.26	292.11	11604843.0
2022-05-12 10:30:00	QQQ	ETF	292.12	294.61	290.47	294.36	7117587.0
2022-05-12 11:00:00	QQQ	ETF	294.38	295.75	293.0	293.43	5077052.0
2022-05-12 11:30:00	QQQ	ETF	293.44	293.82	288.75	288.78	5924986.0
2022-05-12 12:00:00	QQQ	ETF	288.78	290.61	287.91	290.2	5512926.0
2022-05-12 12:30:00	QQQ	ETF	290.185	292.12	289.65	290.31	3654615.0

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

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