PREVIEW / etf_30min / 2022-11-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-16.parquet
  size:    678 KB
  rows:    27,302

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-16 04:00:00	SPY	ETF	398.52	399.33	398.52	398.98	35377.0
2022-11-16 04:30:00	SPY	ETF	398.82	399.5	398.78	399.26	9066.0
2022-11-16 05:00:00	SPY	ETF	399.3	399.99	399.3	399.87	20434.0
2022-11-16 05:30:00	SPY	ETF	399.74	400.03	398.96	399.08	27736.0
2022-11-16 06:00:00	SPY	ETF	399.12	399.2	398.33	399.01	32388.0
2022-11-16 06:30:00	SPY	ETF	398.97	398.97	398.1	398.27	119179.0
2022-11-16 07:00:00	SPY	ETF	398.35	398.6	397.87	398.34	113141.0
2022-11-16 07:30:00	SPY	ETF	398.21	398.66	398.13	398.58	125294.0
2022-11-16 08:00:00	SPY	ETF	398.2498	399.9604	397.87	398.16	496535.0
2022-11-16 08:30:00	SPY	ETF	398.14	398.71	396.5	396.99	596124.0
2022-11-16 09:00:00	SPY	ETF	396.99	397.64	396.54	396.7	474550.0
2022-11-16 09:30:00	SPY	ETF	396.78	397.78	395.73	396.35	5631992.0
2022-11-16 10:00:00	SPY	ETF	396.32	397.06	395.77	396.32	3933246.0
2022-11-16 10:30:00	SPY	ETF	396.3	397.1818	395.185	395.53	2977805.0
2022-11-16 11:00:00	SPY	ETF	395.5	396.65	395.42	396.42	2523979.0
2022-11-16 11:30:00	SPY	ETF	396.41	396.95	396.0	396.5	2166143.0
2022-11-16 12:00:00	SPY	ETF	396.52	396.65	395.7209	396.29	2094418.0
2022-11-16 12:30:00	SPY	ETF	396.3	397.65	396.06	396.71	2281772.0
2022-11-16 13:00:00	SPY	ETF	396.685	396.91	396.2	396.36	1689582.0
2022-11-16 13:30:00	SPY	ETF	396.38	396.55	395.13	395.3	2415255.0
2022-11-16 14:00:00	SPY	ETF	395.26	396.02	395.11	395.8	2422515.0
2022-11-16 14:30:00	SPY	ETF	395.8	396.22	394.93	396.18	3011657.0
2022-11-16 15:00:00	SPY	ETF	396.15	396.27	394.79	395.28	3699213.0
2022-11-16 15:30:00	SPY	ETF	395.285	396.25	394.93	395.51	10562251.0
2022-11-16 16:00:00	SPY	ETF	395.51	396.71	395.2512	396.32	4965792.0
2022-11-16 16:30:00	SPY	ETF	396.3	396.3	395.45	396.04	661865.0
2022-11-16 17:00:00	SPY	ETF	396.01	396.07	395.89	396.05	68928.0
2022-11-16 17:30:00	SPY	ETF	395.96	396.31	395.95	396.3	46310.0
2022-11-16 18:00:00	SPY	ETF	396.28	396.44	396.05	396.19	39394.0
2022-11-16 18:30:00	SPY	ETF	396.13	396.25	396.11	396.2	35557.0
2022-11-16 19:00:00	SPY	ETF	396.25	396.41	396.2	396.33	14192.0
2022-11-16 19:30:00	SPY	ETF	396.25	396.8	396.0201	396.4	38881.0
2022-11-16 04:00:00	QQQ	ETF	289.39	290.03	289.39	289.66	19441.0
2022-11-16 04:30:00	QQQ	ETF	289.69	290.07	289.52	289.9	12366.0
2022-11-16 05:00:00	QQQ	ETF	289.93	290.56	289.9	290.3	27536.0
2022-11-16 05:30:00	QQQ	ETF	290.4	290.4	289.51	289.55	24872.0
2022-11-16 06:00:00	QQQ	ETF	289.5	289.5	288.85	289.39	17952.0
2022-11-16 06:30:00	QQQ	ETF	289.5	289.5	288.85	289.11	64704.0
2022-11-16 07:00:00	QQQ	ETF	289.08	289.25	288.57	289.06	57540.0
2022-11-16 07:30:00	QQQ	ETF	289.0	289.43	288.96	289.42	97585.0
2022-11-16 08:00:00	QQQ	ETF	288.9032	290.4604	288.66	289.09	208625.0
2022-11-16 08:30:00	QQQ	ETF	288.89	289.48	287.5	287.62	850788.0
2022-11-16 09:00:00	QQQ	ETF	287.6	288.25	287.18	287.36	589317.0
2022-11-16 09:30:00	QQQ	ETF	287.39	287.735	285.62	286.44	6140608.0
2022-11-16 10:00:00	QQQ	ETF	286.43	286.77	285.0	285.6684	3527847.0
2022-11-16 10:30:00	QQQ	ETF	285.65	286.5	284.6	284.79	2329676.0
2022-11-16 11:00:00	QQQ	ETF	284.8	286.295	284.72	286.025	2099329.0
2022-11-16 11:30:00	QQQ	ETF	286.03	286.695	285.74	286.06	2230498.0
2022-11-16 12:00:00	QQQ	ETF	286.07	286.31	285.54	286.16	1660659.0
2022-11-16 12:30:00	QQQ	ETF	286.16	287.57	285.95	286.6848	1935193.0

> showing 50 of 27,302 rows — these rows as CSV

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