PREVIEW / etf_30min / 2022-07-11

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-11.parquet
  size:    639 KB
  rows:    25,601

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-07-11 04:00:00	SPY	ETF	385.86	386.57	385.63	386.27	39113.0
2022-07-11 04:30:00	SPY	ETF	386.25	386.5	386.15	386.19	15846.0
2022-07-11 05:00:00	SPY	ETF	386.05	386.77	386.05	386.5	5090.0
2022-07-11 05:30:00	SPY	ETF	386.37	386.5	386.24	386.24	4462.0
2022-07-11 06:00:00	SPY	ETF	386.27	387.06	386.07	386.78	22131.0
2022-07-11 06:30:00	SPY	ETF	386.7	386.82	386.4	386.53	12018.0
2022-07-11 07:00:00	SPY	ETF	386.59	386.98	386.23	386.35	78099.0
2022-07-11 07:30:00	SPY	ETF	386.45	386.52	385.67	385.83	78886.0
2022-07-11 08:00:00	SPY	ETF	386.88	386.95	385.62	386.3	126766.0
2022-07-11 08:30:00	SPY	ETF	386.19	386.33	385.49	386.07	146026.0
2022-07-11 09:00:00	SPY	ETF	386.06	386.3	385.8	385.86	216342.0
2022-07-11 09:30:00	SPY	ETF	385.85	386.87	383.67	384.6301	6696745.0
2022-07-11 10:00:00	SPY	ETF	384.655	385.06	383.66	384.29	4674400.0
2022-07-11 10:30:00	SPY	ETF	384.31	385.54	384.09	384.1	3103738.0
2022-07-11 11:00:00	SPY	ETF	384.11	385.26	384.01	385.05	2100430.0
2022-07-11 11:30:00	SPY	ETF	385.055	385.37	384.04	384.59	2144384.0
2022-07-11 12:00:00	SPY	ETF	384.59	384.96	384.24	384.7	1528372.0
2022-07-11 12:30:00	SPY	ETF	384.71	385.245	384.48	385.0299	1700904.0
2022-07-11 13:00:00	SPY	ETF	385.02	386.22	384.91	386.12	2326635.0
2022-07-11 13:30:00	SPY	ETF	386.12	386.82	386.05	386.415	2033315.0
2022-07-11 14:00:00	SPY	ETF	386.4	386.47	385.22	385.3	2435069.0
2022-07-11 14:30:00	SPY	ETF	385.3	385.73	384.59	384.59	2399919.0
2022-07-11 15:00:00	SPY	ETF	384.59	384.76	383.87	384.26	3238336.0
2022-07-11 15:30:00	SPY	ETF	384.27	384.53	383.5	384.28	7195251.0
2022-07-11 16:00:00	SPY	ETF	384.29	384.87	384.23	384.75	3175097.0
2022-07-11 16:30:00	SPY	ETF	384.75	384.85	384.59	384.65	141307.0
2022-07-11 17:00:00	SPY	ETF	384.65	384.66	384.51	384.64	18635.0
2022-07-11 17:30:00	SPY	ETF	384.62	384.8	384.23	384.65	70722.0
2022-07-11 18:00:00	SPY	ETF	384.66	384.67	384.35	384.56	33871.0
2022-07-11 18:30:00	SPY	ETF	384.57	384.62	384.01	384.18	47896.0
2022-07-11 19:00:00	SPY	ETF	384.08	384.6	384.08	384.57	24605.0
2022-07-11 19:30:00	SPY	ETF	384.6	385.0	384.53	384.84	56024.0
2022-07-11 04:00:00	QQQ	ETF	293.0	293.38	292.56	293.1	40649.0
2022-07-11 04:30:00	QQQ	ETF	293.08	293.38	292.88	293.0	35175.0
2022-07-11 05:00:00	QQQ	ETF	292.96	293.46	292.85	293.23	36862.0
2022-07-11 05:30:00	QQQ	ETF	293.1	293.16	292.88	292.88	18967.0
2022-07-11 06:00:00	QQQ	ETF	292.81	293.64	292.74	293.26	68946.0
2022-07-11 06:30:00	QQQ	ETF	293.2	293.43	293.0	293.11	12090.0
2022-07-11 07:00:00	QQQ	ETF	293.2	293.56	293.04	293.13	79536.0
2022-07-11 07:30:00	QQQ	ETF	293.11	293.26	292.54	292.73	123843.0
2022-07-11 08:00:00	QQQ	ETF	293.48	295.571	292.21	293.12	160873.0
2022-07-11 08:30:00	QQQ	ETF	293.2798	293.34	292.69	293.31	142635.0
2022-07-11 09:00:00	QQQ	ETF	293.3	293.47	292.8	292.82	244991.0
2022-07-11 09:30:00	QQQ	ETF	292.84	293.11	288.2	288.91	7392681.0
2022-07-11 10:00:00	QQQ	ETF	288.91	289.84	288.14	289.6	4096740.0
2022-07-11 10:30:00	QQQ	ETF	289.61	290.905	289.47	289.4799	3195969.0
2022-07-11 11:00:00	QQQ	ETF	289.47	290.72	289.28	290.17	2058158.0
2022-07-11 11:30:00	QQQ	ETF	290.15	290.44	289.21	289.67	1791757.0
2022-07-11 12:00:00	QQQ	ETF	289.64	290.26	289.31	289.94	1269550.0
2022-07-11 12:30:00	QQQ	ETF	289.95	290.38	289.51	290.0	1185413.0

> showing 50 of 25,601 rows — these rows as CSV

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