PREVIEW / etf_30min / 2003-08-18

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-08-18.parquet
  size:    23 KB
  rows:    714

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-18 08:00:00	SPY	ETF	99.79	100.04	99.79	99.99	16000.0
2003-08-18 08:30:00	SPY	ETF	99.99	100.03	99.97	99.98	21700.0
2003-08-18 09:00:00	SPY	ETF	99.97	100.02	99.95	99.95	51600.0
2003-08-18 09:30:00	SPY	ETF	99.93	100.11	99.79	99.94	3465600.0
2003-08-18 10:00:00	SPY	ETF	99.93	100.0	99.74	99.941	2340600.0
2003-08-18 10:30:00	SPY	ETF	99.94	100.38	99.93	100.35	2572000.0
2003-08-18 11:00:00	SPY	ETF	100.34	100.36	100.19	100.23	1162200.0
2003-08-18 11:30:00	SPY	ETF	100.22	100.43	100.09	100.36	1067000.0
2003-08-18 12:00:00	SPY	ETF	100.36	100.5	100.355	100.42	1478600.0
2003-08-18 12:30:00	SPY	ETF	100.43	100.45	100.3	100.34	578300.0
2003-08-18 13:00:00	SPY	ETF	100.35	100.45	100.3	100.42	479700.0
2003-08-18 13:30:00	SPY	ETF	100.39	100.43	100.28	100.36	416000.0
2003-08-18 14:00:00	SPY	ETF	100.36	100.55	100.35	100.46	1021500.0
2003-08-18 14:30:00	SPY	ETF	100.46	100.56	100.34	100.45	1567700.0
2003-08-18 15:00:00	SPY	ETF	100.49	100.6	100.35	100.57	1100000.0
2003-08-18 15:30:00	SPY	ETF	100.58	100.6	100.401	100.5	2454200.0
2003-08-18 16:00:00	SPY	ETF	100.52	100.55	100.43	100.47	1361600.0
2003-08-18 16:30:00	SPY	ETF	100.47	100.5	100.41	100.44	12400.0
2003-08-18 17:00:00	SPY	ETF	100.5	100.5	100.5	100.5	200.0
2003-08-18 17:30:00	SPY	ETF	100.55	100.58	100.55	100.58	4800.0
2003-08-18 18:00:00	SPY	ETF	100.54	100.61	100.52	100.58	3500.0
2003-08-18 18:30:00	SPY	ETF	100.58	100.58	100.52	100.52	12600.0
2003-08-18 19:00:00	SPY	ETF	100.56	100.56	100.51	100.51	11100.0
2003-08-18 19:30:00	SPY	ETF	100.52	100.58	100.49	100.58	43500.0
2003-08-18 08:00:00	QQQ	ETF	31.25	31.34	31.22	31.32	40400.0
2003-08-18 08:30:00	QQQ	ETF	31.31	31.35	31.3	31.31	117400.0
2003-08-18 09:00:00	QQQ	ETF	31.31	31.34	31.29	31.29	76100.0
2003-08-18 09:30:00	QQQ	ETF	31.31	31.45	31.23	31.37	8673200.0
2003-08-18 10:00:00	QQQ	ETF	31.366	31.42	31.3	31.4	4516200.0
2003-08-18 10:30:00	QQQ	ETF	31.4	31.564	31.38	31.553	6279100.0
2003-08-18 11:00:00	QQQ	ETF	31.56	31.644	31.52	31.61	5132300.0
2003-08-18 11:30:00	QQQ	ETF	31.61	31.75	31.54	31.73	5227800.0
2003-08-18 12:00:00	QQQ	ETF	31.73	31.8	31.7	31.75	4547500.0
2003-08-18 12:30:00	QQQ	ETF	31.758	31.76	31.68	31.71	1824700.0
2003-08-18 13:00:00	QQQ	ETF	31.715	31.77	31.7	31.74	1308700.0
2003-08-18 13:30:00	QQQ	ETF	31.737	31.75	31.65	31.71	2012100.0
2003-08-18 14:00:00	QQQ	ETF	31.7	31.89	31.68	31.849	5104200.0
2003-08-18 14:30:00	QQQ	ETF	31.84	31.909	31.8	31.86	3253800.0
2003-08-18 15:00:00	QQQ	ETF	31.86	31.92	31.79	31.9	3064200.0
2003-08-18 15:30:00	QQQ	ETF	31.9	31.96	31.83	31.94	7087300.0
2003-08-18 16:00:00	QQQ	ETF	31.94	32.02	31.92	32.0	2203200.0
2003-08-18 16:30:00	QQQ	ETF	32.02	32.04	31.97	32.03	447000.0
2003-08-18 17:00:00	QQQ	ETF	32.026	32.11	32.026	32.08	409300.0
2003-08-18 17:30:00	QQQ	ETF	32.088	32.1	32.07	32.1	37600.0
2003-08-18 18:00:00	QQQ	ETF	32.091	32.099	32.05	32.08	80300.0
2003-08-18 18:30:00	QQQ	ETF	32.08	32.08	32.05	32.07	15100.0
2003-08-18 19:00:00	QQQ	ETF	32.04	32.05	32.02	32.03	125500.0
2003-08-18 19:30:00	QQQ	ETF	32.01	32.05	32.0	32.05	28300.0
2003-08-18 09:30:00	IWM	ETF	47.33	47.44	47.16	47.415	289200.0
2003-08-18 10:00:00	IWM	ETF	47.43	47.75	47.43	47.75	258400.0

> showing 50 of 714 rows — these rows as CSV

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