PREVIEW / etf_30min / 2023-03-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-13.parquet
  size:    709 KB
  rows:    29,416

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
2023-03-13 04:00:00	SPY	ETF	391.75	391.78	390.39	390.4	86420.0
2023-03-13 04:30:00	SPY	ETF	390.38	390.42	388.0	388.23	159116.0
2023-03-13 05:00:00	SPY	ETF	388.09	388.27	385.95	386.08	100415.0
2023-03-13 05:30:00	SPY	ETF	386.08	387.6	384.83	385.89	224643.0
2023-03-13 06:00:00	SPY	ETF	385.96	387.0	385.3	386.31	256416.0
2023-03-13 06:30:00	SPY	ETF	386.29	388.2	385.63	387.73	209198.0
2023-03-13 07:00:00	SPY	ETF	387.61	389.19	386.2	386.69	704137.0
2023-03-13 07:30:00	SPY	ETF	386.64	387.2	385.78	386.16	632054.0
2023-03-13 08:00:00	SPY	ETF	387.9399	393.25	383.28	384.61	1929824.0
2023-03-13 08:30:00	SPY	ETF	384.6	384.97	380.49	383.04	2201918.0
2023-03-13 09:00:00	SPY	ETF	383.12	384.0	381.36	381.86	1574563.0
2023-03-13 09:30:00	SPY	ETF	381.81	386.28	380.65	385.5664	20235767.0
2023-03-13 10:00:00	SPY	ETF	385.55	387.31	383.65	383.94	12031172.0
2023-03-13 10:30:00	SPY	ETF	383.97	387.85	383.89	387.7	9287123.0
2023-03-13 11:00:00	SPY	ETF	387.72	389.86	387.12	389.65	8370648.0
2023-03-13 11:30:00	SPY	ETF	389.65	389.84	387.31	388.86	7488804.0
2023-03-13 12:00:00	SPY	ETF	388.85	390.39	387.14	387.89	5880556.0
2023-03-13 12:30:00	SPY	ETF	387.89	388.77	386.1	386.62	4808111.0
2023-03-13 13:00:00	SPY	ETF	386.61	387.43	385.36	386.42	5095588.0
2023-03-13 13:30:00	SPY	ETF	386.41	388.11	385.52	387.83	4672754.0
2023-03-13 14:00:00	SPY	ETF	387.88	389.18	387.67	388.43	4497401.0
2023-03-13 14:30:00	SPY	ETF	388.4	389.495	387.68	388.48	4222107.0
2023-03-13 15:00:00	SPY	ETF	388.49	388.9	385.51	385.95	5865871.0
2023-03-13 15:30:00	SPY	ETF	385.95	387.72	385.045	385.29	12633259.0
2023-03-13 16:00:00	SPY	ETF	385.28	386.21	385.11	385.55	3853060.0
2023-03-13 16:30:00	SPY	ETF	385.56	386.15	385.52	386.0	441180.0
2023-03-13 17:00:00	SPY	ETF	385.93	386.08	385.82	385.95	37120.0
2023-03-13 17:30:00	SPY	ETF	385.87	386.05	385.36	386.03	12554.0
2023-03-13 18:00:00	SPY	ETF	386.02	386.55	385.317	386.55	113352.0
2023-03-13 18:30:00	SPY	ETF	386.56	386.65	386.29	386.62	33695.0
2023-03-13 19:00:00	SPY	ETF	386.58	386.59	385.75	385.89	28539.0
2023-03-13 19:30:00	SPY	ETF	385.85	386.3	385.71	385.73	65896.0
2023-03-13 04:00:00	QQQ	ETF	293.26	297.1	292.39	292.46	101325.0
2023-03-13 04:30:00	QQQ	ETF	292.39	292.41	290.56	290.67	187852.0
2023-03-13 05:00:00	QQQ	ETF	290.67	290.87	289.19	289.54	242803.0
2023-03-13 05:30:00	QQQ	ETF	289.5	291.23	288.96	289.8	206858.0
2023-03-13 06:00:00	QQQ	ETF	290.17	290.63	289.22	290.17	86459.0
2023-03-13 06:30:00	QQQ	ETF	290.17	292.06	289.62	291.78	124137.0
2023-03-13 07:00:00	QQQ	ETF	291.51	292.48	290.7	291.05	397291.0
2023-03-13 07:30:00	QQQ	ETF	291.11	291.49	290.11	290.68	311082.0
2023-03-13 08:00:00	QQQ	ETF	290.68	294.68	288.766	289.47	826405.0
2023-03-13 08:30:00	QQQ	ETF	289.4	289.68	284.73	287.08	1350930.0
2023-03-13 09:00:00	QQQ	ETF	287.08	288.44	286.13	286.7	1095867.0
2023-03-13 09:30:00	QQQ	ETF	286.73	290.485	285.19	289.68	11310109.0
2023-03-13 10:00:00	QQQ	ETF	289.64	291.135	288.68	289.03	6951677.0
2023-03-13 10:30:00	QQQ	ETF	289.06	291.37	288.6	291.1001	6904003.0
2023-03-13 11:00:00	QQQ	ETF	291.1001	293.57	290.77	293.42	6503936.0
2023-03-13 11:30:00	QQQ	ETF	293.44	293.93	291.9102	293.28	5788026.0
2023-03-13 12:00:00	QQQ	ETF	293.29	294.33	292.04	292.69	3813919.0
2023-03-13 12:30:00	QQQ	ETF	292.67	293.62	291.44	291.85	4241697.0

> showing 50 of 29,416 rows — these rows as CSV

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