PREVIEW / etf_30min / 2022-11-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-04.parquet
  size:    684 KB
  rows:    27,867

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-04 04:00:00	SPY	ETF	371.76	372.83	371.5	372.35	30194.0
2022-11-04 04:30:00	SPY	ETF	372.18	372.96	372.11	372.96	14200.0
2022-11-04 05:00:00	SPY	ETF	373.0	374.1	372.81	373.75	52169.0
2022-11-04 05:30:00	SPY	ETF	373.68	373.85	373.53	373.63	21923.0
2022-11-04 06:00:00	SPY	ETF	373.47	373.93	373.27	373.81	17092.0
2022-11-04 06:30:00	SPY	ETF	373.87	374.44	373.84	374.17	56103.0
2022-11-04 07:00:00	SPY	ETF	374.17	374.95	373.77	373.79	243671.0
2022-11-04 07:30:00	SPY	ETF	373.78	374.31	373.56	374.22	150140.0
2022-11-04 08:00:00	SPY	ETF	373.92	374.49	371.35	373.05	508836.0
2022-11-04 08:30:00	SPY	ETF	373.45	375.77	368.99	375.64	2397627.0
2022-11-04 09:00:00	SPY	ETF	375.6	377.05	375.57	377.0	972523.0
2022-11-04 09:30:00	SPY	ETF	377.0	377.37	372.225	375.1	8659905.0
2022-11-04 10:00:00	SPY	ETF	375.11	378.09	374.7	377.6699	6565335.0
2022-11-04 10:30:00	SPY	ETF	377.67	378.87	376.4	376.8	4445465.0
2022-11-04 11:00:00	SPY	ETF	376.83	377.43	374.11	374.26	3723273.0
2022-11-04 11:30:00	SPY	ETF	374.275	374.8602	370.8005	370.97	5493349.0
2022-11-04 12:00:00	SPY	ETF	370.98	373.01	370.07	372.7196	5648775.0
2022-11-04 12:30:00	SPY	ETF	372.73	372.96	370.73	371.2797	3055521.0
2022-11-04 13:00:00	SPY	ETF	371.29	372.08	370.14	371.13	3268911.0
2022-11-04 13:30:00	SPY	ETF	371.1399	371.59	370.55	370.76	2424365.0
2022-11-04 14:00:00	SPY	ETF	370.77	372.56	370.0	372.24	3689213.0
2022-11-04 14:30:00	SPY	ETF	372.23	374.2	371.88	373.96	3999665.0
2022-11-04 15:00:00	SPY	ETF	373.97	375.245	373.6	374.51	4789679.0
2022-11-04 15:30:00	SPY	ETF	374.53	376.47	374.03	376.34	11492701.0
2022-11-04 16:00:00	SPY	ETF	376.34	376.82	375.76	375.99	8870176.0
2022-11-04 16:30:00	SPY	ETF	375.96	376.35	375.42	375.61	294732.0
2022-11-04 17:00:00	SPY	ETF	375.63	376.35	375.5	375.9	109589.0
2022-11-04 17:30:00	SPY	ETF	375.91	375.95	375.74	375.9	18757.0
2022-11-04 18:00:00	SPY	ETF	375.81	375.81	375.58	375.67	12492.0
2022-11-04 18:30:00	SPY	ETF	375.67	376.15	375.62	375.88	15463.0
2022-11-04 19:00:00	SPY	ETF	375.87	375.92	375.75	375.89	4270.0
2022-11-04 19:30:00	SPY	ETF	375.85	376.0	375.67	376.0	15528.0
2022-11-04 04:00:00	QQQ	ETF	261.21	262.06	261.2	261.65	49872.0
2022-11-04 04:30:00	QQQ	ETF	261.69	262.1	261.41	262.1	22442.0
2022-11-04 05:00:00	QQQ	ETF	262.14	263.04	262.05	262.66	51481.0
2022-11-04 05:30:00	QQQ	ETF	262.7	262.71	262.41	262.52	26672.0
2022-11-04 06:00:00	QQQ	ETF	262.5	262.83	262.25	262.6	30577.0
2022-11-04 06:30:00	QQQ	ETF	262.62	263.04	262.62	262.83	68763.0
2022-11-04 07:00:00	QQQ	ETF	262.82	263.45	262.49	262.57	310049.0
2022-11-04 07:30:00	QQQ	ETF	262.57	262.84	262.32	262.74	148806.0
2022-11-04 08:00:00	QQQ	ETF	262.61	263.28	260.685	262.0	449897.0
2022-11-04 08:30:00	QQQ	ETF	262.2	264.23	258.51	264.06	2644110.0
2022-11-04 09:00:00	QQQ	ETF	264.06	265.65	264.06	265.53	1499244.0
2022-11-04 09:30:00	QQQ	ETF	265.52	266.39	260.57	263.46	9532208.0
2022-11-04 10:00:00	QQQ	ETF	263.48	265.92	262.5615	265.38	5963097.0
2022-11-04 10:30:00	QQQ	ETF	265.39	266.61	264.0	264.55	4303202.0
2022-11-04 11:00:00	QQQ	ETF	264.56	264.95	262.56	262.73	3409941.0
2022-11-04 11:30:00	QQQ	ETF	262.75	263.11	259.98	260.08	4532773.0
2022-11-04 12:00:00	QQQ	ETF	260.09	262.28	259.44	261.91	4491374.0
2022-11-04 12:30:00	QQQ	ETF	261.89	262.18	259.9	260.3101	2498670.0

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

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