PREVIEW / etf_30min / 2003-06-17

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-06-17.parquet
  size:    24 KB
  rows:    749

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-06-17 08:00:00	SPY	ETF	101.86	102.04	101.86	101.96	14400.0
2003-06-17 08:30:00	SPY	ETF	102.05	102.25	102.04	102.17	74700.0
2003-06-17 09:00:00	SPY	ETF	102.2	102.24	102.07	102.12	60100.0
2003-06-17 09:30:00	SPY	ETF	102.07	102.179	101.48	101.63	7186400.0
2003-06-17 10:00:00	SPY	ETF	101.65	102.07	101.475	101.62	3593200.0
2003-06-17 10:30:00	SPY	ETF	101.609	101.74	101.23	101.46	3374400.0
2003-06-17 11:00:00	SPY	ETF	101.45	101.87	101.32	101.79	2421000.0
2003-06-17 11:30:00	SPY	ETF	101.76	102.0	101.7	101.95	1265600.0
2003-06-17 12:00:00	SPY	ETF	101.94	101.99	101.6	101.8	1112700.0
2003-06-17 12:30:00	SPY	ETF	101.779	101.93	101.69	101.85	696500.0
2003-06-17 13:00:00	SPY	ETF	101.859	102.04	101.76	101.94	1689900.0
2003-06-17 13:30:00	SPY	ETF	101.91	101.95	101.62	101.65	1269500.0
2003-06-17 14:00:00	SPY	ETF	101.65	101.84	101.5	101.66	1187500.0
2003-06-17 14:30:00	SPY	ETF	101.65	102.13	101.58	102.0	2411600.0
2003-06-17 15:00:00	SPY	ETF	102.0	102.1	101.85	101.98	1533200.0
2003-06-17 15:30:00	SPY	ETF	101.961	102.17	101.6	101.75	4047100.0
2003-06-17 16:00:00	SPY	ETF	101.69	101.76	101.62	101.67	1474100.0
2003-06-17 16:30:00	SPY	ETF	101.67	101.7	101.63	101.67	69800.0
2003-06-17 17:00:00	SPY	ETF	101.66	101.7	101.66	101.68	7900.0
2003-06-17 17:30:00	SPY	ETF	101.71	101.71	101.68	101.7	10000.0
2003-06-17 18:00:00	SPY	ETF	101.65	101.7	101.65	101.7	6700.0
2003-06-17 18:30:00	SPY	ETF	101.71	101.71	101.71	101.71	4000.0
2003-06-17 19:00:00	SPY	ETF	101.77	101.77	101.77	101.77	100.0
2003-06-17 19:30:00	SPY	ETF	101.79	101.84	101.77	101.84	2100.0
2003-06-17 08:00:00	QQQ	ETF	30.93	31.03	30.93	30.98	43800.0
2003-06-17 08:30:00	QQQ	ETF	31.01	31.11	31.01	31.08	101600.0
2003-06-17 09:00:00	QQQ	ETF	31.08	31.1	31.02	31.03	129900.0
2003-06-17 09:30:00	QQQ	ETF	31.02	31.11	30.62	30.74	15306000.0
2003-06-17 10:00:00	QQQ	ETF	30.73	30.94	30.67	30.7	6518900.0
2003-06-17 10:30:00	QQQ	ETF	30.7	30.76	30.56	30.7	6238100.0
2003-06-17 11:00:00	QQQ	ETF	30.71	30.83	30.61	30.8	3792200.0
2003-06-17 11:30:00	QQQ	ETF	30.789	30.89	30.73	30.869	3068100.0
2003-06-17 12:00:00	QQQ	ETF	30.88	30.89	30.72	30.8	2008000.0
2003-06-17 12:30:00	QQQ	ETF	30.792	30.86	30.76	30.81	1289500.0
2003-06-17 13:00:00	QQQ	ETF	30.81	30.9	30.77	30.86	1780400.0
2003-06-17 13:30:00	QQQ	ETF	30.85	30.87	30.7	30.72	1899000.0
2003-06-17 14:00:00	QQQ	ETF	30.71	30.82	30.67	30.73	1933400.0
2003-06-17 14:30:00	QQQ	ETF	30.74	30.97	30.73	30.92	4000900.0
2003-06-17 15:00:00	QQQ	ETF	30.92	30.95	30.85	30.889	2821300.0
2003-06-17 15:30:00	QQQ	ETF	30.89	30.95	30.72	30.79	4388600.0
2003-06-17 16:00:00	QQQ	ETF	30.79	30.81	30.73	30.77	962500.0
2003-06-17 16:30:00	QQQ	ETF	30.77	30.79	30.76	30.78	45700.0
2003-06-17 17:00:00	QQQ	ETF	30.79	30.8	30.78	30.8	15100.0
2003-06-17 17:30:00	QQQ	ETF	30.78	30.81	30.78	30.81	88200.0
2003-06-17 18:00:00	QQQ	ETF	30.81	30.81	30.758	30.77	55800.0
2003-06-17 18:30:00	QQQ	ETF	30.79	30.81	30.79	30.8	2900.0
2003-06-17 19:00:00	QQQ	ETF	30.81	30.81	30.8	30.8	2000.0
2003-06-17 19:30:00	QQQ	ETF	30.83	30.83	30.83	30.83	400.0
2003-06-17 09:00:00	IWM	ETF	45.815	45.815	45.815	45.815	400.0
2003-06-17 09:30:00	IWM	ETF	45.845	45.85	45.325	45.375	602600.0

> showing 50 of 749 rows — these rows as CSV

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