PREVIEW / etf_30min / 2005-09-28

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-09-28.parquet
  size:    48 KB
  rows:    1,702

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
2005-09-28 07:00:00	SPY	ETF	121.93	121.96	121.93	121.94	19400.0
2005-09-28 07:30:00	SPY	ETF	121.93	121.99	121.92	121.92	17700.0
2005-09-28 08:00:00	SPY	ETF	121.96	121.99	121.8	121.8	346100.0
2005-09-28 08:30:00	SPY	ETF	121.82	122.02	121.8	121.94	311900.0
2005-09-28 09:00:00	SPY	ETF	121.93	121.95	121.87	121.87	276900.0
2005-09-28 09:30:00	SPY	ETF	121.91	122.02	121.85	121.98	3645600.0
2005-09-28 10:00:00	SPY	ETF	121.97	122.02	121.83	121.93	3564000.0
2005-09-28 10:30:00	SPY	ETF	121.94	122.12	121.88	122.0	4080000.0
2005-09-28 11:00:00	SPY	ETF	122.01	122.04	121.9	122.0	1583600.0
2005-09-28 11:30:00	SPY	ETF	122.0	122.01	121.56	121.66	4158600.0
2005-09-28 12:00:00	SPY	ETF	121.66	121.7	121.31	121.43	4052500.0
2005-09-28 12:30:00	SPY	ETF	121.43	121.54	121.41	121.5	1310000.0
2005-09-28 13:00:00	SPY	ETF	121.5	121.59	121.39	121.42	1260000.0
2005-09-28 13:30:00	SPY	ETF	121.42	121.42	121.2	121.4	5417400.0
2005-09-28 14:00:00	SPY	ETF	121.38	122.01	121.38	121.94	7736400.0
2005-09-28 14:30:00	SPY	ETF	121.93	121.97	121.77	121.84	6017500.0
2005-09-28 15:00:00	SPY	ETF	121.84	121.94	121.71	121.76	7476800.0
2005-09-28 15:30:00	SPY	ETF	121.77	121.93	121.65	121.68	5093800.0
2005-09-28 16:00:00	SPY	ETF	121.7	121.74	121.64	121.65	569900.0
2005-09-28 16:30:00	SPY	ETF	121.67	121.75	121.64	121.72	242400.0
2005-09-28 17:00:00	SPY	ETF	121.73	121.74	121.71	121.71	1900.0
2005-09-28 17:30:00	SPY	ETF	121.7861	121.7861	121.71	121.73	11500.0
2005-09-28 18:00:00	SPY	ETF	121.75	121.7861	121.71	121.72	12100.0
2005-09-28 18:30:00	SPY	ETF	121.7	121.7	121.69	121.69	800.0
2005-09-28 19:30:00	SPY	ETF	121.72	121.72	121.72	121.72	100.0
2005-09-28 09:30:00	QQQ	ETF	38.77	38.85	38.76	38.85	8772200.0
2005-09-28 10:00:00	QQQ	ETF	38.85	38.88	38.81	38.86	6590800.0
2005-09-28 10:30:00	QQQ	ETF	38.86	38.95	38.82	38.86	8932500.0
2005-09-28 11:00:00	QQQ	ETF	38.86	38.9	38.81	38.85	2436600.0
2005-09-28 11:30:00	QQQ	ETF	38.85	38.85	38.7	38.73	5514000.0
2005-09-28 12:00:00	QQQ	ETF	38.74	38.75	38.57	38.61	6580700.0
2005-09-28 12:30:00	QQQ	ETF	38.62	38.7	38.6	38.65	5070200.0
2005-09-28 13:00:00	QQQ	ETF	38.65	38.68	38.6	38.61	1838100.0
2005-09-28 13:30:00	QQQ	ETF	38.6	38.67	38.56	38.65	4717800.0
2005-09-28 14:00:00	QQQ	ETF	38.65	38.83	38.65	38.81	5013100.0
2005-09-28 14:30:00	QQQ	ETF	38.8	38.85	38.77	38.78	4047100.0
2005-09-28 15:00:00	QQQ	ETF	38.78	38.81	38.7	38.73	4228000.0
2005-09-28 15:30:00	QQQ	ETF	38.72	38.78	38.67	38.67	4300000.0
2005-09-28 08:00:00	IWM	ETF	65.6	65.64	65.6	65.64	42700.0
2005-09-28 08:30:00	IWM	ETF	65.62	65.7	65.6	65.6	38400.0
2005-09-28 09:00:00	IWM	ETF	65.62	65.62	65.6	65.6	32400.0
2005-09-28 09:30:00	IWM	ETF	65.57	65.63	65.28	65.44	1684200.0
2005-09-28 10:00:00	IWM	ETF	65.44	65.52	65.3	65.49	1571700.0
2005-09-28 10:30:00	IWM	ETF	65.5	65.64	65.46	65.56	975600.0
2005-09-28 11:00:00	IWM	ETF	65.56	65.59	65.35	65.42	680400.0
2005-09-28 11:30:00	IWM	ETF	65.43	65.44	65.15	65.18	1740600.0
2005-09-28 12:00:00	IWM	ETF	65.18	65.21	64.92	65.02	2975000.0
2005-09-28 12:30:00	IWM	ETF	65.01	65.1	64.98	65.03	532100.0
2005-09-28 13:00:00	IWM	ETF	65.03	65.13	64.9	64.91	1032900.0
2005-09-28 13:30:00	IWM	ETF	64.91	64.91	64.74	64.9	2494500.0

> showing 50 of 1,702 rows — these rows as CSV

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