PREVIEW / etf_30min / 2002-01-18

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-01-18.parquet
  size:    17 KB
  rows:    454

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
2002-01-18 09:30:00	SPY	ETF	113.0	113.43	113.0	113.23	2862100.0
2002-01-18 10:00:00	SPY	ETF	113.27	113.56	113.09	113.45	1994000.0
2002-01-18 10:30:00	SPY	ETF	113.45	113.85	113.35	113.47	2327900.0
2002-01-18 11:00:00	SPY	ETF	113.49	113.53	113.2	113.34	1075900.0
2002-01-18 11:30:00	SPY	ETF	113.35	113.43	113.01	113.15	664800.0
2002-01-18 12:00:00	SPY	ETF	113.16	113.4	113.05	113.21	1531100.0
2002-01-18 12:30:00	SPY	ETF	113.19	113.32	113.12	113.25	482900.0
2002-01-18 13:00:00	SPY	ETF	113.23	113.38	113.18	113.28	417600.0
2002-01-18 13:30:00	SPY	ETF	113.32	113.48	113.3	113.44	221300.0
2002-01-18 14:00:00	SPY	ETF	113.4	113.43	113.11	113.26	431200.0
2002-01-18 14:30:00	SPY	ETF	113.25	113.26	112.81	112.97	761900.0
2002-01-18 15:00:00	SPY	ETF	112.94	113.0	112.67	112.87	1355900.0
2002-01-18 15:30:00	SPY	ETF	112.89	113.28	112.7	113.05	903300.0
2002-01-18 16:00:00	SPY	ETF	113.09	113.25	113.04	113.23	1577600.0
2002-01-18 18:00:00	SPY	ETF	113.2	113.2	113.2	113.2	200.0
2002-01-18 09:30:00	QQQ	ETF	38.83	39.1	38.78	38.95	13434900.0
2002-01-18 10:00:00	QQQ	ETF	38.95	39.2	38.8	39.14	7431800.0
2002-01-18 10:30:00	QQQ	ETF	39.15	39.45	38.93	39.14	10222700.0
2002-01-18 11:00:00	QQQ	ETF	39.15	39.17	38.81	38.92	7050100.0
2002-01-18 11:30:00	QQQ	ETF	38.92	38.97	38.76	38.83	3175600.0
2002-01-18 12:00:00	QQQ	ETF	38.83	39.08	38.76	38.9	4771400.0
2002-01-18 12:30:00	QQQ	ETF	38.92	38.97	38.86	38.94	1423100.0
2002-01-18 13:00:00	QQQ	ETF	38.95	39.02	38.91	38.93	1385500.0
2002-01-18 13:30:00	QQQ	ETF	38.95	39.07	38.9	38.95	2130300.0
2002-01-18 14:00:00	QQQ	ETF	38.93	38.97	38.7	38.82	4151000.0
2002-01-18 14:30:00	QQQ	ETF	38.8	38.84	38.52	38.57	6689300.0
2002-01-18 15:00:00	QQQ	ETF	38.57	38.6	38.22	38.44	7737900.0
2002-01-18 15:30:00	QQQ	ETF	38.42	38.73	38.3	38.56	7121400.0
2002-01-18 16:00:00	QQQ	ETF	38.55	38.64	38.3	38.56	2769100.0
2002-01-18 16:30:00	QQQ	ETF	38.54	38.59	38.48	38.56	20300.0
2002-01-18 17:00:00	QQQ	ETF	38.53	38.57	38.5	38.57	870500.0
2002-01-18 17:30:00	QQQ	ETF	38.6	38.6	38.55	38.58	5100.0
2002-01-18 18:00:00	QQQ	ETF	38.55	38.59	38.55	38.59	2600.0
2002-01-18 09:30:00	IWM	ETF	47.55	47.64	47.455	47.575	157000.0
2002-01-18 10:00:00	IWM	ETF	47.55	47.8	47.545	47.76	106200.0
2002-01-18 10:30:00	IWM	ETF	47.665	47.83	47.665	47.745	14600.0
2002-01-18 11:00:00	IWM	ETF	47.735	47.795	47.685	47.685	68400.0
2002-01-18 11:30:00	IWM	ETF	47.685	47.725	47.565	47.565	181000.0
2002-01-18 12:00:00	IWM	ETF	47.645	47.645	47.435	47.45	44800.0
2002-01-18 12:30:00	IWM	ETF	47.575	47.58	47.375	47.495	42600.0
2002-01-18 13:00:00	IWM	ETF	47.505	47.62	47.495	47.62	21400.0
2002-01-18 13:30:00	IWM	ETF	47.62	47.625	47.575	47.605	13200.0
2002-01-18 14:00:00	IWM	ETF	47.605	47.62	47.455	47.55	5200.0
2002-01-18 14:30:00	IWM	ETF	47.535	47.535	47.265	47.265	31000.0
2002-01-18 15:00:00	IWM	ETF	47.3	47.32	47.075	47.3	60800.0
2002-01-18 15:30:00	IWM	ETF	47.09	47.36	47.05	47.15	36400.0
2002-01-18 16:00:00	IWM	ETF	47.15	47.15	46.9	46.95	196800.0
2002-01-18 09:30:00	DIA	ETF	97.48	98.01	97.43	97.98	550300.0
2002-01-18 10:00:00	DIA	ETF	97.98	98.1	97.66	97.94	354100.0
2002-01-18 10:30:00	DIA	ETF	98.06	98.38	97.94	98.16	582700.0

> showing 50 of 454 rows — these rows as CSV

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