PREVIEW / etf_30min / 2003-07-17

all etf 30-min files

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

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-17 08:00:00	SPY	ETF	99.0	99.08	98.93	99.04	26600.0
2003-07-17 08:30:00	SPY	ETF	99.04	99.22	99.04	99.1	119400.0
2003-07-17 09:00:00	SPY	ETF	99.1	99.19	99.09	99.15	48300.0
2003-07-17 09:30:00	SPY	ETF	99.15	99.58	99.07	99.526	5247300.0
2003-07-17 10:00:00	SPY	ETF	99.54	99.58	98.75	98.92	3721700.0
2003-07-17 10:30:00	SPY	ETF	98.92	99.07	98.71	99.02	2783400.0
2003-07-17 11:00:00	SPY	ETF	99.019	99.13	98.85	98.93	1625700.0
2003-07-17 11:30:00	SPY	ETF	98.97	99.05	98.77	98.95	1911700.0
2003-07-17 12:00:00	SPY	ETF	98.95	99.12	98.66	98.77	3040000.0
2003-07-17 12:30:00	SPY	ETF	98.8	98.84	98.3	98.31	6110700.0
2003-07-17 13:00:00	SPY	ETF	98.32	98.6	98.31	98.46	2128300.0
2003-07-17 13:30:00	SPY	ETF	98.43	98.75	98.36	98.65	1869500.0
2003-07-17 14:00:00	SPY	ETF	98.64	98.72	98.53	98.59	2049200.0
2003-07-17 14:30:00	SPY	ETF	98.58	98.69	98.17	98.22	4033500.0
2003-07-17 15:00:00	SPY	ETF	98.21	98.48	98.16	98.46	3968100.0
2003-07-17 15:30:00	SPY	ETF	98.47	98.71	98.23	98.491	3526200.0
2003-07-17 16:00:00	SPY	ETF	98.51	98.76	98.41	98.73	1754300.0
2003-07-17 16:30:00	SPY	ETF	98.7	98.79	98.56	98.6	313400.0
2003-07-17 17:00:00	SPY	ETF	98.62	98.63	98.49	98.61	145500.0
2003-07-17 17:30:00	SPY	ETF	98.53	98.56	98.435	98.56	13300.0
2003-07-17 18:00:00	SPY	ETF	98.53	98.53	98.35	98.35	5200.0
2003-07-17 18:30:00	SPY	ETF	98.35	98.38	98.28	98.28	7500.0
2003-07-17 19:00:00	SPY	ETF	98.35	98.35	98.35	98.35	100.0
2003-07-17 19:30:00	SPY	ETF	98.35	98.35	98.35	98.35	8700.0
2003-07-17 08:00:00	QQQ	ETF	31.6	31.64	31.6	31.6	157300.0
2003-07-17 08:30:00	QQQ	ETF	31.64	31.69	31.6	31.69	258300.0
2003-07-17 09:00:00	QQQ	ETF	31.69	31.72	31.65	31.68	136000.0
2003-07-17 09:30:00	QQQ	ETF	31.68	31.84	31.64	31.81	12109200.0
2003-07-17 10:00:00	QQQ	ETF	31.823	31.84	31.39	31.49	10742900.0
2003-07-17 10:30:00	QQQ	ETF	31.49	31.53	31.35	31.462	6490700.0
2003-07-17 11:00:00	QQQ	ETF	31.46	31.53	31.41	31.49	2900000.0
2003-07-17 11:30:00	QQQ	ETF	31.5	31.53	31.42	31.46	3292500.0
2003-07-17 12:00:00	QQQ	ETF	31.47	31.53	31.34	31.36	6461500.0
2003-07-17 12:30:00	QQQ	ETF	31.37	31.39	31.06	31.1	12131300.0
2003-07-17 13:00:00	QQQ	ETF	31.09	31.28	31.05	31.2	7148800.0
2003-07-17 13:30:00	QQQ	ETF	31.22	31.31	31.14	31.28	5196700.0
2003-07-17 14:00:00	QQQ	ETF	31.28	31.31	31.2	31.24	3713200.0
2003-07-17 14:30:00	QQQ	ETF	31.25	31.268	31.043	31.078	6384200.0
2003-07-17 15:00:00	QQQ	ETF	31.079	31.28	31.05	31.25	5062800.0
2003-07-17 15:30:00	QQQ	ETF	31.27	31.31	31.14	31.207	8843400.0
2003-07-17 16:00:00	QQQ	ETF	31.2	31.5	31.13	31.36	4275000.0
2003-07-17 16:30:00	QQQ	ETF	31.37	31.45	31.21	31.3	2306800.0
2003-07-17 17:00:00	QQQ	ETF	31.32	31.32	31.203	31.26	1001300.0
2003-07-17 17:30:00	QQQ	ETF	31.23	31.28	31.18	31.25	1081900.0
2003-07-17 18:00:00	QQQ	ETF	31.25	31.28	31.06	31.06	403900.0
2003-07-17 18:30:00	QQQ	ETF	31.06	31.11	31.05	31.11	14100.0
2003-07-17 19:00:00	QQQ	ETF	31.1	31.13	31.1	31.13	5700.0
2003-07-17 19:30:00	QQQ	ETF	31.15	31.18	31.1	31.12	8700.0
2003-07-17 09:30:00	IWM	ETF	46.885	46.94	46.765	46.89	219200.0
2003-07-17 10:00:00	IWM	ETF	46.88	46.91	46.495	46.535	445200.0

> showing 50 of 711 rows — these rows as CSV

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