PREVIEW / etf_30min / 2006-04-18

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-04-18.parquet
  size:    65 KB
  rows:    2,237

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
2006-04-18 06:00:00	SPY	ETF	128.78	128.78	128.78	128.78	3000.0
2006-04-18 07:00:00	SPY	ETF	128.76	128.83	128.75	128.8	31200.0
2006-04-18 07:30:00	SPY	ETF	128.8	128.95	128.8	128.89	42700.0
2006-04-18 08:00:00	SPY	ETF	128.88	129.02	128.74	128.99	669500.0
2006-04-18 08:30:00	SPY	ETF	128.98	129.1	128.78	129.0	1941800.0
2006-04-18 09:00:00	SPY	ETF	128.99	129.04	128.94	128.96	726100.0
2006-04-18 09:30:00	SPY	ETF	128.95	129.29	128.93	129.26	6608500.0
2006-04-18 10:00:00	SPY	ETF	129.2574	129.39	129.14	129.15	4753600.0
2006-04-18 10:30:00	SPY	ETF	129.16	129.32	129.11	129.12	2560800.0
2006-04-18 11:00:00	SPY	ETF	129.12	129.51	129.11	129.48	3830200.0
2006-04-18 11:30:00	SPY	ETF	129.47	129.89	129.43	129.86	9079500.0
2006-04-18 12:00:00	SPY	ETF	129.86	130.07	129.81	129.96	6096300.0
2006-04-18 12:30:00	SPY	ETF	129.97	130.06	129.85	130.04	3010300.0
2006-04-18 13:00:00	SPY	ETF	130.06	130.18	129.98	130.01	3983400.0
2006-04-18 13:30:00	SPY	ETF	130.01	130.06	129.75	129.84	4272700.0
2006-04-18 14:00:00	SPY	ETF	129.84	130.67	129.84	130.28	14024400.0
2006-04-18 14:30:00	SPY	ETF	130.28	130.5	130.09	130.38	6379200.0
2006-04-18 15:00:00	SPY	ETF	130.38	130.9	130.36	130.76	8214900.0
2006-04-18 15:30:00	SPY	ETF	130.75	130.94	130.7	130.73	9944600.0
2006-04-18 16:00:00	SPY	ETF	130.72	130.89	130.65	130.72	1743500.0
2006-04-18 16:30:00	SPY	ETF	130.72	130.98	130.68	130.95	954800.0
2006-04-18 17:00:00	SPY	ETF	130.99	131.0	130.91	130.98	881600.0
2006-04-18 17:30:00	SPY	ETF	130.93	130.98	130.92	130.94	10800.0
2006-04-18 18:00:00	SPY	ETF	130.95	130.98	130.86	130.86	119200.0
2006-04-18 18:30:00	SPY	ETF	130.89	130.91	130.88	130.91	8500.0
2006-04-18 19:00:00	SPY	ETF	130.89	130.89	130.89	130.89	20000.0
2006-04-18 09:30:00	QQQ	ETF	41.78	41.92	41.77	41.91	8887900.0
2006-04-18 10:00:00	QQQ	ETF	41.92	41.94	41.81	41.81	4913600.0
2006-04-18 10:30:00	QQQ	ETF	41.85	41.94	41.81	41.82	3250600.0
2006-04-18 11:00:00	QQQ	ETF	41.82	41.95	41.81	41.92	5742900.0
2006-04-18 11:30:00	QQQ	ETF	41.93	42.1	41.91	42.1	8228300.0
2006-04-18 12:00:00	QQQ	ETF	42.1	42.27	42.08	42.24	11455100.0
2006-04-18 12:30:00	QQQ	ETF	42.23	42.3	42.19	42.3	6589700.0
2006-04-18 13:00:00	QQQ	ETF	42.29	42.39	42.28	42.32	6459100.0
2006-04-18 13:30:00	QQQ	ETF	42.32	42.33	42.13	42.21	9241300.0
2006-04-18 14:00:00	QQQ	ETF	42.19	42.56	42.19	42.36	20027800.0
2006-04-18 14:30:00	QQQ	ETF	42.37	42.39	42.27	42.34	5000600.0
2006-04-18 15:00:00	QQQ	ETF	42.35	42.49	42.32	42.43	9501800.0
2006-04-18 15:30:00	QQQ	ETF	42.43	42.52	42.42	42.46	12180000.0
2006-04-18 08:00:00	IWM	ETF	74.73	74.76	74.73	74.74	17500.0
2006-04-18 08:30:00	IWM	ETF	74.71	74.83	74.71	74.8	56800.0
2006-04-18 09:00:00	IWM	ETF	74.7	74.81	74.7	74.78	118600.0
2006-04-18 09:30:00	IWM	ETF	74.81	75.15	74.8	75.15	6072500.0
2006-04-18 10:00:00	IWM	ETF	75.15	75.28	75.06	75.12	2165100.0
2006-04-18 10:30:00	IWM	ETF	75.11	75.33	75.11	75.18	2304800.0
2006-04-18 11:00:00	IWM	ETF	75.17	75.5	75.15	75.47	2981300.0
2006-04-18 11:30:00	IWM	ETF	75.47	75.77	75.45	75.76	5715300.0
2006-04-18 12:00:00	IWM	ETF	75.76	75.8	75.68	75.73	3870600.0
2006-04-18 12:30:00	IWM	ETF	75.72	75.85	75.65	75.81	2653000.0
2006-04-18 13:00:00	IWM	ETF	75.82	75.95	75.765	75.89	3773500.0

> showing 50 of 2,237 rows — these rows as CSV

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