PREVIEW / etf_30min / 2022-05-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-25.parquet
  size:    672 KB
  rows:    26,309

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-25 04:00:00	SPY	ETF	394.62	394.62	393.35	393.73	47380.0
2022-05-25 04:30:00	SPY	ETF	393.83	394.36	393.79	393.8	11522.0
2022-05-25 05:00:00	SPY	ETF	393.69	393.69	392.71	393.45	25191.0
2022-05-25 05:30:00	SPY	ETF	393.2	394.21	393.13	394.18	9989.0
2022-05-25 06:00:00	SPY	ETF	394.09	394.41	393.97	394.3	20833.0
2022-05-25 06:30:00	SPY	ETF	393.98	394.0	392.91	392.99	53186.0
2022-05-25 07:00:00	SPY	ETF	393.01	393.41	391.62	392.2	183353.0
2022-05-25 07:30:00	SPY	ETF	392.13	392.52	391.39	392.07	326856.0
2022-05-25 08:00:00	SPY	ETF	393.11	396.54	391.37	391.75	242380.0
2022-05-25 08:30:00	SPY	ETF	391.71	392.65	391.17	392.35	187338.0
2022-05-25 09:00:00	SPY	ETF	392.3	392.79	392.04	392.32	381878.0
2022-05-25 09:30:00	SPY	ETF	392.31	395.36	391.89	394.44	6523908.0
2022-05-25 10:00:00	SPY	ETF	394.43	396.49	393.52	396.4	3903460.0
2022-05-25 10:30:00	SPY	ETF	396.38	397.44	395.58	396.3601	4286801.0
2022-05-25 11:00:00	SPY	ETF	396.37	396.48	395.27	395.92	2697196.0
2022-05-25 11:30:00	SPY	ETF	395.91	395.92	394.17	395.15	3213926.0
2022-05-25 12:00:00	SPY	ETF	395.14	395.75	393.18	393.73	2499024.0
2022-05-25 12:30:00	SPY	ETF	393.76	394.53	393.122	394.45	2707170.0
2022-05-25 13:00:00	SPY	ETF	394.44	394.65	393.29	394.43	2057868.0
2022-05-25 13:30:00	SPY	ETF	394.45	395.19	394.205	394.48	2319620.0
2022-05-25 14:00:00	SPY	ETF	394.5	397.07	392.57	396.89	7636131.0
2022-05-25 14:30:00	SPY	ETF	396.91	397.91	396.3	397.655	4712095.0
2022-05-25 15:00:00	SPY	ETF	397.68	399.45	397.46	398.51	5229551.0
2022-05-25 15:30:00	SPY	ETF	398.53	399.02	396.4	397.55	12213421.0
2022-05-25 16:00:00	SPY	ETF	397.55	397.61	395.43	395.99	3952639.0
2022-05-25 16:30:00	SPY	ETF	395.93	396.81	395.81	396.65	361233.0
2022-05-25 17:00:00	SPY	ETF	396.79	396.79	396.57	396.67	31678.0
2022-05-25 17:30:00	SPY	ETF	396.67	396.83	396.67	396.76	38920.0
2022-05-25 18:00:00	SPY	ETF	396.88	397.33	396.81	396.82	79940.0
2022-05-25 18:30:00	SPY	ETF	396.82	397.27	396.8	397.27	29788.0
2022-05-25 19:00:00	SPY	ETF	397.26	397.49	397.2	397.27	50882.0
2022-05-25 19:30:00	SPY	ETF	397.27	397.37	396.56	396.69	69877.0
2022-05-25 04:00:00	QQQ	ETF	289.5	289.5	286.8	287.18	72500.0
2022-05-25 04:30:00	QQQ	ETF	287.23	287.92	287.23	287.41	29465.0
2022-05-25 05:00:00	QQQ	ETF	287.3	287.3	286.17	286.65	36880.0
2022-05-25 05:30:00	QQQ	ETF	286.6	287.68	286.48	287.34	19462.0
2022-05-25 06:00:00	QQQ	ETF	287.4	287.82	287.24	287.68	37337.0
2022-05-25 06:30:00	QQQ	ETF	287.45	287.64	286.53	286.64	53176.0
2022-05-25 07:00:00	QQQ	ETF	286.63	286.94	285.0	285.54	156420.0
2022-05-25 07:30:00	QQQ	ETF	285.5	285.76	284.7	285.23	203984.0
2022-05-25 08:00:00	QQQ	ETF	286.81	289.42	284.71	285.1	456864.0
2022-05-25 08:30:00	QQQ	ETF	285.1	286.21	284.61	285.66	250268.0
2022-05-25 09:00:00	QQQ	ETF	285.71	286.0	285.45	285.66	204768.0
2022-05-25 09:30:00	QQQ	ETF	285.71	289.09	285.5	287.82	8257556.0
2022-05-25 10:00:00	QQQ	ETF	287.82	289.89	286.59	289.8599	5102067.0
2022-05-25 10:30:00	QQQ	ETF	289.85	290.84	288.75	289.62	4009041.0
2022-05-25 11:00:00	QQQ	ETF	289.66	290.19	288.5836	289.42	2295259.0
2022-05-25 11:30:00	QQQ	ETF	289.41	289.61	288.06	289.055	1951749.0
2022-05-25 12:00:00	QQQ	ETF	289.03	289.485	287.52	287.99	1587876.0
2022-05-25 12:30:00	QQQ	ETF	287.99	288.78	287.43	288.67	1519151.0

> showing 50 of 26,309 rows — these rows as CSV

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