PREVIEW / etf_30min / 2003-07-24

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-24.parquet
  size:    24 KB
  rows:    719

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
2003-07-24 08:00:00	SPY	ETF	99.4	99.56	99.4	99.44	16300.0
2003-07-24 08:30:00	SPY	ETF	99.47	100.08	99.47	99.95	278800.0
2003-07-24 09:00:00	SPY	ETF	99.95	99.97	99.89	99.89	94900.0
2003-07-24 09:30:00	SPY	ETF	99.99	99.99	99.46	99.65	5718000.0
2003-07-24 10:00:00	SPY	ETF	99.69	100.34	99.66	100.08	4538500.0
2003-07-24 10:30:00	SPY	ETF	100.08	100.23	99.68	99.839	1599100.0
2003-07-24 11:00:00	SPY	ETF	99.85	100.16	99.8	100.11	1366000.0
2003-07-24 11:30:00	SPY	ETF	100.11	100.13	99.76	99.93	1564800.0
2003-07-24 12:00:00	SPY	ETF	99.92	99.94	99.74	99.9	675000.0
2003-07-24 12:30:00	SPY	ETF	99.87	99.95	99.69	99.833	1162400.0
2003-07-24 13:00:00	SPY	ETF	99.83	100.05	99.82	99.93	897200.0
2003-07-24 13:30:00	SPY	ETF	99.92	100.05	99.77	99.95	769400.0
2003-07-24 14:00:00	SPY	ETF	99.99	100.04	99.33	99.46	2273400.0
2003-07-24 14:30:00	SPY	ETF	99.46	99.5	98.9	99.01	4724400.0
2003-07-24 15:00:00	SPY	ETF	99.01	99.09	98.75	99.03	2639400.0
2003-07-24 15:30:00	SPY	ETF	99.04	99.06	98.37	98.5	5080200.0
2003-07-24 16:00:00	SPY	ETF	98.5	98.58	98.3	98.32	1609300.0
2003-07-24 16:30:00	SPY	ETF	98.32	98.52	98.3	98.38	470000.0
2003-07-24 17:00:00	SPY	ETF	98.39	98.41	98.36	98.41	86400.0
2003-07-24 17:30:00	SPY	ETF	98.41	98.41	98.33	98.34	258000.0
2003-07-24 18:00:00	SPY	ETF	98.35	98.35	98.313	98.32	1400.0
2003-07-24 18:30:00	SPY	ETF	98.35	98.38	98.35	98.38	1200.0
2003-07-24 19:00:00	SPY	ETF	98.4	98.4	98.36	98.36	1200.0
2003-07-24 19:30:00	SPY	ETF	98.36	98.36	98.36	98.36	400.0
2003-07-24 20:00:00	SPY	ETF	98.32	98.32	98.32	98.32	200.0
2003-07-24 08:00:00	QQQ	ETF	31.59	31.65	31.59	31.61	52400.0
2003-07-24 08:30:00	QQQ	ETF	31.63	32.05	31.63	31.96	337500.0
2003-07-24 09:00:00	QQQ	ETF	31.94	31.97	31.87	31.87	115200.0
2003-07-24 09:30:00	QQQ	ETF	31.85	31.96	31.72	31.862	11188400.0
2003-07-24 10:00:00	QQQ	ETF	31.85	32.01	31.83	31.868	7739900.0
2003-07-24 10:30:00	QQQ	ETF	31.87	31.961	31.754	31.809	4607000.0
2003-07-24 11:00:00	QQQ	ETF	31.81	31.94	31.79	31.91	2687200.0
2003-07-24 11:30:00	QQQ	ETF	31.91	31.94	31.778	31.85	2657500.0
2003-07-24 12:00:00	QQQ	ETF	31.846	31.87	31.72	31.79	2696200.0
2003-07-24 12:30:00	QQQ	ETF	31.78	31.84	31.738	31.76	2526500.0
2003-07-24 13:00:00	QQQ	ETF	31.77	31.87	31.77	31.82	1976900.0
2003-07-24 13:30:00	QQQ	ETF	31.82	31.852	31.76	31.84	1123100.0
2003-07-24 14:00:00	QQQ	ETF	31.85	31.86	31.53	31.62	4950000.0
2003-07-24 14:30:00	QQQ	ETF	31.63	31.63	31.32	31.4	9368200.0
2003-07-24 15:00:00	QQQ	ETF	31.4	31.44	31.27	31.421	5271500.0
2003-07-24 15:30:00	QQQ	ETF	31.42	31.43	31.1	31.13	8549200.0
2003-07-24 16:00:00	QQQ	ETF	31.14	31.22	30.94	30.96	3642900.0
2003-07-24 16:30:00	QQQ	ETF	30.96	31.04	30.94	30.97	622700.0
2003-07-24 17:00:00	QQQ	ETF	30.98	30.999	30.96	30.965	238000.0
2003-07-24 17:30:00	QQQ	ETF	30.98	30.99	30.91	30.95	878800.0
2003-07-24 18:00:00	QQQ	ETF	30.95	30.96	30.92	30.95	35200.0
2003-07-24 18:30:00	QQQ	ETF	30.95	30.95	30.91	30.95	6500.0
2003-07-24 19:00:00	QQQ	ETF	30.95	30.95	30.92	30.95	2800.0
2003-07-24 19:30:00	QQQ	ETF	30.95	31.0	30.94	30.94	14800.0
2003-07-24 09:00:00	IWM	ETF	46.92	46.94	46.92	46.94	4000.0

> showing 50 of 719 rows — these rows as CSV

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