PREVIEW / etf_30min / 2002-03-14

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-03-14.parquet
  size:    17 KB
  rows:    468

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
2002-03-14 09:30:00	SPY	ETF	116.04	116.29	115.85	116.01	1449000.0
2002-03-14 10:00:00	SPY	ETF	115.97	116.02	115.67	115.9	1404700.0
2002-03-14 10:30:00	SPY	ETF	115.9	116.28	115.82	116.2	1176500.0
2002-03-14 11:00:00	SPY	ETF	116.22	116.43	116.11	116.23	1008200.0
2002-03-14 11:30:00	SPY	ETF	116.23	116.39	116.15	116.3	609900.0
2002-03-14 12:00:00	SPY	ETF	116.3	116.32	116.08	116.15	237600.0
2002-03-14 12:30:00	SPY	ETF	116.16	116.29	116.06	116.25	229100.0
2002-03-14 13:00:00	SPY	ETF	116.3	116.3	115.94	116.03	324400.0
2002-03-14 13:30:00	SPY	ETF	116.01	116.11	115.86	115.94	440100.0
2002-03-14 14:00:00	SPY	ETF	115.95	115.99	115.63	115.73	680400.0
2002-03-14 14:30:00	SPY	ETF	115.76	116.09	115.66	116.04	552600.0
2002-03-14 15:00:00	SPY	ETF	116.05	116.17	115.8	115.96	831900.0
2002-03-14 15:30:00	SPY	ETF	115.98	116.02	115.75	115.86	1065300.0
2002-03-14 16:00:00	SPY	ETF	115.86	115.93	115.8	115.92	761700.0
2002-03-14 16:30:00	SPY	ETF	115.8	115.92	115.8	115.92	105000.0
2002-03-14 17:30:00	SPY	ETF	115.84	115.85	115.8	115.8	1500.0
2002-03-14 09:30:00	QQQ	ETF	37.06	37.33	37.0	37.11	10738100.0
2002-03-14 10:00:00	QQQ	ETF	37.1	37.16	36.82	37.07	8183400.0
2002-03-14 10:30:00	QQQ	ETF	37.08	37.33	37.01	37.28	5431700.0
2002-03-14 11:00:00	QQQ	ETF	37.25	37.4	37.22	37.26	5733700.0
2002-03-14 11:30:00	QQQ	ETF	37.27	37.33	37.17	37.3	2745600.0
2002-03-14 12:00:00	QQQ	ETF	37.31	37.33	37.12	37.18	1709700.0
2002-03-14 12:30:00	QQQ	ETF	37.19	37.24	37.06	37.22	1243300.0
2002-03-14 13:00:00	QQQ	ETF	37.21	37.23	36.98	37.06	2022600.0
2002-03-14 13:30:00	QQQ	ETF	37.06	37.11	36.9	36.98	3199800.0
2002-03-14 14:00:00	QQQ	ETF	36.99	37.02	36.72	36.77	7638200.0
2002-03-14 14:30:00	QQQ	ETF	36.76	37.0	36.74	36.97	6463500.0
2002-03-14 15:00:00	QQQ	ETF	37.0	37.09	36.81	36.93	5501400.0
2002-03-14 15:30:00	QQQ	ETF	36.94	36.94	36.75	36.81	5649200.0
2002-03-14 16:00:00	QQQ	ETF	36.82	36.94	36.75	36.89	1763900.0
2002-03-14 16:30:00	QQQ	ETF	36.9	36.98	36.79	36.85	120700.0
2002-03-14 17:00:00	QQQ	ETF	36.83	36.89	36.82	36.86	15900.0
2002-03-14 17:30:00	QQQ	ETF	36.82	36.84	36.65	36.66	427400.0
2002-03-14 18:00:00	QQQ	ETF	36.67	36.71	36.66	36.7	42600.0
2002-03-14 09:30:00	IWM	ETF	49.375	49.42	49.23	49.285	38200.0
2002-03-14 10:00:00	IWM	ETF	49.285	49.285	48.755	49.245	351000.0
2002-03-14 10:30:00	IWM	ETF	49.25	49.465	49.2	49.465	85200.0
2002-03-14 11:00:00	IWM	ETF	49.49	49.615	49.425	49.605	72000.0
2002-03-14 11:30:00	IWM	ETF	49.535	49.615	49.495	49.615	43000.0
2002-03-14 12:00:00	IWM	ETF	49.545	49.615	49.515	49.58	81400.0
2002-03-14 12:30:00	IWM	ETF	49.58	49.58	49.465	49.56	124600.0
2002-03-14 13:00:00	IWM	ETF	49.485	49.56	49.46	49.52	65000.0
2002-03-14 13:30:00	IWM	ETF	49.445	49.5	49.385	49.385	9600.0
2002-03-14 14:00:00	IWM	ETF	49.385	49.42	49.3	49.3	277200.0
2002-03-14 14:30:00	IWM	ETF	49.285	49.49	49.285	49.49	55600.0
2002-03-14 15:00:00	IWM	ETF	49.51	49.51	49.345	49.415	19200.0
2002-03-14 15:30:00	IWM	ETF	49.345	49.47	49.345	49.445	76600.0
2002-03-14 16:00:00	IWM	ETF	49.935	49.935	49.425	49.425	79400.0
2002-03-14 16:30:00	IWM	ETF	49.685	49.685	49.685	49.685	2800.0
2002-03-14 09:30:00	DIA	ETF	105.33	105.64	104.98	105.17	768100.0

> showing 50 of 468 rows — these rows as CSV

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