PREVIEW / etf_30min / 2005-09-23

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-09-23.parquet
  size:    47 KB
  rows:    1,653

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-23 06:00:00	SPY	ETF	121.44	121.44	121.39	121.39	5500.0
2005-09-23 06:30:00	SPY	ETF	121.43	121.53	121.43	121.52	69700.0
2005-09-23 07:00:00	SPY	ETF	121.53	121.53	121.45	121.48	42100.0
2005-09-23 07:30:00	SPY	ETF	121.49	121.5	121.49	121.5	13400.0
2005-09-23 08:00:00	SPY	ETF	121.54	121.54	121.28	121.34	1951200.0
2005-09-23 08:30:00	SPY	ETF	121.36	121.44	121.3	121.43	322300.0
2005-09-23 09:00:00	SPY	ETF	121.4	121.42	121.25	121.25	192900.0
2005-09-23 09:30:00	SPY	ETF	121.24	121.35	120.9	121.0	8923500.0
2005-09-23 10:00:00	SPY	ETF	120.98	121.3	120.94	121.25	7222000.0
2005-09-23 10:30:00	SPY	ETF	121.25	121.29	121.0	121.27	3193700.0
2005-09-23 11:00:00	SPY	ETF	121.27	121.47	121.2	121.34	5696800.0
2005-09-23 11:30:00	SPY	ETF	121.33	121.45	121.22	121.4	2014500.0
2005-09-23 12:00:00	SPY	ETF	121.4	121.43	121.28	121.3	2398900.0
2005-09-23 12:30:00	SPY	ETF	121.29	121.34	121.22	121.3	801400.0
2005-09-23 13:00:00	SPY	ETF	121.31	121.43	121.25	121.27	1578200.0
2005-09-23 13:30:00	SPY	ETF	121.27	121.89	121.27	121.83	7525200.0
2005-09-23 14:00:00	SPY	ETF	121.86	121.88	121.67	121.69	5021300.0
2005-09-23 14:30:00	SPY	ETF	121.68	121.79	121.6	121.75	2666000.0
2005-09-23 15:00:00	SPY	ETF	121.76	121.78	121.51	121.64	2463800.0
2005-09-23 15:30:00	SPY	ETF	121.66	121.68	121.46	121.56	5377000.0
2005-09-23 16:00:00	SPY	ETF	121.64	121.87	121.44	121.52	649200.0
2005-09-23 16:30:00	SPY	ETF	121.52	121.57	121.47	121.57	51800.0
2005-09-23 17:00:00	SPY	ETF	121.52	121.52	121.52	121.52	1200.0
2005-09-23 17:30:00	SPY	ETF	121.55	121.58	121.55	121.58	800.0
2005-09-23 18:00:00	SPY	ETF	121.58	121.58	121.58	121.58	300.0
2005-09-23 18:30:00	SPY	ETF	121.58	121.58	121.58	121.58	600.0
2005-09-23 19:00:00	SPY	ETF	121.58	121.58	121.58	121.58	600.0
2005-09-23 09:30:00	QQQ	ETF	38.51	38.54	38.41	38.47	9825900.0
2005-09-23 10:00:00	QQQ	ETF	38.47	38.62	38.46	38.59	6225800.0
2005-09-23 10:30:00	QQQ	ETF	38.59	38.6	38.48	38.59	3126400.0
2005-09-23 11:00:00	QQQ	ETF	38.58	38.68	38.56	38.6	6836200.0
2005-09-23 11:30:00	QQQ	ETF	38.59	38.67	38.57	38.66	3404700.0
2005-09-23 12:00:00	QQQ	ETF	38.66	38.66	38.57	38.58	1952600.0
2005-09-23 12:30:00	QQQ	ETF	38.58	38.61	38.56	38.61	1742100.0
2005-09-23 13:00:00	QQQ	ETF	38.6	38.65	38.58	38.59	1543400.0
2005-09-23 13:30:00	QQQ	ETF	38.6	38.88	38.59	38.86	8883000.0
2005-09-23 14:00:00	QQQ	ETF	38.86	38.87	38.79	38.8	4791200.0
2005-09-23 14:30:00	QQQ	ETF	38.79	38.86	38.79	38.84	3258900.0
2005-09-23 15:00:00	QQQ	ETF	38.83	38.85	38.72	38.79	3492100.0
2005-09-23 15:30:00	QQQ	ETF	38.78	38.79	38.7	38.76	7532600.0
2005-09-23 07:00:00	IWM	ETF	64.87	64.87	64.76	64.76	10000.0
2005-09-23 07:30:00	IWM	ETF	64.84	64.85	64.84	64.85	6100.0
2005-09-23 08:00:00	IWM	ETF	64.87	64.87	64.74	64.77	638300.0
2005-09-23 08:30:00	IWM	ETF	64.78	64.79	64.72	64.75	23100.0
2005-09-23 09:00:00	IWM	ETF	64.8	64.8	64.62	64.62	12800.0
2005-09-23 09:30:00	IWM	ETF	64.61	64.7	64.24	64.29	2237400.0
2005-09-23 10:00:00	IWM	ETF	64.27	64.55	64.24	64.55	3177000.0
2005-09-23 10:30:00	IWM	ETF	64.54	64.61	64.42	64.61	1169800.0
2005-09-23 11:00:00	IWM	ETF	64.61	64.84	64.59	64.77	3202400.0
2005-09-23 11:30:00	IWM	ETF	64.77	64.8	64.67	64.79	1764400.0

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

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