PREVIEW / etf_30min / 2002-01-07

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-01-07.parquet
  size:    18 KB
  rows:    485

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-07 09:30:00	SPY	ETF	117.7	117.99	117.47	117.51	2139800.0
2002-01-07 10:00:00	SPY	ETF	117.5	117.9	117.32	117.74	1083500.0
2002-01-07 10:30:00	SPY	ETF	117.74	117.83	117.4	117.51	668900.0
2002-01-07 11:00:00	SPY	ETF	117.45	117.53	117.06	117.23	863300.0
2002-01-07 11:30:00	SPY	ETF	117.24	117.29	116.85	116.94	1077300.0
2002-01-07 12:00:00	SPY	ETF	116.93	117.06	116.85	117.0	522300.0
2002-01-07 12:30:00	SPY	ETF	117.04	117.22	116.99	117.11	470600.0
2002-01-07 13:00:00	SPY	ETF	117.12	117.28	116.88	117.15	306300.0
2002-01-07 13:30:00	SPY	ETF	117.14	117.27	116.92	117.09	410300.0
2002-01-07 14:00:00	SPY	ETF	117.09	117.36	117.01	117.15	844200.0
2002-01-07 14:30:00	SPY	ETF	117.14	117.25	116.83	116.92	760300.0
2002-01-07 15:00:00	SPY	ETF	116.95	117.1	116.56	116.63	1025300.0
2002-01-07 15:30:00	SPY	ETF	116.6	116.9	116.6	116.74	1092500.0
2002-01-07 16:00:00	SPY	ETF	116.74	116.9	116.55	116.7	1630400.0
2002-01-07 16:30:00	SPY	ETF	116.88	116.88	116.86	116.86	1000.0
2002-01-07 09:30:00	QQQ	ETF	42.11	42.22	41.82	41.89	13025400.0
2002-01-07 10:00:00	QQQ	ETF	41.89	42.0	41.63	41.9	10707800.0
2002-01-07 10:30:00	QQQ	ETF	41.89	42.02	41.61	41.65	3831900.0
2002-01-07 11:00:00	QQQ	ETF	41.65	41.71	41.35	41.46	3778800.0
2002-01-07 11:30:00	QQQ	ETF	41.45	41.5	41.1	41.2	4800500.0
2002-01-07 12:00:00	QQQ	ETF	41.21	41.33	41.1	41.25	4113800.0
2002-01-07 12:30:00	QQQ	ETF	41.22	41.41	41.22	41.31	3352200.0
2002-01-07 13:00:00	QQQ	ETF	41.29	41.55	41.15	41.47	3263500.0
2002-01-07 13:30:00	QQQ	ETF	41.46	41.61	41.35	41.48	2805600.0
2002-01-07 14:00:00	QQQ	ETF	41.5	41.72	41.41	41.52	4029700.0
2002-01-07 14:30:00	QQQ	ETF	41.53	41.63	41.23	41.37	4499800.0
2002-01-07 15:00:00	QQQ	ETF	41.36	41.45	40.97	41.04	6888900.0
2002-01-07 15:30:00	QQQ	ETF	41.06	41.27	41.04	41.07	5384900.0
2002-01-07 16:00:00	QQQ	ETF	41.09	41.24	41.07	41.14	2697800.0
2002-01-07 16:30:00	QQQ	ETF	41.17	41.45	41.14	41.35	897900.0
2002-01-07 17:00:00	QQQ	ETF	41.37	41.45	41.32	41.33	144300.0
2002-01-07 17:30:00	QQQ	ETF	41.36	41.36	41.26	41.3	41100.0
2002-01-07 18:00:00	QQQ	ETF	41.29	41.3	41.19	41.19	115200.0
2002-01-07 09:30:00	IWM	ETF	49.675	49.9	49.625	49.745	458000.0
2002-01-07 10:00:00	IWM	ETF	49.795	49.795	49.525	49.74	43800.0
2002-01-07 10:30:00	IWM	ETF	49.74	49.745	49.7	49.72	42400.0
2002-01-07 11:00:00	IWM	ETF	49.65	49.685	49.485	49.485	182600.0
2002-01-07 11:30:00	IWM	ETF	49.555	49.595	49.35	49.44	328000.0
2002-01-07 12:00:00	IWM	ETF	49.36	49.485	49.36	49.445	27400.0
2002-01-07 12:30:00	IWM	ETF	49.45	49.55	49.43	49.505	40400.0
2002-01-07 13:00:00	IWM	ETF	49.45	49.535	49.36	49.5	100000.0
2002-01-07 13:30:00	IWM	ETF	49.475	49.515	49.39	49.49	38800.0
2002-01-07 14:00:00	IWM	ETF	49.485	49.535	49.38	49.435	42800.0
2002-01-07 14:30:00	IWM	ETF	49.435	49.575	49.375	49.38	35400.0
2002-01-07 15:00:00	IWM	ETF	49.45	49.49	49.175	49.175	228000.0
2002-01-07 15:30:00	IWM	ETF	49.25	49.325	48.925	48.925	91400.0
2002-01-07 16:00:00	IWM	ETF	49.0	49.0	49.0	49.0	200.0
2002-01-07 09:30:00	DIA	ETF	102.87	103.07	102.6	102.66	234700.0
2002-01-07 10:00:00	DIA	ETF	102.66	103.14	102.6	103.02	163200.0
2002-01-07 10:30:00	DIA	ETF	103.0	103.09	102.7	102.72	268800.0

> showing 50 of 485 rows — these rows as CSV

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