PREVIEW / etf_30min / 2005-10-31

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-10-31.parquet
  size:    51 KB
  rows:    1,826

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-10-31 06:30:00	SPY	ETF	120.13	120.13	120.13	120.13	25000.0
2005-10-31 07:00:00	SPY	ETF	120.25	120.3	120.17	120.3	92000.0
2005-10-31 07:30:00	SPY	ETF	120.28	120.36	120.25	120.26	69100.0
2005-10-31 08:00:00	SPY	ETF	120.26	120.36	119.92	120.18	750700.0
2005-10-31 08:30:00	SPY	ETF	120.2	120.33	120.17	120.27	300800.0
2005-10-31 09:00:00	SPY	ETF	120.25	120.37	119.84	120.29	1122000.0
2005-10-31 09:30:00	SPY	ETF	120.29	120.94	120.2	120.86	15271100.0
2005-10-31 10:00:00	SPY	ETF	120.87	121.01	120.65	120.91	7944800.0
2005-10-31 10:30:00	SPY	ETF	120.94	120.97	120.71	120.75	3712800.0
2005-10-31 11:00:00	SPY	ETF	120.75	120.91	120.67	120.79	4029600.0
2005-10-31 11:30:00	SPY	ETF	120.78	120.82	120.64	120.66	2073300.0
2005-10-31 12:00:00	SPY	ETF	120.66	120.86	120.5	120.6	4107900.0
2005-10-31 12:30:00	SPY	ETF	120.6	120.8	120.5	120.72	2749500.0
2005-10-31 13:00:00	SPY	ETF	120.71	120.83	120.65	120.71	1588800.0
2005-10-31 13:30:00	SPY	ETF	120.7299	120.74	120.53	120.67	1805500.0
2005-10-31 14:00:00	SPY	ETF	120.66	120.91	120.58	120.74	4576900.0
2005-10-31 14:30:00	SPY	ETF	120.75	120.97	120.67	120.95	4063500.0
2005-10-31 15:00:00	SPY	ETF	120.94	121.22	120.94	121.15	5859800.0
2005-10-31 15:30:00	SPY	ETF	121.14	121.3	120.64	120.7	9918600.0
2005-10-31 16:00:00	SPY	ETF	120.7	120.82	120.12	120.16	5512500.0
2005-10-31 16:30:00	SPY	ETF	120.19	120.9836	120.13	120.15	1147900.0
2005-10-31 17:00:00	SPY	ETF	120.14	120.32	120.13	120.32	154400.0
2005-10-31 17:30:00	SPY	ETF	120.33	120.45	120.33	120.41	28300.0
2005-10-31 18:00:00	SPY	ETF	120.42	120.42	120.37	120.4	57600.0
2005-10-31 18:30:00	SPY	ETF	120.36	120.4	120.36	120.39	5300.0
2005-10-31 19:00:00	SPY	ETF	120.4	120.4	120.35	120.35	2000.0
2005-10-31 19:30:00	SPY	ETF	120.36	120.36	120.34	120.35	2000.0
2005-10-31 09:30:00	QQQ	ETF	38.43	38.69	38.42	38.68	22556200.0
2005-10-31 10:00:00	QQQ	ETF	38.68	38.91	38.65	38.89	16635500.0
2005-10-31 10:30:00	QQQ	ETF	38.89	38.92	38.83	38.84	10861400.0
2005-10-31 11:00:00	QQQ	ETF	38.83	38.9	38.79	38.88	4939300.0
2005-10-31 11:30:00	QQQ	ETF	38.87	38.88	38.81	38.81	2288400.0
2005-10-31 12:00:00	QQQ	ETF	38.81	38.87	38.77	38.79	3724100.0
2005-10-31 12:30:00	QQQ	ETF	38.79	38.82	38.73	38.8	4283300.0
2005-10-31 13:00:00	QQQ	ETF	38.8	38.89	38.78	38.85	4371400.0
2005-10-31 13:30:00	QQQ	ETF	38.85	38.87	38.76	38.82	2999100.0
2005-10-31 14:00:00	QQQ	ETF	38.82	38.88	38.79	38.85	4847500.0
2005-10-31 14:30:00	QQQ	ETF	38.85	38.94	38.82	38.91	5450000.0
2005-10-31 15:00:00	QQQ	ETF	38.91	39.0	38.9	38.99	6269900.0
2005-10-31 15:30:00	QQQ	ETF	38.99	39.05	38.84	38.86	13468800.0
2005-10-31 07:30:00	IWM	ETF	63.38	63.38	63.38	63.38	1000.0
2005-10-31 08:00:00	IWM	ETF	63.35	63.4	63.1	63.35	51400.0
2005-10-31 08:30:00	IWM	ETF	63.35	63.36	63.3	63.33	159700.0
2005-10-31 09:00:00	IWM	ETF	63.33	63.49	63.32	63.44	174200.0
2005-10-31 09:30:00	IWM	ETF	63.445	64.14	63.41	64.07	4278900.0
2005-10-31 10:00:00	IWM	ETF	64.06	64.29	63.94	64.27	2927800.0
2005-10-31 10:30:00	IWM	ETF	64.27	64.55	64.24	64.25	3480800.0
2005-10-31 11:00:00	IWM	ETF	64.25	64.27	64.13	64.25	1014300.0
2005-10-31 11:30:00	IWM	ETF	64.26	64.29	63.97	64.02	2396000.0
2005-10-31 12:00:00	IWM	ETF	64.02	64.21	63.9	64.03	1607300.0

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

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