PREVIEW / etf_30min / 2001-09-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-27.parquet
  size:    16 KB
  rows:    398

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
2001-09-27 09:30:00	SPY	ETF	101.25	101.45	100.43	100.7	2294200.0
2001-09-27 10:00:00	SPY	ETF	100.66	100.9	100.17	100.31	1887900.0
2001-09-27 10:30:00	SPY	ETF	100.3	100.59	100.02	100.55	1814700.0
2001-09-27 11:00:00	SPY	ETF	100.52	100.62	100.25	100.58	1583500.0
2001-09-27 11:30:00	SPY	ETF	100.6	100.8	100.32	100.36	958600.0
2001-09-27 12:00:00	SPY	ETF	100.33	100.47	100.2	100.29	526200.0
2001-09-27 12:30:00	SPY	ETF	100.22	100.43	100.0	100.37	580900.0
2001-09-27 13:00:00	SPY	ETF	100.36	100.45	100.18	100.33	443700.0
2001-09-27 13:30:00	SPY	ETF	100.32	100.58	100.19	100.46	558700.0
2001-09-27 14:00:00	SPY	ETF	100.48	101.06	100.44	100.89	1071800.0
2001-09-27 14:30:00	SPY	ETF	100.89	101.69	100.85	101.5	2216100.0
2001-09-27 15:00:00	SPY	ETF	101.46	102.25	101.3	101.48	2506000.0
2001-09-27 15:30:00	SPY	ETF	101.48	102.19	101.46	102.05	1551800.0
2001-09-27 16:00:00	SPY	ETF	102.05	102.3	101.25	102.3	1079300.0
2001-09-27 17:00:00	SPY	ETF	102.06	102.25	102.0	102.25	10500.0
2001-09-27 17:30:00	SPY	ETF	102.27	102.3	102.27	102.3	4400.0
2001-09-27 09:30:00	QQQ	ETF	28.4	28.59	27.9	28.01	7163000.0
2001-09-27 10:00:00	QQQ	ETF	28.01	28.15	27.6	27.71	6560300.0
2001-09-27 10:30:00	QQQ	ETF	27.7	27.74	27.42	27.7	5728400.0
2001-09-27 11:00:00	QQQ	ETF	27.72	27.75	27.54	27.7	3530100.0
2001-09-27 11:30:00	QQQ	ETF	27.7	27.85	27.62	27.67	2439500.0
2001-09-27 12:00:00	QQQ	ETF	27.69	27.7	27.5	27.5	1349100.0
2001-09-27 12:30:00	QQQ	ETF	27.52	27.62	27.42	27.56	3570300.0
2001-09-27 13:00:00	QQQ	ETF	27.57	27.6	27.47	27.57	1165900.0
2001-09-27 13:30:00	QQQ	ETF	27.56	27.68	27.47	27.62	1277500.0
2001-09-27 14:00:00	QQQ	ETF	27.63	28.05	27.6	27.95	5191100.0
2001-09-27 14:30:00	QQQ	ETF	27.94	28.44	27.92	28.38	8847100.0
2001-09-27 15:00:00	QQQ	ETF	28.36	28.79	28.25	28.29	10463000.0
2001-09-27 15:30:00	QQQ	ETF	28.28	28.67	28.25	28.51	5821800.0
2001-09-27 16:00:00	QQQ	ETF	28.55	28.6	27.84	28.54	3642600.0
2001-09-27 16:30:00	QQQ	ETF	28.54	28.55	28.4	28.5	85700.0
2001-09-27 17:00:00	QQQ	ETF	28.45	28.65	28.45	28.6	33300.0
2001-09-27 17:30:00	QQQ	ETF	28.56	28.62	28.52	28.58	7700.0
2001-09-27 18:00:00	QQQ	ETF	28.58	28.7	28.56	28.65	15200.0
2001-09-27 09:30:00	IWM	ETF	38.89	39.0	38.575	38.6	58400.0
2001-09-27 10:00:00	IWM	ETF	38.6	38.6	38.455	38.455	65200.0
2001-09-27 10:30:00	IWM	ETF	38.485	38.5	38.33	38.47	72600.0
2001-09-27 11:00:00	IWM	ETF	38.52	38.52	38.375	38.41	11400.0
2001-09-27 11:30:00	IWM	ETF	38.5	38.55	38.41	38.41	13400.0
2001-09-27 12:00:00	IWM	ETF	38.415	38.54	38.37	38.5	10600.0
2001-09-27 12:30:00	IWM	ETF	38.35	38.4	38.345	38.4	198400.0
2001-09-27 13:00:00	IWM	ETF	38.47	38.47	38.4	38.4	190600.0
2001-09-27 13:30:00	IWM	ETF	38.405	38.405	38.315	38.315	194200.0
2001-09-27 14:00:00	IWM	ETF	38.495	38.7	38.495	38.675	131800.0
2001-09-27 14:30:00	IWM	ETF	38.745	38.82	38.585	38.775	55200.0
2001-09-27 15:00:00	IWM	ETF	38.7	39.05	38.7	38.865	55600.0
2001-09-27 15:30:00	IWM	ETF	38.85	39.35	38.85	39.21	397600.0
2001-09-27 16:00:00	IWM	ETF	39.15	39.525	39.15	39.515	388000.0
2001-09-27 09:30:00	DIA	ETF	86.0	86.23	85.41	85.6	597400.0
2001-09-27 10:00:00	DIA	ETF	85.6	85.78	85.05	85.12	338600.0

> showing 50 of 398 rows — these rows as CSV

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