PREVIEW / etf_30min / 2002-06-27

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-06-27.parquet
  size:    19 KB
  rows:    521

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-06-27 09:30:00	SPY	ETF	98.5	98.65	97.85	98.3	4344600.0
2002-06-27 10:00:00	SPY	ETF	98.29	98.5	97.77	97.8	1994700.0
2002-06-27 10:30:00	SPY	ETF	97.82	98.21	97.75	97.93	1644000.0
2002-06-27 11:00:00	SPY	ETF	97.9	97.95	96.57	97.2	4549200.0
2002-06-27 11:30:00	SPY	ETF	97.22	97.78	97.11	97.25	1906000.0
2002-06-27 12:00:00	SPY	ETF	97.25	97.54	97.05	97.41	1124000.0
2002-06-27 12:30:00	SPY	ETF	97.4	97.55	97.04	97.55	873900.0
2002-06-27 13:00:00	SPY	ETF	97.55	97.95	97.41	97.88	1021700.0
2002-06-27 13:30:00	SPY	ETF	97.92	98.41	97.83	98.2	2044200.0
2002-06-27 14:00:00	SPY	ETF	98.21	98.88	98.1	98.75	1731900.0
2002-06-27 14:30:00	SPY	ETF	98.78	99.14	98.47	98.83	1779200.0
2002-06-27 15:00:00	SPY	ETF	98.86	98.9	98.1	98.31	1345600.0
2002-06-27 15:30:00	SPY	ETF	98.32	99.45	98.27	99.45	1903000.0
2002-06-27 16:00:00	SPY	ETF	99.37	99.49	99.31	99.34	1171200.0
2002-06-27 16:30:00	SPY	ETF	99.35	99.43	99.3	99.3	63800.0
2002-06-27 17:00:00	SPY	ETF	99.43	99.45	99.38	99.45	400.0
2002-06-27 17:30:00	SPY	ETF	99.49	99.64	99.49	99.54	11500.0
2002-06-27 18:00:00	SPY	ETF	99.55	99.69	99.55	99.69	700.0
2002-06-27 09:30:00	QQQ	ETF	26.0	26.09	25.68	25.97	14179900.0
2002-06-27 10:00:00	QQQ	ETF	25.93	26.07	25.64	25.65	8509300.0
2002-06-27 10:30:00	QQQ	ETF	25.67	25.94	25.65	25.76	7647000.0
2002-06-27 11:00:00	QQQ	ETF	25.75	25.79	25.02	25.38	17300700.0
2002-06-27 11:30:00	QQQ	ETF	25.37	25.65	25.32	25.46	5486200.0
2002-06-27 12:00:00	QQQ	ETF	25.4	25.48	25.26	25.41	3671000.0
2002-06-27 12:30:00	QQQ	ETF	25.42	25.58	25.3	25.56	2335200.0
2002-06-27 13:00:00	QQQ	ETF	25.55	25.67	25.41	25.63	3124000.0
2002-06-27 13:30:00	QQQ	ETF	25.63	25.84	25.57	25.79	5700400.0
2002-06-27 14:00:00	QQQ	ETF	25.8	26.04	25.72	26.0	8150300.0
2002-06-27 14:30:00	QQQ	ETF	26.0	26.11	25.86	25.91	5354800.0
2002-06-27 15:00:00	QQQ	ETF	25.92	25.94	25.55	25.68	7191400.0
2002-06-27 15:30:00	QQQ	ETF	25.66	26.15	25.64	26.11	8584500.0
2002-06-27 16:00:00	QQQ	ETF	26.12	26.31	26.07	26.25	4549300.0
2002-06-27 16:30:00	QQQ	ETF	26.23	26.28	26.15	26.23	218500.0
2002-06-27 17:00:00	QQQ	ETF	26.22	26.3	26.19	26.27	59400.0
2002-06-27 17:30:00	QQQ	ETF	26.26	26.27	26.24	26.27	22200.0
2002-06-27 18:00:00	QQQ	ETF	26.27	26.3	26.23	26.24	18500.0
2002-06-27 09:30:00	IWM	ETF	45.65	45.67	45.255	45.375	154400.0
2002-06-27 10:00:00	IWM	ETF	45.35	45.615	45.305	45.435	128000.0
2002-06-27 10:30:00	IWM	ETF	45.435	45.53	45.395	45.435	35000.0
2002-06-27 11:00:00	IWM	ETF	45.43	45.43	44.775	44.865	2008800.0
2002-06-27 11:30:00	IWM	ETF	44.92	45.215	44.905	45.155	98800.0
2002-06-27 12:00:00	IWM	ETF	45.105	45.105	45.07	45.1	29400.0
2002-06-27 12:30:00	IWM	ETF	45.115	45.115	44.995	45.035	104000.0
2002-06-27 13:00:00	IWM	ETF	45.095	45.145	45.055	45.1	25000.0
2002-06-27 13:30:00	IWM	ETF	45.115	45.355	45.115	45.355	193800.0
2002-06-27 14:00:00	IWM	ETF	45.395	45.55	45.275	45.52	167600.0
2002-06-27 14:30:00	IWM	ETF	45.5	45.525	45.39	45.405	81800.0
2002-06-27 15:00:00	IWM	ETF	45.385	45.445	45.125	45.225	254800.0
2002-06-27 15:30:00	IWM	ETF	45.245	45.7	45.245	45.7	455000.0
2002-06-27 16:00:00	IWM	ETF	45.77	45.85	45.7	45.85	270200.0

> showing 50 of 521 rows — these rows as CSV

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