PREVIEW / etf_30min / 2003-07-18

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-18.parquet
  size:    23 KB
  rows:    678

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-18 08:00:00	SPY	ETF	98.84	98.9	98.73	98.79	19500.0
2003-07-18 08:30:00	SPY	ETF	98.76	98.8	98.64	98.8	11000.0
2003-07-18 09:00:00	SPY	ETF	98.85	99.05	98.81	99.05	47800.0
2003-07-18 09:30:00	SPY	ETF	99.02	99.25	98.79	98.97	6093100.0
2003-07-18 10:00:00	SPY	ETF	98.98	99.17	98.46	98.66	5195300.0
2003-07-18 10:30:00	SPY	ETF	98.65	98.94	98.59	98.88	1565100.0
2003-07-18 11:00:00	SPY	ETF	98.87	98.88	98.6	98.69	2603500.0
2003-07-18 11:30:00	SPY	ETF	98.7	98.83	98.66	98.754	1779100.0
2003-07-18 12:00:00	SPY	ETF	98.77	99.07	98.72	99.04	761000.0
2003-07-18 12:30:00	SPY	ETF	99.05	99.16	98.99	99.1	1775000.0
2003-07-18 13:00:00	SPY	ETF	99.09	99.1	98.89	99.02	712700.0
2003-07-18 13:30:00	SPY	ETF	99.02	99.04	98.92	98.95	1221100.0
2003-07-18 14:00:00	SPY	ETF	98.98	99.4	98.96	99.39	1684800.0
2003-07-18 14:30:00	SPY	ETF	99.37	99.57	99.33	99.49	1479400.0
2003-07-18 15:00:00	SPY	ETF	99.47	99.8	99.47	99.66	1947600.0
2003-07-18 15:30:00	SPY	ETF	99.68	99.8	99.43	99.58	2798400.0
2003-07-18 16:00:00	SPY	ETF	99.56	99.69	99.51	99.54	1971800.0
2003-07-18 16:30:00	SPY	ETF	99.57	99.6	99.54	99.55	62200.0
2003-07-18 17:00:00	SPY	ETF	99.55	99.55	99.48	99.55	31900.0
2003-07-18 17:30:00	SPY	ETF	99.54	99.54	99.52	99.52	600.0
2003-07-18 18:00:00	SPY	ETF	99.47	99.55	99.47	99.55	1900.0
2003-07-18 18:30:00	SPY	ETF	99.6	99.6	99.6	99.6	5100.0
2003-07-18 19:30:00	SPY	ETF	99.54	99.54	99.54	99.54	100.0
2003-07-18 08:00:00	QQQ	ETF	31.25	31.33	31.25	31.32	48300.0
2003-07-18 08:30:00	QQQ	ETF	31.31	31.33	31.24	31.33	103300.0
2003-07-18 09:00:00	QQQ	ETF	31.33	31.4	31.32	31.4	209200.0
2003-07-18 09:30:00	QQQ	ETF	31.4	31.47	31.22	31.271	12510100.0
2003-07-18 10:00:00	QQQ	ETF	31.273	31.35	30.92	31.06	14524400.0
2003-07-18 10:30:00	QQQ	ETF	31.05	31.24	31.04	31.2	7277000.0
2003-07-18 11:00:00	QQQ	ETF	31.204	31.22	31.06	31.129	3030300.0
2003-07-18 11:30:00	QQQ	ETF	31.13	31.19	31.11	31.14	3934900.0
2003-07-18 12:00:00	QQQ	ETF	31.15	31.298	31.11	31.29	2567500.0
2003-07-18 12:30:00	QQQ	ETF	31.3	31.33	31.24	31.258	2555700.0
2003-07-18 13:00:00	QQQ	ETF	31.25	31.27	31.15	31.2	1937800.0
2003-07-18 13:30:00	QQQ	ETF	31.2	31.22	31.17	31.18	732500.0
2003-07-18 14:00:00	QQQ	ETF	31.19	31.37	31.19	31.33	3874600.0
2003-07-18 14:30:00	QQQ	ETF	31.32	31.44	31.28	31.38	3765800.0
2003-07-18 15:00:00	QQQ	ETF	31.39	31.55	31.36	31.43	5813500.0
2003-07-18 15:30:00	QQQ	ETF	31.44	31.49	31.26	31.3	7000300.0
2003-07-18 16:00:00	QQQ	ETF	31.28	31.34	31.24	31.29	1956800.0
2003-07-18 16:30:00	QQQ	ETF	31.29	31.33	31.26	31.3	176500.0
2003-07-18 17:00:00	QQQ	ETF	31.3	31.31	31.27	31.28	32100.0
2003-07-18 17:30:00	QQQ	ETF	31.3	31.3	31.26	31.26	28000.0
2003-07-18 18:00:00	QQQ	ETF	31.26	31.3	31.25	31.25	40800.0
2003-07-18 18:30:00	QQQ	ETF	31.26	31.26	31.23	31.23	5800.0
2003-07-18 19:30:00	QQQ	ETF	31.26	31.36	31.26	31.28	4900.0
2003-07-18 09:30:00	IWM	ETF	46.1	46.225	46.005	46.015	356000.0
2003-07-18 10:00:00	IWM	ETF	46.075	46.09	45.795	45.825	684000.0
2003-07-18 10:30:00	IWM	ETF	45.8	45.875	45.77	45.825	268400.0
2003-07-18 11:00:00	IWM	ETF	45.845	45.885	45.8	45.8	113200.0

> showing 50 of 678 rows — these rows as CSV

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