PREVIEW / etf_30min / 2022-11-15

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-15.parquet
  size:    702 KB
  rows:    28,528

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-15 04:00:00	SPY	ETF	397.67	397.91	397.39	397.5	57995.0
2022-11-15 04:30:00	SPY	ETF	397.62	397.79	397.36	397.75	22900.0
2022-11-15 05:00:00	SPY	ETF	397.73	398.41	397.73	397.85	19770.0
2022-11-15 05:30:00	SPY	ETF	397.89	398.0	397.73	397.95	28404.0
2022-11-15 06:00:00	SPY	ETF	397.94	398.3	397.69	397.9	53692.0
2022-11-15 06:30:00	SPY	ETF	397.88	398.07	397.54	398.05	95461.0
2022-11-15 07:00:00	SPY	ETF	398.07	399.11	397.68	398.92	229579.0
2022-11-15 07:30:00	SPY	ETF	398.95	399.15	398.85	399.05	158598.0
2022-11-15 08:00:00	SPY	ETF	398.0	399.69	396.8	399.3	567443.0
2022-11-15 08:30:00	SPY	ETF	399.31	403.54	399.31	402.43	1912232.0
2022-11-15 09:00:00	SPY	ETF	402.35	402.48	401.0	401.11	794896.0
2022-11-15 09:30:00	SPY	ETF	401.15	402.31	399.97	401.62	6549932.0
2022-11-15 10:00:00	SPY	ETF	401.63	402.17	400.22	401.6	3816602.0
2022-11-15 10:30:00	SPY	ETF	401.575	401.9	399.83	400.27	3430374.0
2022-11-15 11:00:00	SPY	ETF	400.25	400.8	399.35	400.22	2854341.0
2022-11-15 11:30:00	SPY	ETF	400.205	401.565	400.205	401.2	3034937.0
2022-11-15 12:00:00	SPY	ETF	401.2	401.32	399.95	400.0001	2257822.0
2022-11-15 12:30:00	SPY	ETF	399.99	400.55	399.41	399.9986	1901025.0
2022-11-15 13:00:00	SPY	ETF	400.0	400.29	395.93	396.33	6470187.0
2022-11-15 13:30:00	SPY	ETF	396.31	397.4	394.49	396.47	8873171.0
2022-11-15 14:00:00	SPY	ETF	396.475	398.975	394.93	398.355	8034382.0
2022-11-15 14:30:00	SPY	ETF	398.385	399.16	397.27	398.71	3772348.0
2022-11-15 15:00:00	SPY	ETF	398.68	399.52	398.13	398.913	4143427.0
2022-11-15 15:30:00	SPY	ETF	398.93	399.27	397.46	398.54	7935077.0
2022-11-15 16:00:00	SPY	ETF	398.54	399.04	397.82	398.07	5991305.0
2022-11-15 16:30:00	SPY	ETF	398.0501	398.1	397.64	397.98	371270.0
2022-11-15 17:00:00	SPY	ETF	398.01	398.08	397.8	397.83	43515.0
2022-11-15 17:30:00	SPY	ETF	397.88	397.8996	397.75	397.75	10469.0
2022-11-15 18:00:00	SPY	ETF	397.79	397.8	396.91	397.45	173788.0
2022-11-15 18:30:00	SPY	ETF	397.49	398.08	397.38	397.99	91116.0
2022-11-15 19:00:00	SPY	ETF	398.07	398.1	396.88	396.94	69322.0
2022-11-15 19:30:00	SPY	ETF	396.92	397.43	396.57	396.65	83779.0
2022-11-15 04:00:00	QQQ	ETF	287.86	288.28	287.72	287.81	39366.0
2022-11-15 04:30:00	QQQ	ETF	287.95	288.24	287.82	288.17	16762.0
2022-11-15 05:00:00	QQQ	ETF	288.16	288.7	288.16	288.4	38127.0
2022-11-15 05:30:00	QQQ	ETF	288.39	288.66	288.35	288.52	82430.0
2022-11-15 06:00:00	QQQ	ETF	288.7	288.83	288.42	288.5	27757.0
2022-11-15 06:30:00	QQQ	ETF	288.54	288.72	288.26	288.7	28903.0
2022-11-15 07:00:00	QQQ	ETF	288.7	289.59	288.21	289.52	133327.0
2022-11-15 07:30:00	QQQ	ETF	289.45	289.69	289.351	289.61	116496.0
2022-11-15 08:00:00	QQQ	ETF	288.56	290.32	285.654	289.97	553041.0
2022-11-15 08:30:00	QQQ	ETF	289.95	294.56	289.95	293.48	2721943.0
2022-11-15 09:00:00	QQQ	ETF	293.52	293.58	292.1	292.25	1187696.0
2022-11-15 09:30:00	QQQ	ETF	292.21	293.26	290.815	292.455	6873216.0
2022-11-15 10:00:00	QQQ	ETF	292.45	293.01	291.55	292.68	3818627.0
2022-11-15 10:30:00	QQQ	ETF	292.67	292.92	290.76	291.28	2800021.0
2022-11-15 11:00:00	QQQ	ETF	291.35	291.86	290.31	291.25	2681976.0
2022-11-15 11:30:00	QQQ	ETF	291.27	292.74	291.27	292.59	2842234.0
2022-11-15 12:00:00	QQQ	ETF	292.59	292.64	291.49	291.565	2132041.0
2022-11-15 12:30:00	QQQ	ETF	291.57	291.94	290.99	291.41	1775095.0

> showing 50 of 28,528 rows — these rows as CSV

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