PREVIEW / etf_30min / 2002-05-07

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-05-07.parquet
  size:    19 KB
  rows:    519

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-05-07 09:30:00	SPY	ETF	106.1	106.25	105.75	105.78	3328800.0
2002-05-07 10:00:00	SPY	ETF	105.76	106.03	105.39	105.86	3314400.0
2002-05-07 10:30:00	SPY	ETF	105.85	105.94	105.45	105.86	1872100.0
2002-05-07 11:00:00	SPY	ETF	105.89	105.96	105.59	105.66	1192500.0
2002-05-07 11:30:00	SPY	ETF	105.66	105.77	105.45	105.67	1033900.0
2002-05-07 12:00:00	SPY	ETF	105.64	106.14	105.64	105.99	1681200.0
2002-05-07 12:30:00	SPY	ETF	106.0	106.2	105.94	106.04	1069100.0
2002-05-07 13:00:00	SPY	ETF	106.08	106.27	105.96	106.05	644700.0
2002-05-07 13:30:00	SPY	ETF	106.07	106.1	105.83	105.97	611500.0
2002-05-07 14:00:00	SPY	ETF	106.01	106.32	105.7	105.87	1216000.0
2002-05-07 14:30:00	SPY	ETF	105.85	106.13	105.65	106.01	1599700.0
2002-05-07 15:00:00	SPY	ETF	106.0	106.08	105.62	105.78	596700.0
2002-05-07 15:30:00	SPY	ETF	105.72	105.78	105.2	105.23	1423100.0
2002-05-07 16:00:00	SPY	ETF	105.22	105.64	104.88	105.35	1876000.0
2002-05-07 16:30:00	SPY	ETF	105.39	105.58	105.3	105.53	65000.0
2002-05-07 17:00:00	SPY	ETF	105.55	105.94	105.5	105.91	248500.0
2002-05-07 17:30:00	SPY	ETF	105.85	105.89	105.76	105.87	13800.0
2002-05-07 18:00:00	SPY	ETF	105.83	105.95	105.71	105.85	255000.0
2002-05-07 09:30:00	QQQ	ETF	29.27	29.35	28.71	28.74	12684800.0
2002-05-07 10:00:00	QQQ	ETF	28.73	29.03	28.42	28.86	15142100.0
2002-05-07 10:30:00	QQQ	ETF	28.84	28.89	28.53	28.77	7265000.0
2002-05-07 11:00:00	QQQ	ETF	28.75	28.8	28.57	28.69	4873700.0
2002-05-07 11:30:00	QQQ	ETF	28.69	28.94	28.59	28.85	6776200.0
2002-05-07 12:00:00	QQQ	ETF	28.86	29.24	28.85	29.1	6684700.0
2002-05-07 12:30:00	QQQ	ETF	29.11	29.31	29.08	29.16	5271800.0
2002-05-07 13:00:00	QQQ	ETF	29.17	29.32	29.1	29.22	3154100.0
2002-05-07 13:30:00	QQQ	ETF	29.19	29.22	29.03	29.21	2571500.0
2002-05-07 14:00:00	QQQ	ETF	29.2	29.32	28.92	29.08	6430300.0
2002-05-07 14:30:00	QQQ	ETF	29.08	29.24	28.91	29.13	6014300.0
2002-05-07 15:00:00	QQQ	ETF	29.12	29.2	28.92	29.03	5328500.0
2002-05-07 15:30:00	QQQ	ETF	29.02	29.06	28.78	28.84	9863600.0
2002-05-07 16:00:00	QQQ	ETF	28.85	29.15	28.65	29.04	2870600.0
2002-05-07 16:30:00	QQQ	ETF	29.04	29.26	29.03	29.13	1604200.0
2002-05-07 17:00:00	QQQ	ETF	29.12	29.43	29.12	29.41	2349500.0
2002-05-07 17:30:00	QQQ	ETF	29.4	29.41	29.27	29.35	531500.0
2002-05-07 18:00:00	QQQ	ETF	29.37	29.38	29.3	29.35	238900.0
2002-05-07 09:30:00	IWM	ETF	50.24	50.27	49.975	49.975	110000.0
2002-05-07 10:00:00	IWM	ETF	49.875	49.95	49.685	49.86	254800.0
2002-05-07 10:30:00	IWM	ETF	49.815	49.85	49.7	49.805	106600.0
2002-05-07 11:00:00	IWM	ETF	49.82	49.85	49.75	49.8	78400.0
2002-05-07 11:30:00	IWM	ETF	49.755	49.81	49.69	49.81	111400.0
2002-05-07 12:00:00	IWM	ETF	49.81	49.945	49.79	49.9	34400.0
2002-05-07 12:30:00	IWM	ETF	49.9	50.03	49.9	50.02	44000.0
2002-05-07 13:00:00	IWM	ETF	49.955	50.06	49.955	50.01	48200.0
2002-05-07 13:30:00	IWM	ETF	49.99	49.99	49.88	49.88	21600.0
2002-05-07 14:00:00	IWM	ETF	49.925	50.0	49.845	49.855	71200.0
2002-05-07 14:30:00	IWM	ETF	49.915	49.915	49.78	49.9	91400.0
2002-05-07 15:00:00	IWM	ETF	49.9	49.9	49.79	49.825	140400.0
2002-05-07 15:30:00	IWM	ETF	49.825	49.865	49.6	49.71	104400.0
2002-05-07 16:00:00	IWM	ETF	49.71	49.71	49.615	49.615	78600.0

> showing 50 of 519 rows — these rows as CSV

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