PREVIEW / etf_30min / 2005-01-04

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-01-04.parquet
  size:    46 KB
  rows:    1,477

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-01-04 08:00:00	SPY	ETF	120.53	120.54	120.45	120.52	19900.0
2005-01-04 08:30:00	SPY	ETF	120.51	120.55	120.45	120.5	89700.0
2005-01-04 09:00:00	SPY	ETF	120.5	120.51	120.38	120.45	54500.0
2005-01-04 09:30:00	SPY	ETF	120.46	120.5	120.21	120.21	4530800.0
2005-01-04 10:00:00	SPY	ETF	120.22	120.54	119.98	120.1	6200800.0
2005-01-04 10:30:00	SPY	ETF	120.1	120.15	119.87	119.96	3979000.0
2005-01-04 11:00:00	SPY	ETF	119.97	120.06	119.79	120.0	5343100.0
2005-01-04 11:30:00	SPY	ETF	120.0	120.1	119.9	119.93	1904900.0
2005-01-04 12:00:00	SPY	ETF	119.93	119.97	119.51	119.63	5146000.0
2005-01-04 12:30:00	SPY	ETF	119.64	119.81	119.55	119.55	3028600.0
2005-01-04 13:00:00	SPY	ETF	119.55	119.79	119.53	119.65	1740400.0
2005-01-04 13:30:00	SPY	ETF	119.66	119.7	119.51	119.58	2617800.0
2005-01-04 14:00:00	SPY	ETF	119.57	119.57	118.76	118.88	10332400.0
2005-01-04 14:30:00	SPY	ETF	118.89	118.94	118.44	118.83	9350100.0
2005-01-04 15:00:00	SPY	ETF	118.84	118.93	118.63	118.75	5198800.0
2005-01-04 15:30:00	SPY	ETF	118.75	118.97	118.7	118.74	4500000.0
2005-01-04 16:00:00	SPY	ETF	118.75	118.86	118.7	118.73	3060600.0
2005-01-04 16:30:00	SPY	ETF	118.73	118.86	118.73	118.8	306600.0
2005-01-04 17:00:00	SPY	ETF	118.79	118.8	118.76	118.76	587900.0
2005-01-04 17:30:00	SPY	ETF	118.76	118.76	118.75	118.75	1100.0
2005-01-04 18:00:00	SPY	ETF	118.77	118.84	118.76	118.83	27200.0
2005-01-04 18:30:00	SPY	ETF	118.85	118.86	118.84	118.86	12200.0
2005-01-04 19:00:00	SPY	ETF	118.85	118.85	118.85	118.85	1000.0
2005-01-04 09:30:00	QQQ	ETF	39.69	39.71	39.55	39.56	10457700.0
2005-01-04 10:00:00	QQQ	ETF	39.56	39.74	39.49	39.57	10842200.0
2005-01-04 10:30:00	QQQ	ETF	39.57	39.67	39.28	39.32	10780400.0
2005-01-04 11:00:00	QQQ	ETF	39.32	39.38	39.25	39.34	9048700.0
2005-01-04 11:30:00	QQQ	ETF	39.34	39.4	39.28	39.3	4314800.0
2005-01-04 12:00:00	QQQ	ETF	39.3	39.65	39.0	39.04	10960100.0
2005-01-04 12:30:00	QQQ	ETF	39.05	39.11	39.0	39.04	5985800.0
2005-01-04 13:00:00	QQQ	ETF	39.05	39.1	39.01	39.05	4843800.0
2005-01-04 13:30:00	QQQ	ETF	39.05	39.08	38.96	38.97	3977600.0
2005-01-04 14:00:00	QQQ	ETF	38.98	39.0	38.67	38.73	18675200.0
2005-01-04 14:30:00	QQQ	ETF	38.73	38.75	38.55	38.69	15919800.0
2005-01-04 15:00:00	QQQ	ETF	38.69	39.68	38.66	38.75	13248300.0
2005-01-04 15:30:00	QQQ	ETF	38.75	39.06	38.74	38.79	11376400.0
2005-01-04 09:00:00	IWM	ETF	64.0	64.01	63.915	63.985	20600.0
2005-01-04 09:30:00	IWM	ETF	64.035	64.085	63.86	63.86	1763600.0
2005-01-04 10:00:00	IWM	ETF	63.87	64.03	63.545	63.565	1743400.0
2005-01-04 10:30:00	IWM	ETF	63.565	63.63	63.175	63.35	1832400.0
2005-01-04 11:00:00	IWM	ETF	63.355	63.42	63.13	63.39	2839200.0
2005-01-04 11:30:00	IWM	ETF	63.395	63.45	63.25	63.32	435800.0
2005-01-04 12:00:00	IWM	ETF	63.3	63.31	62.895	62.97	2689800.0
2005-01-04 12:30:00	IWM	ETF	62.97	63.2	62.955	63.01	573400.0
2005-01-04 13:00:00	IWM	ETF	63.045	63.115	62.995	63.02	416600.0
2005-01-04 13:30:00	IWM	ETF	63.01	63.15	62.995	63.01	204400.0
2005-01-04 14:00:00	IWM	ETF	62.99	62.99	62.535	62.585	3592800.0
2005-01-04 14:30:00	IWM	ETF	62.58	62.65	62.445	62.64	4062400.0
2005-01-04 15:00:00	IWM	ETF	62.64	62.745	62.44	62.44	2341400.0
2005-01-04 15:30:00	IWM	ETF	62.435	62.655	62.43	62.575	3015400.0

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

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