PREVIEW / etf_30min / 2006-09-01

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-09-01.parquet
  size:    76 KB
  rows:    2,765

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
2006-09-01 07:00:00	SPY	ETF	130.86	130.86	130.86	130.86	35600.0
2006-09-01 07:30:00	SPY	ETF	130.85	130.86	130.84	130.84	33400.0
2006-09-01 08:00:00	SPY	ETF	130.87	130.95	130.75	130.9	926200.0
2006-09-01 08:30:00	SPY	ETF	130.81	131.17	130.77	131.03	2197700.0
2006-09-01 09:00:00	SPY	ETF	131.0	131.18	130.99	131.14	1348000.0
2006-09-01 09:30:00	SPY	ETF	131.14	131.3	131.05	131.24	5206600.0
2006-09-01 10:00:00	SPY	ETF	131.23	131.25	130.84	130.99	7763000.0
2006-09-01 10:30:00	SPY	ETF	130.99	131.29	130.98	131.17	3899700.0
2006-09-01 11:00:00	SPY	ETF	131.17	131.27	131.08	131.18	2166900.0
2006-09-01 11:30:00	SPY	ETF	131.18	131.35	131.14	131.32	1831100.0
2006-09-01 12:00:00	SPY	ETF	131.32	131.35	131.23	131.33	1126000.0
2006-09-01 12:30:00	SPY	ETF	131.33	131.57	131.31	131.53	5168100.0
2006-09-01 13:00:00	SPY	ETF	131.51	131.58	131.46	131.51	2910200.0
2006-09-01 13:30:00	SPY	ETF	131.5	131.56	131.44	131.47	1439800.0
2006-09-01 14:00:00	SPY	ETF	131.46	131.52	131.41	131.5	1897500.0
2006-09-01 14:30:00	SPY	ETF	131.5	131.51	131.26	131.4	2427200.0
2006-09-01 15:00:00	SPY	ETF	131.41	131.5	131.34	131.44	1824100.0
2006-09-01 15:30:00	SPY	ETF	131.44	131.49	131.36	131.46	2744900.0
2006-09-01 16:00:00	SPY	ETF	131.46	131.48	131.41	131.45	2844000.0
2006-09-01 16:30:00	SPY	ETF	131.46	131.49	131.45	131.49	20200.0
2006-09-01 17:00:00	SPY	ETF	131.49	131.5	131.46	131.5	2600.0
2006-09-01 17:30:00	SPY	ETF	131.48	131.5	131.48	131.5	500.0
2006-09-01 18:00:00	SPY	ETF	131.49	131.5	131.45	131.45	5200.0
2006-09-01 18:30:00	SPY	ETF	131.45	131.45	131.41	131.41	900.0
2006-09-01 19:00:00	SPY	ETF	131.44	131.44	131.44	131.44	100.0
2006-09-01 19:30:00	SPY	ETF	131.44	131.44	131.44	131.44	600.0
2006-09-01 20:00:00	SPY	ETF	131.41	131.41	131.41	131.41	200.0
2006-09-01 09:30:00	QQQ	ETF	39.07	39.21	39.03	39.11	12624000.0
2006-09-01 10:00:00	QQQ	ETF	39.12	39.12	38.9	38.98	12178800.0
2006-09-01 10:30:00	QQQ	ETF	38.99	39.11	38.94	39.06	5904300.0
2006-09-01 11:00:00	QQQ	ETF	39.06	39.1	39.0	39.04	2903300.0
2006-09-01 11:30:00	QQQ	ETF	39.05	39.13	39.02	39.11	3904500.0
2006-09-01 12:00:00	QQQ	ETF	39.11	39.12	39.08	39.12	1894100.0
2006-09-01 12:30:00	QQQ	ETF	39.12	39.17	39.11	39.16	3570800.0
2006-09-01 13:00:00	QQQ	ETF	39.16	39.2	39.11	39.12	3634300.0
2006-09-01 13:30:00	QQQ	ETF	39.13	39.16	39.08	39.13	2212300.0
2006-09-01 14:00:00	QQQ	ETF	39.14	39.15	39.1	39.14	1867100.0
2006-09-01 14:30:00	QQQ	ETF	39.15	39.15	39.03	39.08	4343000.0
2006-09-01 15:00:00	QQQ	ETF	39.08	39.13	39.05	39.11	2431200.0
2006-09-01 15:30:00	QQQ	ETF	39.12	39.13	39.07	39.08	5658200.0
2006-09-01 07:30:00	IWM	ETF	71.89	71.89	71.89	71.89	100.0
2006-09-01 08:00:00	IWM	ETF	71.77	72.0	71.77	71.95	761300.0
2006-09-01 08:30:00	IWM	ETF	71.85	72.18	71.77	72.04	679900.0
2006-09-01 09:00:00	IWM	ETF	72.04	72.14	71.99	72.13	315200.0
2006-09-01 09:30:00	IWM	ETF	72.08	72.17	71.79	71.94	3436600.0
2006-09-01 10:00:00	IWM	ETF	71.93	71.94	71.46	71.6	3946700.0
2006-09-01 10:30:00	IWM	ETF	71.59	71.79	71.51	71.71	1185400.0
2006-09-01 11:00:00	IWM	ETF	71.71	71.8	71.64	71.78	1332000.0
2006-09-01 11:30:00	IWM	ETF	71.78	71.97	71.755	71.97	1926200.0
2006-09-01 12:00:00	IWM	ETF	71.96	72.04	71.88	72.03	1596400.0

> showing 50 of 2,765 rows — these rows as CSV

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