PREVIEW / etf_30min / 2003-09-25

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-09-25.parquet
  size:    25 KB
  rows:    731

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-09-25 08:00:00	SPY	ETF	101.33	101.49	101.27	101.49	37100.0
2003-09-25 08:30:00	SPY	ETF	101.37	101.53	101.25	101.51	310300.0
2003-09-25 09:00:00	SPY	ETF	101.5	101.52	101.41	101.41	57000.0
2003-09-25 09:30:00	SPY	ETF	101.41	101.53	101.15	101.27	6519000.0
2003-09-25 10:00:00	SPY	ETF	101.25	101.5	100.72	100.8	5607500.0
2003-09-25 10:30:00	SPY	ETF	100.77	101.23	100.75	101.17	4628600.0
2003-09-25 11:00:00	SPY	ETF	101.18	101.51	101.14	101.51	3012100.0
2003-09-25 11:30:00	SPY	ETF	101.51	101.71	101.47	101.622	2662000.0
2003-09-25 12:00:00	SPY	ETF	101.63	101.88	101.57	101.67	3081000.0
2003-09-25 12:30:00	SPY	ETF	101.65	101.76	101.57	101.67	634700.0
2003-09-25 13:00:00	SPY	ETF	101.65	101.66	101.25	101.44	1950900.0
2003-09-25 13:30:00	SPY	ETF	101.48	101.6	101.11	101.23	1985900.0
2003-09-25 14:00:00	SPY	ETF	101.21	101.38	101.05	101.2	2922900.0
2003-09-25 14:30:00	SPY	ETF	101.2	101.5	101.18	101.36	1343900.0
2003-09-25 15:00:00	SPY	ETF	101.37	101.59	101.19	101.3	1516700.0
2003-09-25 15:30:00	SPY	ETF	101.31	101.33	100.54	100.59	5089300.0
2003-09-25 16:00:00	SPY	ETF	100.58	100.66	100.188	100.29	3956800.0
2003-09-25 16:30:00	SPY	ETF	100.32	100.32	100.0	100.07	448000.0
2003-09-25 17:00:00	SPY	ETF	100.077	100.17	100.077	100.1	132300.0
2003-09-25 17:30:00	SPY	ETF	100.07	100.24	100.07	100.11	437400.0
2003-09-25 18:00:00	SPY	ETF	100.21	100.21	100.13	100.16	3900.0
2003-09-25 18:30:00	SPY	ETF	100.16	100.16	100.16	100.16	2000.0
2003-09-25 19:00:00	SPY	ETF	100.24	100.26	100.19	100.19	9800.0
2003-09-25 19:30:00	SPY	ETF	100.16	100.16	100.1	100.1	500.0
2003-09-25 08:00:00	QQQ	ETF	33.28	33.33	33.27	33.33	166600.0
2003-09-25 08:30:00	QQQ	ETF	33.33	33.4	33.25	33.39	408200.0
2003-09-25 09:00:00	QQQ	ETF	33.39	33.41	33.37	33.38	444500.0
2003-09-25 09:30:00	QQQ	ETF	33.38	33.47	33.2	33.341	14044700.0
2003-09-25 10:00:00	QQQ	ETF	33.34	33.48	33.09	33.12	10863900.0
2003-09-25 10:30:00	QQQ	ETF	33.12	33.39	33.09	33.34	10211600.0
2003-09-25 11:00:00	QQQ	ETF	33.37	33.57	33.34	33.54	6882300.0
2003-09-25 11:30:00	QQQ	ETF	33.54	33.676	33.52	33.63	5987000.0
2003-09-25 12:00:00	QQQ	ETF	33.64	33.74	33.57	33.589	5940500.0
2003-09-25 12:30:00	QQQ	ETF	33.59	33.68	33.54	33.58	3289700.0
2003-09-25 13:00:00	QQQ	ETF	33.61	33.61	33.41	33.5	4342300.0
2003-09-25 13:30:00	QQQ	ETF	33.52	33.61	33.29	33.36	5812900.0
2003-09-25 14:00:00	QQQ	ETF	33.36	33.47	33.27	33.34	4856200.0
2003-09-25 14:30:00	QQQ	ETF	33.34	33.59	33.31	33.49	4208100.0
2003-09-25 15:00:00	QQQ	ETF	33.49	33.61	33.36	33.44	4169300.0
2003-09-25 15:30:00	QQQ	ETF	33.45	33.45	32.96	32.979	11884300.0
2003-09-25 16:00:00	QQQ	ETF	32.99	33.01	32.76	32.8	6757700.0
2003-09-25 16:30:00	QQQ	ETF	32.8	32.8	32.63	32.64	1014800.0
2003-09-25 17:00:00	QQQ	ETF	32.65	33.65	32.64	32.66	2255600.0
2003-09-25 17:30:00	QQQ	ETF	32.67	32.73	32.65	32.692	220300.0
2003-09-25 18:00:00	QQQ	ETF	32.69	32.71	32.65	32.71	88900.0
2003-09-25 18:30:00	QQQ	ETF	32.71	32.71	32.66	32.69	18000.0
2003-09-25 19:00:00	QQQ	ETF	32.69	32.73	32.68	32.7	41400.0
2003-09-25 19:30:00	QQQ	ETF	32.69	32.7	32.65	32.67	28000.0
2003-09-25 08:30:00	IWM	ETF	50.605	50.605	50.605	50.605	600.0
2003-09-25 09:30:00	IWM	ETF	50.665	50.85	50.47	50.5	632200.0

> showing 50 of 731 rows — these rows as CSV

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