PREVIEW / etf_30min / 2022-11-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-18.parquet
  size:    670 KB
  rows:    26,714

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-11-18 04:00:00	SPY	ETF	394.49	395.77	394.38	395.7	34401.0
2022-11-18 04:30:00	SPY	ETF	395.74	396.2	395.42	395.42	26689.0
2022-11-18 05:00:00	SPY	ETF	395.36	396.09	395.22	395.81	22850.0
2022-11-18 05:30:00	SPY	ETF	395.75	396.92	395.72	396.82	22561.0
2022-11-18 06:00:00	SPY	ETF	396.98	397.01	396.47	396.52	53348.0
2022-11-18 06:30:00	SPY	ETF	396.8	396.85	396.42	396.72	64018.0
2022-11-18 07:00:00	SPY	ETF	396.64	397.52	396.59	397.23	167148.0
2022-11-18 07:30:00	SPY	ETF	397.25	397.26	396.83	396.95	122467.0
2022-11-18 08:00:00	SPY	ETF	397.32	398.07	393.3	397.86	419467.0
2022-11-18 08:30:00	SPY	ETF	397.86	397.87	397.43	397.8	131893.0
2022-11-18 09:00:00	SPY	ETF	397.8	398.09	397.02	397.7	458957.0
2022-11-18 09:30:00	SPY	ETF	397.73	397.81	395.56	395.785	6930716.0
2022-11-18 10:00:00	SPY	ETF	395.82	395.9899	394.35	395.36	5164838.0
2022-11-18 10:30:00	SPY	ETF	395.4	395.705	394.25	394.58	2954196.0
2022-11-18 11:00:00	SPY	ETF	394.59	395.86	394.05	395.5	3179094.0
2022-11-18 11:30:00	SPY	ETF	395.5	395.99	394.48	395.14	2276117.0
2022-11-18 12:00:00	SPY	ETF	395.12	395.31	393.04	393.895	3188351.0
2022-11-18 12:30:00	SPY	ETF	393.89	394.18	393.13	393.835	1826044.0
2022-11-18 13:00:00	SPY	ETF	393.83	394.78	393.67	394.7	2357832.0
2022-11-18 13:30:00	SPY	ETF	394.71	394.86	393.38	393.89	2271736.0
2022-11-18 14:00:00	SPY	ETF	393.8818	394.7	393.82	394.43	2625197.0
2022-11-18 14:30:00	SPY	ETF	394.435	394.815	393.98	394.7	2182188.0
2022-11-18 15:00:00	SPY	ETF	394.71	395.91	394.64	395.8955	4481028.0
2022-11-18 15:30:00	SPY	ETF	395.9	397.01	395.155	396.09	13228340.0
2022-11-18 16:00:00	SPY	ETF	396.08	396.21	395.39	396.06	6129876.0
2022-11-18 16:30:00	SPY	ETF	396.05	396.05	395.7	396.03	388227.0
2022-11-18 17:00:00	SPY	ETF	396.04	396.33	395.8	396.0	100186.0
2022-11-18 17:30:00	SPY	ETF	396.06	396.14	395.89	395.95	25686.0
2022-11-18 18:00:00	SPY	ETF	395.89	395.99	395.75	395.75	26153.0
2022-11-18 18:30:00	SPY	ETF	395.75	396.25	395.75	396.06	43999.0
2022-11-18 19:00:00	SPY	ETF	396.03	396.05	395.8	395.87	20115.0
2022-11-18 19:30:00	SPY	ETF	396.03	396.25	395.92	396.25	41854.0
2022-11-18 04:00:00	QQQ	ETF	285.01	286.0	284.94	286.0	51192.0
2022-11-18 04:30:00	QQQ	ETF	285.98	286.41	285.86	285.86	24742.0
2022-11-18 05:00:00	QQQ	ETF	285.72	286.39	285.59	286.0	33354.0
2022-11-18 05:30:00	QQQ	ETF	286.16	287.31	286.06	287.17	25435.0
2022-11-18 06:00:00	QQQ	ETF	287.31	287.4	286.86	287.09	33086.0
2022-11-18 06:30:00	QQQ	ETF	287.09	287.18	286.76	287.08	18140.0
2022-11-18 07:00:00	QQQ	ETF	286.96	287.81	286.91	287.52	216089.0
2022-11-18 07:30:00	QQQ	ETF	287.51	287.55	287.15	287.21	63609.0
2022-11-18 08:00:00	QQQ	ETF	287.4401	287.96	284.1	287.8	271467.0
2022-11-18 08:30:00	QQQ	ETF	287.76	287.8	287.27	287.77	119668.0
2022-11-18 09:00:00	QQQ	ETF	287.74	288.0	287.43	287.9	252962.0
2022-11-18 09:30:00	QQQ	ETF	287.89	287.99	285.43	285.861	5101574.0
2022-11-18 10:00:00	QQQ	ETF	285.88	285.97	284.0	284.86	3741648.0
2022-11-18 10:30:00	QQQ	ETF	284.9	285.2399	283.51	283.905	2279465.0
2022-11-18 11:00:00	QQQ	ETF	283.92	284.8981	283.26	284.52	2159301.0
2022-11-18 11:30:00	QQQ	ETF	284.52	284.98	283.53	284.12	1596710.0
2022-11-18 12:00:00	QQQ	ETF	284.12	284.3399	282.3211	283.0471	2254433.0
2022-11-18 12:30:00	QQQ	ETF	283.04	283.35	282.43	282.95	1358884.0

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

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