PREVIEW / etf_30min / 2003-07-16

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-16.parquet
  size:    23 KB
  rows:    698

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-16 08:00:00	SPY	ETF	101.08	101.1	100.99	100.99	55700.0
2003-07-16 08:30:00	SPY	ETF	101.04	101.07	100.86	100.86	30700.0
2003-07-16 09:00:00	SPY	ETF	100.87	100.9	100.78	100.78	42500.0
2003-07-16 09:30:00	SPY	ETF	100.81	100.87	100.17	100.36	5574200.0
2003-07-16 10:00:00	SPY	ETF	100.35	100.36	99.41	99.43	5778400.0
2003-07-16 10:30:00	SPY	ETF	99.45	99.69	99.36	99.64	4712100.0
2003-07-16 11:00:00	SPY	ETF	99.64	99.65	99.23	99.48	2033100.0
2003-07-16 11:30:00	SPY	ETF	99.48	99.57	99.38	99.42	1389200.0
2003-07-16 12:00:00	SPY	ETF	99.4	99.66	99.36	99.65	958200.0
2003-07-16 12:30:00	SPY	ETF	99.65	99.8	99.58	99.66	2812600.0
2003-07-16 13:00:00	SPY	ETF	99.66	99.83	99.58	99.58	1429100.0
2003-07-16 13:30:00	SPY	ETF	99.57	99.71	99.41	99.52	1050500.0
2003-07-16 14:00:00	SPY	ETF	99.51	99.68	99.33	99.49	1486100.0
2003-07-16 14:30:00	SPY	ETF	99.49	99.74	99.41	99.68	1221800.0
2003-07-16 15:00:00	SPY	ETF	99.68	99.71	99.3	99.31	1597200.0
2003-07-16 15:30:00	SPY	ETF	99.33	99.785	99.3	99.76	3065800.0
2003-07-16 16:00:00	SPY	ETF	99.76	100.02	99.7	99.82	2320000.0
2003-07-16 16:30:00	SPY	ETF	99.86	99.93	99.73	99.76	504100.0
2003-07-16 17:00:00	SPY	ETF	99.76	99.76	99.6	99.6	643200.0
2003-07-16 17:30:00	SPY	ETF	99.59	99.67	99.44	99.44	178000.0
2003-07-16 18:00:00	SPY	ETF	99.44	99.56	99.43	99.56	24400.0
2003-07-16 18:30:00	SPY	ETF	99.55	99.59	99.55	99.59	16800.0
2003-07-16 19:00:00	SPY	ETF	99.64	99.7	99.63	99.7	3700.0
2003-07-16 19:30:00	SPY	ETF	99.63	99.68	99.63	99.65	1600.0
2003-07-16 08:00:00	QQQ	ETF	32.58	32.6	32.5	32.53	72700.0
2003-07-16 08:30:00	QQQ	ETF	32.52	32.56	32.45	32.48	59900.0
2003-07-16 09:00:00	QQQ	ETF	32.48	32.5	32.41	32.44	106800.0
2003-07-16 09:30:00	QQQ	ETF	32.46	32.5	32.132	32.25	13323300.0
2003-07-16 10:00:00	QQQ	ETF	32.25	32.28	31.82	31.83	11222100.0
2003-07-16 10:30:00	QQQ	ETF	31.85	31.98	31.78	31.97	6848500.0
2003-07-16 11:00:00	QQQ	ETF	31.96	31.97	31.73	31.93	6448300.0
2003-07-16 11:30:00	QQQ	ETF	31.92	31.98	31.88	31.908	2792600.0
2003-07-16 12:00:00	QQQ	ETF	31.918	32.07	31.9	32.06	3413700.0
2003-07-16 12:30:00	QQQ	ETF	32.07	32.13	32.0	32.08	2927700.0
2003-07-16 13:00:00	QQQ	ETF	32.07	32.19	32.03	32.071	2644500.0
2003-07-16 13:30:00	QQQ	ETF	32.08	32.13	32.0	32.03	3391800.0
2003-07-16 14:00:00	QQQ	ETF	32.02	32.075	31.92	31.97	3728200.0
2003-07-16 14:30:00	QQQ	ETF	31.97	32.12	31.95	32.072	3275800.0
2003-07-16 15:00:00	QQQ	ETF	32.07	32.09	31.9	31.93	3252400.0
2003-07-16 15:30:00	QQQ	ETF	31.931	32.15	31.91	32.14	6265000.0
2003-07-16 16:00:00	QQQ	ETF	32.15	32.2147	32.09	32.12	3529300.0
2003-07-16 16:30:00	QQQ	ETF	32.14	32.17	31.87	32.042	523600.0
2003-07-16 17:00:00	QQQ	ETF	32.05	32.0662	31.92	31.95	946100.0
2003-07-16 17:30:00	QQQ	ETF	31.95	31.98	31.84	31.84	424800.0
2003-07-16 18:00:00	QQQ	ETF	31.85	31.886	31.83	31.85	500900.0
2003-07-16 18:30:00	QQQ	ETF	31.89	31.9	31.86	31.9	7600.0
2003-07-16 19:00:00	QQQ	ETF	31.9	31.93	31.9	31.9	10000.0
2003-07-16 19:30:00	QQQ	ETF	31.9	31.91	31.88	31.88	5800.0
2003-07-16 09:30:00	IWM	ETF	47.83	47.87	47.5	47.58	516200.0
2003-07-16 10:00:00	IWM	ETF	47.595	47.595	47.195	47.195	313000.0

> showing 50 of 698 rows — these rows as CSV

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