PREVIEW / etf_30min / 2003-06-19

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-06-19.parquet
  size:    25 KB
  rows:    733

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-19 08:00:00	SPY	ETF	101.67	101.81	101.67	101.7	17800.0
2003-06-19 08:30:00	SPY	ETF	101.83	101.97	101.8	101.81	38500.0
2003-06-19 09:00:00	SPY	ETF	101.76	101.76	101.66	101.68	33500.0
2003-06-19 09:30:00	SPY	ETF	101.64	101.73	101.29	101.3	3551500.0
2003-06-19 10:00:00	SPY	ETF	101.38	101.7	101.24	101.33	3363600.0
2003-06-19 10:30:00	SPY	ETF	101.347	101.43	100.74	100.87	4129000.0
2003-06-19 11:00:00	SPY	ETF	100.86	100.86	100.4	100.61	3163500.0
2003-06-19 11:30:00	SPY	ETF	100.63	100.89	100.5	100.85	2462400.0
2003-06-19 12:00:00	SPY	ETF	100.85	100.88	100.24	100.632	6725200.0
2003-06-19 12:30:00	SPY	ETF	100.66	100.74	100.51	100.65	1017700.0
2003-06-19 13:00:00	SPY	ETF	100.653	100.73	100.51	100.69	1041700.0
2003-06-19 13:30:00	SPY	ETF	100.69	100.78	100.55	100.569	1313500.0
2003-06-19 14:00:00	SPY	ETF	100.56	100.7	100.42	100.69	1309400.0
2003-06-19 14:30:00	SPY	ETF	100.68	100.72	100.38	100.421	858600.0
2003-06-19 15:00:00	SPY	ETF	100.42	100.48	100.07	100.1	3150900.0
2003-06-19 15:30:00	SPY	ETF	100.12	100.14	99.84	100.0	3679800.0
2003-06-19 16:00:00	SPY	ETF	100.01	100.14	99.96	100.09	1379300.0
2003-06-19 16:30:00	SPY	ETF	100.12	100.15	100.0	100.011	1540200.0
2003-06-19 17:00:00	SPY	ETF	100.04	100.05	100.0	100.03	468200.0
2003-06-19 17:30:00	SPY	ETF	100.02	100.11	100.02	100.11	2800.0
2003-06-19 18:00:00	SPY	ETF	100.13	100.13	100.09	100.09	2200.0
2003-06-19 18:30:00	SPY	ETF	100.1	100.11	100.07	100.11	1900.0
2003-06-19 19:00:00	SPY	ETF	100.06	100.06	100.06	100.06	4500.0
2003-06-19 19:30:00	SPY	ETF	100.05	100.05	99.9	99.92	5200.0
2003-06-19 20:00:00	SPY	ETF	99.9	99.9	99.9	99.9	200.0
2003-06-19 08:00:00	QQQ	ETF	31.01	31.02	30.99	31.02	35400.0
2003-06-19 08:30:00	QQQ	ETF	31.05	31.1	31.01	31.01	119400.0
2003-06-19 09:00:00	QQQ	ETF	31.0	31.0	30.97	30.97	82600.0
2003-06-19 09:30:00	QQQ	ETF	30.98	31.17	30.87	31.03	9065300.0
2003-06-19 10:00:00	QQQ	ETF	31.01	31.24	31.01	31.08	9305400.0
2003-06-19 10:30:00	QQQ	ETF	31.08	31.11	30.79	30.86	7655100.0
2003-06-19 11:00:00	QQQ	ETF	30.86	30.87	30.64	30.75	5690100.0
2003-06-19 11:30:00	QQQ	ETF	30.76	30.86	30.71	30.85	3432200.0
2003-06-19 12:00:00	QQQ	ETF	30.85	30.86	30.65	30.782	6799700.0
2003-06-19 12:30:00	QQQ	ETF	30.782	30.87	30.74	30.834	1692900.0
2003-06-19 13:00:00	QQQ	ETF	30.83	30.9	30.79	30.89	1745400.0
2003-06-19 13:30:00	QQQ	ETF	30.89	30.94	30.82	30.84	2392100.0
2003-06-19 14:00:00	QQQ	ETF	30.84	30.91	30.77	30.88	1829900.0
2003-06-19 14:30:00	QQQ	ETF	30.88	30.92	30.77	30.78	1815100.0
2003-06-19 15:00:00	QQQ	ETF	30.77	30.79	30.5	30.569	8097500.0
2003-06-19 15:30:00	QQQ	ETF	30.573	30.6	30.38	30.48	9111500.0
2003-06-19 16:00:00	QQQ	ETF	30.491	30.5	30.37	30.41	2132600.0
2003-06-19 16:30:00	QQQ	ETF	30.41	30.41	30.38	30.41	118800.0
2003-06-19 17:00:00	QQQ	ETF	30.4	30.41	30.38	30.39	98600.0
2003-06-19 17:30:00	QQQ	ETF	30.4	30.41	30.38	30.4	10400.0
2003-06-19 18:00:00	QQQ	ETF	30.41	30.484	30.406	30.46	53100.0
2003-06-19 18:30:00	QQQ	ETF	30.45	30.46	30.43	30.44	20700.0
2003-06-19 19:00:00	QQQ	ETF	30.43	30.44	30.42	30.42	4400.0
2003-06-19 19:30:00	QQQ	ETF	30.44	30.46	30.41	30.42	11400.0
2003-06-19 20:00:00	QQQ	ETF	30.42	30.42	30.42	30.42	500.0

> showing 50 of 733 rows — these rows as CSV

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