PREVIEW / etf_30min / 2022-09-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-19.parquet
  size:    649 KB
  rows:    26,118

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-09-19 04:00:00	SPY	ETF	382.87	384.79	382.49	383.55	44111.0
2022-09-19 04:30:00	SPY	ETF	383.55	383.64	382.44	382.55	42689.0
2022-09-19 05:00:00	SPY	ETF	382.59	382.97	382.15	382.4	19798.0
2022-09-19 05:30:00	SPY	ETF	382.3	382.39	381.98	382.29	25875.0
2022-09-19 06:00:00	SPY	ETF	382.24	382.3	381.5	382.11	106461.0
2022-09-19 06:30:00	SPY	ETF	382.1	382.64	382.04	382.48	33378.0
2022-09-19 07:00:00	SPY	ETF	382.61	383.09	382.3	382.3	202176.0
2022-09-19 07:30:00	SPY	ETF	382.3	382.69	381.98	381.99	111231.0
2022-09-19 08:00:00	SPY	ETF	382.45	385.26	381.97	382.51	196479.0
2022-09-19 08:30:00	SPY	ETF	382.51	383.54	382.35	383.11	359295.0
2022-09-19 09:00:00	SPY	ETF	383.14	383.31	382.19	382.26	227342.0
2022-09-19 09:30:00	SPY	ETF	382.26	385.49	382.1784	384.8401	7560699.0
2022-09-19 10:00:00	SPY	ETF	384.8873	385.96	384.03	385.73	4193144.0
2022-09-19 10:30:00	SPY	ETF	385.72	387.16	385.22	386.2099	3825378.0
2022-09-19 11:00:00	SPY	ETF	386.22	387.06	385.16	385.1963	2590138.0
2022-09-19 11:30:00	SPY	ETF	385.19	385.3	384.2	384.525	3027288.0
2022-09-19 12:00:00	SPY	ETF	384.52	385.16	383.895	384.57	1923383.0
2022-09-19 12:30:00	SPY	ETF	384.57	386.31	384.47	386.13	2329349.0
2022-09-19 13:00:00	SPY	ETF	386.13	386.27	385.171	386.08	1706870.0
2022-09-19 13:30:00	SPY	ETF	386.08	386.1	384.9802	385.42	1776759.0
2022-09-19 14:00:00	SPY	ETF	385.44	385.6593	384.67	385.19	2260970.0
2022-09-19 14:30:00	SPY	ETF	385.2	385.92	385.07	385.85	2808579.0
2022-09-19 15:00:00	SPY	ETF	385.87	388.34	385.85	387.98	5773542.0
2022-09-19 15:30:00	SPY	ETF	387.98	388.55	387.46	388.54	8346166.0
2022-09-19 16:00:00	SPY	ETF	388.53	389.37	386.4895	388.61	3364045.0
2022-09-19 16:30:00	SPY	ETF	388.61	389.14	388.58	388.98	569666.0
2022-09-19 17:00:00	SPY	ETF	388.98	389.06	388.55	389.05	140580.0
2022-09-19 17:30:00	SPY	ETF	389.06	389.13	388.94	389.06	26077.0
2022-09-19 18:00:00	SPY	ETF	389.02	389.52	388.88	389.21	119025.0
2022-09-19 18:30:00	SPY	ETF	389.21	389.34	389.13	389.18	17709.0
2022-09-19 19:00:00	SPY	ETF	389.18	389.29	389.08	389.27	30527.0
2022-09-19 19:30:00	SPY	ETF	389.27	389.81	389.27	389.77	50174.0
2022-09-19 04:00:00	QQQ	ETF	287.46	287.96	286.16	286.91	30776.0
2022-09-19 04:30:00	QQQ	ETF	286.91	286.92	285.94	286.07	21565.0
2022-09-19 05:00:00	QQQ	ETF	286.04	286.43	285.75	285.94	41658.0
2022-09-19 05:30:00	QQQ	ETF	285.96	286.2	285.78	286.16	22580.0
2022-09-19 06:00:00	QQQ	ETF	286.09	286.15	285.5	285.93	45135.0
2022-09-19 06:30:00	QQQ	ETF	286.02	286.38	285.89	286.38	34390.0
2022-09-19 07:00:00	QQQ	ETF	286.39	286.65	285.96	285.96	127025.0
2022-09-19 07:30:00	QQQ	ETF	285.99	286.36	285.83	285.83	126301.0
2022-09-19 08:00:00	QQQ	ETF	285.83	288.2	285.6496	286.42	206013.0
2022-09-19 08:30:00	QQQ	ETF	286.44	287.24	286.31	286.83	287761.0
2022-09-19 09:00:00	QQQ	ETF	286.84	287.08	286.06	286.15	206449.0
2022-09-19 09:30:00	QQQ	ETF	286.15	288.8495	286.04	288.45	7014580.0
2022-09-19 10:00:00	QQQ	ETF	288.47	288.96	287.37	288.46	3601715.0
2022-09-19 10:30:00	QQQ	ETF	288.43	289.92	287.95	289.2001	2889324.0
2022-09-19 11:00:00	QQQ	ETF	289.21	289.99	288.15	288.1697	2387161.0
2022-09-19 11:30:00	QQQ	ETF	288.15	288.26	287.33	287.5001	2813280.0
2022-09-19 12:00:00	QQQ	ETF	287.47	287.99	286.845	287.64	1923193.0
2022-09-19 12:30:00	QQQ	ETF	287.6499	289.32	287.575	289.1	1588146.0

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

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