PREVIEW / etf_30min / 2005-01-14

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-01-14.parquet
  size:    41 KB
  rows:    1,405

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-14 08:00:00	SPY	ETF	117.83	117.87	117.77	117.77	100800.0
2005-01-14 08:30:00	SPY	ETF	117.8	118.08	117.8	117.97	113700.0
2005-01-14 09:00:00	SPY	ETF	117.97	118.09	117.9	117.94	311800.0
2005-01-14 09:30:00	SPY	ETF	117.97	118.07	117.76	118.05	6811200.0
2005-01-14 10:00:00	SPY	ETF	118.03	118.34	117.8	118.32	5013200.0
2005-01-14 10:30:00	SPY	ETF	118.32	118.4	118.14	118.2	4289600.0
2005-01-14 11:00:00	SPY	ETF	118.2	118.32	118.18	118.24	1354700.0
2005-01-14 11:30:00	SPY	ETF	118.26	118.3	118.04	118.11	2135200.0
2005-01-14 12:00:00	SPY	ETF	118.12	118.37	118.09	118.35	2442500.0
2005-01-14 12:30:00	SPY	ETF	118.35	118.5	118.33	118.33	3136400.0
2005-01-14 13:00:00	SPY	ETF	118.33	118.39	118.2	118.32	2059900.0
2005-01-14 13:30:00	SPY	ETF	118.32	118.34	118.21	118.22	1104500.0
2005-01-14 14:00:00	SPY	ETF	118.22	118.35	118.12	118.25	2106800.0
2005-01-14 14:30:00	SPY	ETF	118.25	118.48	118.25	118.42	1909900.0
2005-01-14 15:00:00	SPY	ETF	118.42	118.45	118.29	118.35	1647400.0
2005-01-14 15:30:00	SPY	ETF	118.35	118.53	118.34	118.42	4274600.0
2005-01-14 16:00:00	SPY	ETF	118.4	118.45	118.2	118.28	1968400.0
2005-01-14 16:30:00	SPY	ETF	118.28	118.29	118.27	118.29	39200.0
2005-01-14 17:00:00	SPY	ETF	118.33	118.36	118.33	118.36	1700.0
2005-01-14 17:30:00	SPY	ETF	118.37	118.38	118.37	118.38	300.0
2005-01-14 18:30:00	SPY	ETF	118.36	118.36	118.36	118.36	300.0
2005-01-14 19:00:00	SPY	ETF	118.33	118.33	118.33	118.33	300.0
2005-01-14 09:30:00	QQQ	ETF	38.19	38.33	38.19	38.27	12454300.0
2005-01-14 10:00:00	QQQ	ETF	38.27	38.45	38.19	38.42	9220900.0
2005-01-14 10:30:00	QQQ	ETF	38.43	38.52	38.39	38.42	13600200.0
2005-01-14 11:00:00	QQQ	ETF	38.42	38.46	38.38	38.42	4342600.0
2005-01-14 11:30:00	QQQ	ETF	38.43	38.45	38.34	38.36	3329300.0
2005-01-14 12:00:00	QQQ	ETF	38.36	38.48	38.36	38.48	4273400.0
2005-01-14 12:30:00	QQQ	ETF	38.48	38.51	38.41	38.41	2845100.0
2005-01-14 13:00:00	QQQ	ETF	38.42	38.44	38.35	38.38	3067000.0
2005-01-14 13:30:00	QQQ	ETF	38.38	38.39	38.15	38.36	3413700.0
2005-01-14 14:00:00	QQQ	ETF	38.36	38.43	38.34	38.37	5148000.0
2005-01-14 14:30:00	QQQ	ETF	38.37	38.5	38.36	38.47	3905900.0
2005-01-14 15:00:00	QQQ	ETF	38.47	38.47	38.37	38.4	3292200.0
2005-01-14 15:30:00	QQQ	ETF	38.4	38.48	38.39	38.44	6933600.0
2005-01-14 08:00:00	IWM	ETF	61.035	61.035	61.035	61.035	800.0
2005-01-14 08:30:00	IWM	ETF	61.115	61.115	61.115	61.115	200.0
2005-01-14 09:00:00	IWM	ETF	61.06	61.06	61.04	61.04	2200.0
2005-01-14 09:30:00	IWM	ETF	61.045	61.25	60.915	61.15	2303200.0
2005-01-14 10:00:00	IWM	ETF	61.17	61.39	60.965	61.39	699000.0
2005-01-14 10:30:00	IWM	ETF	61.385	61.385	61.05	61.105	2123400.0
2005-01-14 11:00:00	IWM	ETF	61.1	61.195	61.085	61.165	384800.0
2005-01-14 11:30:00	IWM	ETF	61.165	61.215	61.08	61.11	605800.0
2005-01-14 12:00:00	IWM	ETF	61.13	61.3	61.13	61.275	709400.0
2005-01-14 12:30:00	IWM	ETF	61.3	61.36	61.23	61.23	533200.0
2005-01-14 13:00:00	IWM	ETF	61.22	61.315	61.18	61.255	221800.0
2005-01-14 13:30:00	IWM	ETF	61.255	61.255	61.135	61.135	262600.0
2005-01-14 14:00:00	IWM	ETF	61.125	61.215	61.03	61.07	867600.0
2005-01-14 14:30:00	IWM	ETF	61.085	61.325	61.085	61.27	559800.0
2005-01-14 15:00:00	IWM	ETF	61.28	61.28	61.175	61.24	1051800.0

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

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