PREVIEW / etf_30min / 2005-11-01

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-11-01.parquet
  size:    48 KB
  rows:    1,736

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-11-01 04:00:00	SPY	ETF	120.55	120.55	120.55	120.55	800.0
2005-11-01 06:30:00	SPY	ETF	120.62	120.62	120.6	120.6	12000.0
2005-11-01 07:00:00	SPY	ETF	120.68	120.7	120.66	120.7	90400.0
2005-11-01 07:30:00	SPY	ETF	120.67	120.69	120.6	120.6	15500.0
2005-11-01 08:00:00	SPY	ETF	120.65	120.72	120.13	120.61	1348400.0
2005-11-01 08:30:00	SPY	ETF	120.58	120.66	120.13	120.61	476000.0
2005-11-01 09:00:00	SPY	ETF	120.62	120.67	120.13	120.58	95500.0
2005-11-01 09:30:00	SPY	ETF	120.58	120.69	120.36	120.39	9327100.0
2005-11-01 10:00:00	SPY	ETF	120.39	120.53	120.25	120.43	5044600.0
2005-11-01 10:30:00	SPY	ETF	120.43	120.64	120.3	120.57	4339400.0
2005-11-01 11:00:00	SPY	ETF	120.55	120.6	120.4	120.41	1865400.0
2005-11-01 11:30:00	SPY	ETF	120.41	120.51	120.37	120.46	1708200.0
2005-11-01 12:00:00	SPY	ETF	120.46	120.55	120.38	120.42	2629000.0
2005-11-01 12:30:00	SPY	ETF	120.43	120.51	120.38	120.44	1048700.0
2005-11-01 13:00:00	SPY	ETF	120.44	120.49	120.35	120.38	878000.0
2005-11-01 13:30:00	SPY	ETF	120.38	120.64	120.35	120.43	2454400.0
2005-11-01 14:00:00	SPY	ETF	120.42	120.81	120.27	120.72	12531000.0
2005-11-01 14:30:00	SPY	ETF	120.73	120.9	120.3	120.34	8821600.0
2005-11-01 15:00:00	SPY	ETF	120.34	120.51	120.22	120.42	4934300.0
2005-11-01 15:30:00	SPY	ETF	120.43	120.57	120.3	120.3	5341300.0
2005-11-01 16:00:00	SPY	ETF	120.31	120.53	120.3	120.44	515200.0
2005-11-01 16:30:00	SPY	ETF	120.46	120.46	120.4023	120.4023	25100.0
2005-11-01 17:00:00	SPY	ETF	120.43	120.49	120.37	120.44	599400.0
2005-11-01 17:30:00	SPY	ETF	120.41	120.47	120.41	120.47	4000.0
2005-11-01 18:00:00	SPY	ETF	120.47	120.48	120.42	120.48	2900.0
2005-11-01 18:30:00	SPY	ETF	120.49	120.49	120.47	120.47	200.0
2005-11-01 19:00:00	SPY	ETF	120.47	120.47	120.47	120.47	100.0
2005-11-01 09:30:00	QQQ	ETF	38.76	39.82	38.75	38.79	13362600.0
2005-11-01 10:00:00	QQQ	ETF	38.8	38.84	38.71	38.76	7040100.0
2005-11-01 10:30:00	QQQ	ETF	38.76	38.87	38.74	38.85	4509800.0
2005-11-01 11:00:00	QQQ	ETF	38.84	38.85	38.76	38.76	3243500.0
2005-11-01 11:30:00	QQQ	ETF	38.76	38.83	38.75	38.82	2075200.0
2005-11-01 12:00:00	QQQ	ETF	38.82	38.88	38.78	38.8	4166800.0
2005-11-01 12:30:00	QQQ	ETF	38.8	38.84	38.79	38.82	1153600.0
2005-11-01 13:00:00	QQQ	ETF	38.83	38.85	38.79	38.82	1509300.0
2005-11-01 13:30:00	QQQ	ETF	38.82	38.83	38.78	38.83	1818000.0
2005-11-01 14:00:00	QQQ	ETF	38.83	38.96	38.78	38.93	9968000.0
2005-11-01 14:30:00	QQQ	ETF	38.93	39.01	38.81	38.83	11229600.0
2005-11-01 15:00:00	QQQ	ETF	38.83	38.9	38.76	38.84	6436600.0
2005-11-01 15:30:00	QQQ	ETF	38.85	38.88	38.81	38.84	4976300.0
2005-11-01 07:30:00	IWM	ETF	63.92	63.92	63.92	63.92	1000.0
2005-11-01 08:00:00	IWM	ETF	63.96	63.96	63.78	63.95	408100.0
2005-11-01 08:30:00	IWM	ETF	63.95	64.02	63.78	64.01	508500.0
2005-11-01 09:00:00	IWM	ETF	64.01	64.06	63.97	64.05	186400.0
2005-11-01 09:30:00	IWM	ETF	64.05	64.1	63.65	63.68	3413900.0
2005-11-01 10:00:00	IWM	ETF	63.68	63.96	63.6	63.9	5375100.0
2005-11-01 10:30:00	IWM	ETF	63.9	63.95	63.66	63.93	3393200.0
2005-11-01 11:00:00	IWM	ETF	63.94	63.94	63.78	63.88	743700.0
2005-11-01 11:30:00	IWM	ETF	63.87	63.95	63.83	63.95	1474400.0
2005-11-01 12:00:00	IWM	ETF	63.95	64.08	63.88	63.9	2236100.0

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

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