PREVIEW / etf_30min / 2006-06-07

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-07.parquet
  size:    68 KB
  rows:    2,395

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-06-07 04:30:00	SPY	ETF	126.74	126.74	126.74	126.74	2000.0
2006-06-07 06:00:00	SPY	ETF	126.95	126.95	126.95	126.95	2000.0
2006-06-07 06:30:00	SPY	ETF	126.99	126.99	126.99	126.99	200.0
2006-06-07 07:00:00	SPY	ETF	127.05	127.09	127.01	127.02	31200.0
2006-06-07 07:30:00	SPY	ETF	127.07	127.11	127.07	127.08	13100.0
2006-06-07 08:00:00	SPY	ETF	127.07	127.2	127.05	127.06	968200.0
2006-06-07 08:30:00	SPY	ETF	127.04	127.05	126.6	127.02	660200.0
2006-06-07 09:00:00	SPY	ETF	127.02	127.05	126.9	126.92	762600.0
2006-06-07 09:30:00	SPY	ETF	126.91	126.96	126.44	126.7	10224600.0
2006-06-07 10:00:00	SPY	ETF	126.7	127.34	126.69	127.28	14341800.0
2006-06-07 10:30:00	SPY	ETF	127.28	127.38	126.91	127.05	8027000.0
2006-06-07 11:00:00	SPY	ETF	127.05	127.2	126.96	127.03	3064400.0
2006-06-07 11:30:00	SPY	ETF	127.03	127.56	127.01	127.5109	4211300.0
2006-06-07 12:00:00	SPY	ETF	127.52	127.65	127.44	127.49	4962500.0
2006-06-07 12:30:00	SPY	ETF	127.49	127.51	127.19	127.24	4769900.0
2006-06-07 13:00:00	SPY	ETF	127.24	127.37	127.16	127.28	5151000.0
2006-06-07 13:30:00	SPY	ETF	127.28	127.3	126.92	127.11	8036300.0
2006-06-07 14:00:00	SPY	ETF	127.09	127.1	126.65	126.99	8080700.0
2006-06-07 14:30:00	SPY	ETF	126.99	127.5	126.69	126.87	5200300.0
2006-06-07 15:00:00	SPY	ETF	126.86	126.97	126.25	126.25	7168300.0
2006-06-07 15:30:00	SPY	ETF	126.27	127.5	125.9	125.9	16401600.0
2006-06-07 16:00:00	SPY	ETF	125.89	126.0367	125.76	125.9	2045800.0
2006-06-07 16:30:00	SPY	ETF	125.9	125.9	125.65	125.67	1478000.0
2006-06-07 17:00:00	SPY	ETF	125.72	125.77	125.66	125.67	1064900.0
2006-06-07 17:30:00	SPY	ETF	125.66	125.77	125.66	125.75	7700.0
2006-06-07 18:00:00	SPY	ETF	125.75	125.84	125.74	125.83	93700.0
2006-06-07 18:30:00	SPY	ETF	125.82	125.82	125.73	125.73	15500.0
2006-06-07 19:00:00	SPY	ETF	125.8	125.82	125.78	125.82	6100.0
2006-06-07 19:30:00	SPY	ETF	125.81	125.81	125.7	125.78	3300.0
2006-06-07 09:30:00	QQQ	ETF	38.8	38.83	38.64	38.75	13222000.0
2006-06-07 10:00:00	QQQ	ETF	38.76	39.06	38.75	38.99	18699300.0
2006-06-07 10:30:00	QQQ	ETF	38.99	39.05	38.84	38.92	7946600.0
2006-06-07 11:00:00	QQQ	ETF	38.92	39.01	38.87	38.89	6077500.0
2006-06-07 11:30:00	QQQ	ETF	38.9	39.11	38.88	39.09	7170700.0
2006-06-07 12:00:00	QQQ	ETF	39.1	39.17	39.0	39.07	6607300.0
2006-06-07 12:30:00	QQQ	ETF	39.06	39.07	38.9	38.93	4558700.0
2006-06-07 13:00:00	QQQ	ETF	38.92	39.07	38.9	38.98	3533300.0
2006-06-07 13:30:00	QQQ	ETF	38.98	38.98	38.85	38.89	6024400.0
2006-06-07 14:00:00	QQQ	ETF	38.89	38.89	38.67	38.82	12464600.0
2006-06-07 14:30:00	QQQ	ETF	38.82	38.85	38.72	38.76	4926800.0
2006-06-07 15:00:00	QQQ	ETF	38.76	38.81	38.54	38.55	11216800.0
2006-06-07 15:30:00	QQQ	ETF	38.54	38.61	38.45	38.45	12915600.0
2006-06-07 08:00:00	IWM	ETF	71.05	71.13	71.01	71.03	20700.0
2006-06-07 08:30:00	IWM	ETF	71.05	71.05	70.99	71.02	21400.0
2006-06-07 09:00:00	IWM	ETF	71.01	71.01	70.8	70.82	249400.0
2006-06-07 09:30:00	IWM	ETF	70.82	70.85	70.17	70.51	6471200.0
2006-06-07 10:00:00	IWM	ETF	70.52	71.48	70.51	71.4	10746100.0
2006-06-07 10:30:00	IWM	ETF	71.4	71.55	71.01	71.21	5394900.0
2006-06-07 11:00:00	IWM	ETF	71.2	71.4	71.12	71.17	3944100.0
2006-06-07 11:30:00	IWM	ETF	71.17	71.66	71.15	71.66	3487700.0

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

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