PREVIEW / etf_30min / 2002-01-11

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-01-11.parquet
  size:    17 KB
  rows:    454

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-01-11 09:30:00	SPY	ETF	116.21	116.28	115.68	115.77	973600.0
2002-01-11 10:00:00	SPY	ETF	115.77	116.2	115.76	116.13	1495600.0
2002-01-11 10:30:00	SPY	ETF	116.11	116.2	115.95	116.02	685600.0
2002-01-11 11:00:00	SPY	ETF	116.04	116.04	115.84	115.97	649800.0
2002-01-11 11:30:00	SPY	ETF	115.97	116.01	115.85	115.95	185400.0
2002-01-11 12:00:00	SPY	ETF	115.95	115.99	115.84	115.89	118700.0
2002-01-11 12:30:00	SPY	ETF	115.91	115.94	115.55	115.72	465700.0
2002-01-11 13:00:00	SPY	ETF	115.74	115.75	115.25	115.46	488400.0
2002-01-11 13:30:00	SPY	ETF	115.46	115.64	115.06	115.31	1549600.0
2002-01-11 14:00:00	SPY	ETF	115.26	115.45	114.95	114.95	1204800.0
2002-01-11 14:30:00	SPY	ETF	114.96	115.39	114.88	115.3	2153100.0
2002-01-11 15:00:00	SPY	ETF	115.24	115.4	115.06	115.32	452900.0
2002-01-11 15:30:00	SPY	ETF	115.29	115.4	114.71	114.77	1502900.0
2002-01-11 16:00:00	SPY	ETF	114.78	115.03	114.7	115.0	1577200.0
2002-01-11 16:30:00	SPY	ETF	114.93	114.93	114.93	114.93	100.0
2002-01-11 17:00:00	SPY	ETF	114.79	114.79	114.75	114.75	700.0
2002-01-11 17:30:00	SPY	ETF	114.8	115.15	114.75	115.15	2200.0
2002-01-11 18:00:00	SPY	ETF	114.78	114.78	114.78	114.78	100.0
2002-01-11 09:30:00	QQQ	ETF	41.35	41.44	41.15	41.35	6091000.0
2002-01-11 10:00:00	QQQ	ETF	41.25	41.6	41.25	41.56	5704400.0
2002-01-11 10:30:00	QQQ	ETF	41.52	41.58	41.35	41.43	2923600.0
2002-01-11 11:00:00	QQQ	ETF	41.43	41.47	41.25	41.34	2262700.0
2002-01-11 11:30:00	QQQ	ETF	41.35	41.4	41.26	41.33	1033100.0
2002-01-11 12:00:00	QQQ	ETF	41.34	41.35	41.19	41.28	1150700.0
2002-01-11 12:30:00	QQQ	ETF	41.25	41.32	40.95	41.08	3604800.0
2002-01-11 13:00:00	QQQ	ETF	41.07	41.1	40.75	40.95	4244100.0
2002-01-11 13:30:00	QQQ	ETF	40.96	41.09	40.62	40.8	7077600.0
2002-01-11 14:00:00	QQQ	ETF	40.78	40.91	40.47	40.48	8565000.0
2002-01-11 14:30:00	QQQ	ETF	40.48	40.89	40.47	40.78	6834400.0
2002-01-11 15:00:00	QQQ	ETF	40.8	40.98	40.63	40.91	4153900.0
2002-01-11 15:30:00	QQQ	ETF	40.89	40.98	40.65	40.68	4725800.0
2002-01-11 16:00:00	QQQ	ETF	40.69	40.95	40.65	40.82	1443800.0
2002-01-11 16:30:00	QQQ	ETF	40.82	40.89	40.5	40.84	25200.0
2002-01-11 17:00:00	QQQ	ETF	40.84	40.88	40.8	40.85	12600.0
2002-01-11 17:30:00	QQQ	ETF	40.85	40.9	40.75	40.9	11200.0
2002-01-11 18:00:00	QQQ	ETF	40.82	40.89	40.82	40.83	11600.0
2002-01-11 09:30:00	IWM	ETF	49.375	49.47	49.16	49.275	73400.0
2002-01-11 10:00:00	IWM	ETF	49.255	49.475	49.25	49.415	117800.0
2002-01-11 10:30:00	IWM	ETF	49.415	49.475	49.34	49.445	82600.0
2002-01-11 11:00:00	IWM	ETF	49.435	49.445	49.34	49.38	85600.0
2002-01-11 11:30:00	IWM	ETF	49.385	49.405	49.3	49.385	19600.0
2002-01-11 12:00:00	IWM	ETF	49.305	49.375	49.255	49.355	12200.0
2002-01-11 12:30:00	IWM	ETF	49.355	49.355	49.2	49.295	12600.0
2002-01-11 13:00:00	IWM	ETF	49.275	49.285	49.0	49.07	114800.0
2002-01-11 13:30:00	IWM	ETF	49.175	49.175	48.995	49.045	38400.0
2002-01-11 14:00:00	IWM	ETF	48.99	49.085	48.9	48.985	28800.0
2002-01-11 14:30:00	IWM	ETF	48.985	49.0	48.84	49.0	46000.0
2002-01-11 15:00:00	IWM	ETF	49.005	49.095	48.99	49.065	93200.0
2002-01-11 15:30:00	IWM	ETF	49.04	49.04	48.55	48.55	66600.0
2002-01-11 16:00:00	IWM	ETF	48.65	48.7	48.6	48.7	7200.0

> showing 50 of 454 rows — these rows as CSV

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