PREVIEW / etf_30min / 2006-04-19

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-04-19.parquet
  size:    63 KB
  rows:    2,260

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-19 06:30:00	SPY	ETF	131.14	131.14	131.12	131.12	18400.0
2006-04-19 07:00:00	SPY	ETF	131.08	131.2	131.08	131.12	35300.0
2006-04-19 07:30:00	SPY	ETF	131.15	131.21	131.15	131.18	118500.0
2006-04-19 08:00:00	SPY	ETF	131.16	131.29	131.08	131.19	666300.0
2006-04-19 08:30:00	SPY	ETF	131.15	131.19	130.87	130.89	1455800.0
2006-04-19 09:00:00	SPY	ETF	130.87	130.99	130.71	130.74	2177000.0
2006-04-19 09:30:00	SPY	ETF	130.72	130.91	130.62	130.83	13934500.0
2006-04-19 10:00:00	SPY	ETF	130.84	130.98	130.38	130.49	13514800.0
2006-04-19 10:30:00	SPY	ETF	130.49	130.82	130.24	130.6	13917800.0
2006-04-19 11:00:00	SPY	ETF	130.6	130.87	130.58	130.76	6095400.0
2006-04-19 11:30:00	SPY	ETF	130.76	130.93	130.65	130.77	2355000.0
2006-04-19 12:00:00	SPY	ETF	130.77	131.05	130.75	130.97	2527900.0
2006-04-19 12:30:00	SPY	ETF	130.95	131.06	130.64	130.69	4233700.0
2006-04-19 13:00:00	SPY	ETF	130.69	130.87	130.55	130.63	5068600.0
2006-04-19 13:30:00	SPY	ETF	130.64	130.9	130.6	130.76	4399600.0
2006-04-19 14:00:00	SPY	ETF	130.76	130.9	130.53	130.81	4111500.0
2006-04-19 14:30:00	SPY	ETF	130.82	131.05	130.74	130.94	2241400.0
2006-04-19 15:00:00	SPY	ETF	130.95	131.07	130.92	130.95	3973200.0
2006-04-19 15:30:00	SPY	ETF	130.96	131.07	130.92	131.01	2704800.0
2006-04-19 16:00:00	SPY	ETF	130.99	131.0	130.75	130.91	940500.0
2006-04-19 16:30:00	SPY	ETF	130.93	131.05	130.78	131.04	808100.0
2006-04-19 17:00:00	SPY	ETF	131.02	131.02	130.95	130.95	72000.0
2006-04-19 17:30:00	SPY	ETF	130.95	130.98	130.9	130.9	2000.0
2006-04-19 18:00:00	SPY	ETF	130.94	130.94	130.9	130.9	1300.0
2006-04-19 18:30:00	SPY	ETF	130.9	130.9	130.9	130.9	3000.0
2006-04-19 19:00:00	SPY	ETF	130.93	130.93	130.89	130.89	600.0
2006-04-19 19:30:00	SPY	ETF	130.91	130.91	130.87	130.88	1700.0
2006-04-19 09:30:00	QQQ	ETF	42.54	42.65	42.47	42.53	9829200.0
2006-04-19 10:00:00	QQQ	ETF	42.52	42.59	42.38	42.42	7033300.0
2006-04-19 10:30:00	QQQ	ETF	42.42	42.45	42.3	42.39	9261200.0
2006-04-19 11:00:00	QQQ	ETF	42.39	42.5	42.39	42.45	4708000.0
2006-04-19 11:30:00	QQQ	ETF	42.45	42.52	42.41	42.47	3044200.0
2006-04-19 12:00:00	QQQ	ETF	42.46	42.55	42.46	42.51	3743400.0
2006-04-19 12:30:00	QQQ	ETF	42.51	42.55	42.43	42.45	3097300.0
2006-04-19 13:00:00	QQQ	ETF	42.45	42.49	42.37	42.41	4899700.0
2006-04-19 13:30:00	QQQ	ETF	42.42	42.52	42.4	42.51	2844200.0
2006-04-19 14:00:00	QQQ	ETF	42.51	42.54	42.41	42.52	4153300.0
2006-04-19 14:30:00	QQQ	ETF	42.51	42.58	42.44	42.54	4221900.0
2006-04-19 15:00:00	QQQ	ETF	42.54	42.63	42.53	42.57	6675200.0
2006-04-19 15:30:00	QQQ	ETF	42.57	42.64	42.55	42.64	6611000.0
2006-04-19 07:30:00	IWM	ETF	76.98	76.99	76.98	76.99	2100.0
2006-04-19 08:00:00	IWM	ETF	76.1	77.01	76.1	77.01	40800.0
2006-04-19 08:30:00	IWM	ETF	76.86	76.89	76.74	76.76	77100.0
2006-04-19 09:00:00	IWM	ETF	76.73	76.73	76.68	76.7	135900.0
2006-04-19 09:30:00	IWM	ETF	76.69	76.885	76.53	76.79	7149900.0
2006-04-19 10:00:00	IWM	ETF	76.79	76.94	76.45	76.49	4640000.0
2006-04-19 10:30:00	IWM	ETF	76.49	76.76	76.27	76.6	5601800.0
2006-04-19 11:00:00	IWM	ETF	76.6	76.82	76.6	76.75	1655700.0
2006-04-19 11:30:00	IWM	ETF	76.74	76.97	76.69	76.86	1639900.0
2006-04-19 12:00:00	IWM	ETF	76.87	77.17	76.85	77.1	1674900.0

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

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