PREVIEW / etf_30min / 2003-08-01

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-08-01.parquet
  size:    22 KB
  rows:    679

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-08-01 08:00:00	SPY	ETF	99.55	99.62	99.44	99.62	41700.0
2003-08-01 08:30:00	SPY	ETF	99.56	99.56	98.98	99.1	380400.0
2003-08-01 09:00:00	SPY	ETF	99.1	99.27	99.09	99.23	80200.0
2003-08-01 09:30:00	SPY	ETF	99.19	99.29	98.72	98.77	7855600.0
2003-08-01 10:00:00	SPY	ETF	98.77	98.97	98.27	98.35	7879500.0
2003-08-01 10:30:00	SPY	ETF	98.35	98.61	98.24	98.46	3033700.0
2003-08-01 11:00:00	SPY	ETF	98.49	98.73	98.3	98.58	1784400.0
2003-08-01 11:30:00	SPY	ETF	98.59	98.68	98.34	98.5	1592600.0
2003-08-01 12:00:00	SPY	ETF	98.511	98.61	98.351	98.45	916100.0
2003-08-01 12:30:00	SPY	ETF	98.38	98.699	98.33	98.68	1098300.0
2003-08-01 13:00:00	SPY	ETF	98.64	98.94	98.6	98.66	2853100.0
2003-08-01 13:30:00	SPY	ETF	98.65	98.72	98.5	98.67	1029600.0
2003-08-01 14:00:00	SPY	ETF	98.68	98.7	98.42	98.61	1879200.0
2003-08-01 14:30:00	SPY	ETF	98.58	98.81	98.48	98.6	2106000.0
2003-08-01 15:00:00	SPY	ETF	98.6	98.67	98.32	98.38	6425000.0
2003-08-01 15:30:00	SPY	ETF	98.4	98.56	98.25	98.38	3905400.0
2003-08-01 16:00:00	SPY	ETF	98.38	98.55	98.35	98.4	1390700.0
2003-08-01 16:30:00	SPY	ETF	98.4	98.43	98.35	98.41	52700.0
2003-08-01 17:00:00	SPY	ETF	98.39	98.4	98.39	98.39	3000.0
2003-08-01 17:30:00	SPY	ETF	98.39	98.42	98.38	98.42	1400.0
2003-08-01 18:00:00	SPY	ETF	98.4	98.4	98.38	98.4	2000.0
2003-08-01 18:30:00	SPY	ETF	98.4	98.4	98.4	98.4	500.0
2003-08-01 19:00:00	SPY	ETF	98.4	98.4	98.4	98.4	2000.0
2003-08-01 08:00:00	QQQ	ETF	31.84	31.87	31.8	31.85	37100.0
2003-08-01 08:30:00	QQQ	ETF	31.88	31.89	31.58	31.63	260300.0
2003-08-01 09:00:00	QQQ	ETF	31.64	31.73	31.62	31.69	132500.0
2003-08-01 09:30:00	QQQ	ETF	31.69	31.79	31.55	31.62	6632400.0
2003-08-01 10:00:00	QQQ	ETF	31.62	31.69	31.31	31.37	14048000.0
2003-08-01 10:30:00	QQQ	ETF	31.38	31.51	31.3	31.47	4636900.0
2003-08-01 11:00:00	QQQ	ETF	31.5	31.59	31.39	31.534	3954700.0
2003-08-01 11:30:00	QQQ	ETF	31.53	31.6	31.44	31.51	3685700.0
2003-08-01 12:00:00	QQQ	ETF	31.51	31.56	31.42	31.489	1805500.0
2003-08-01 12:30:00	QQQ	ETF	31.49	31.57	31.437	31.55	1674400.0
2003-08-01 13:00:00	QQQ	ETF	31.555	31.716	31.55	31.592	6481100.0
2003-08-01 13:30:00	QQQ	ETF	31.61	31.65	31.52	31.56	2274900.0
2003-08-01 14:00:00	QQQ	ETF	31.561	31.57	31.44	31.54	5613300.0
2003-08-01 14:30:00	QQQ	ETF	31.532	31.648	31.5	31.57	2570100.0
2003-08-01 15:00:00	QQQ	ETF	31.57	31.59	31.45	31.47	3911800.0
2003-08-01 15:30:00	QQQ	ETF	31.475	31.59	31.37	31.484	6621300.0
2003-08-01 16:00:00	QQQ	ETF	31.483	31.55	31.45	31.46	3039400.0
2003-08-01 16:30:00	QQQ	ETF	31.47	31.5	31.44	31.47	38500.0
2003-08-01 17:00:00	QQQ	ETF	31.47	31.48	31.41	31.47	381700.0
2003-08-01 17:30:00	QQQ	ETF	31.47	31.48	31.469	31.469	7100.0
2003-08-01 18:00:00	QQQ	ETF	31.47	31.49	31.461	31.49	8700.0
2003-08-01 18:30:00	QQQ	ETF	31.47	31.49	31.45	31.45	8700.0
2003-08-01 19:00:00	QQQ	ETF	31.45	31.45	31.43	31.43	4200.0
2003-08-01 19:30:00	QQQ	ETF	31.42	31.42	31.4	31.41	7200.0
2003-08-01 09:00:00	IWM	ETF	47.235	47.235	47.235	47.235	2000.0
2003-08-01 09:30:00	IWM	ETF	47.375	47.477	47.161	47.2	356400.0
2003-08-01 10:00:00	IWM	ETF	47.175	47.195	46.68	46.7	560200.0

> showing 50 of 679 rows — these rows as CSV

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