PREVIEW / etf_1hour / 2007-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-11.parquet
  size:    82 KB
  rows:    2,728

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
2007-09-11 05:00:00	SPY	ETF	146.04	146.04	146.04	146.04	1000.0
2007-09-11 06:00:00	SPY	ETF	146.18	146.43	146.18	146.33	22000.0
2007-09-11 07:00:00	SPY	ETF	146.39	146.48	146.19	146.33	954700.0
2007-09-11 08:00:00	SPY	ETF	146.3	146.55	146.1	146.12	2699800.0
2007-09-11 09:00:00	SPY	ETF	146.12	146.74	146.09	146.62	20783275.0
2007-09-11 10:00:00	SPY	ETF	146.61	147.09	146.35	146.89	24116400.0
2007-09-11 11:00:00	SPY	ETF	146.89	146.96	146.49	146.6	21074500.0
2007-09-11 12:00:00	SPY	ETF	146.59	146.96	146.4	146.8	12202500.0
2007-09-11 13:00:00	SPY	ETF	146.8	147.05	146.52	146.93	14132600.0
2007-09-11 14:00:00	SPY	ETF	146.92	147.63	146.91	147.35	23818200.0
2007-09-11 15:00:00	SPY	ETF	147.351	147.7	146.88	147.64	32939800.0
2007-09-11 16:00:00	SPY	ETF	147.59	147.6	146.34	147.45	5470700.0
2007-09-11 17:00:00	SPY	ETF	147.45	147.51	147.42	147.47	201100.0
2007-09-11 18:00:00	SPY	ETF	147.47	147.49	147.38	147.42	136700.0
2007-09-11 19:00:00	SPY	ETF	147.4	147.45	147.32	147.36	16000.0
2007-09-11 06:00:00	QQQ	ETF	48.59	48.59	48.55	48.55	2000.0
2007-09-11 07:00:00	QQQ	ETF	48.56	48.65	48.5	48.64	1345523.0
2007-09-11 08:00:00	QQQ	ETF	48.63	48.68	48.47	48.47	2893872.0
2007-09-11 09:00:00	QQQ	ETF	48.48	48.61	48.43	48.58	12548212.0
2007-09-11 10:00:00	QQQ	ETF	48.57	48.75	48.15	48.6601	15409867.0
2007-09-11 11:00:00	QQQ	ETF	48.66	48.68	48.56	48.6	10393108.0
2007-09-11 12:00:00	QQQ	ETF	48.6	48.75	48.52	48.74	8213455.0
2007-09-11 13:00:00	QQQ	ETF	48.75	48.89	48.69	48.8415	8109223.0
2007-09-11 14:00:00	QQQ	ETF	48.848	48.9885	48.81	48.87	9075667.0
2007-09-11 15:00:00	QQQ	ETF	48.87	48.97	48.66	48.95	18117869.0
2007-09-11 16:00:00	QQQ	ETF	48.96	49.01	48.87	48.88	4685800.0
2007-09-11 17:00:00	QQQ	ETF	48.88	48.89	48.84	48.87	103226.0
2007-09-11 18:00:00	QQQ	ETF	48.88	48.92	48.88	48.91	20727.0
2007-09-11 19:00:00	QQQ	ETF	48.92	48.94	48.91	48.94	19300.0
2007-09-11 06:00:00	IWM	ETF	77.03	77.17	77.03	77.17	62000.0
2007-09-11 07:00:00	IWM	ETF	77.14	77.2	77.07	77.2	200400.0
2007-09-11 08:00:00	IWM	ETF	77.2	77.33	77.12	77.13	316400.0
2007-09-11 09:00:00	IWM	ETF	77.13	77.56	77.04	77.47	7642889.0
2007-09-11 10:00:00	IWM	ETF	77.48	77.68	77.17	77.5	10556700.0
2007-09-11 11:00:00	IWM	ETF	77.5	77.65	77.2	77.27	6533400.0
2007-09-11 12:00:00	IWM	ETF	77.26	77.49	77.06	77.43	4392500.0
2007-09-11 13:00:00	IWM	ETF	77.44	77.52	77.15	77.43	3555000.0
2007-09-11 14:00:00	IWM	ETF	77.42	77.8	77.41	77.72	9055100.0
2007-09-11 15:00:00	IWM	ETF	77.72	78.05	77.55	78.04	14756400.0
2007-09-11 16:00:00	IWM	ETF	78.04	78.08	77.91	78.04	10438300.0
2007-09-11 17:00:00	IWM	ETF	78.05	78.05	77.99	77.99	31400.0
2007-09-11 18:00:00	IWM	ETF	78.03	78.03	78.03	78.03	1100.0
2007-09-11 07:00:00	DIA	ETF	131.85	131.95	131.85	131.95	2100.0
2007-09-11 08:00:00	DIA	ETF	132.0	132.03	131.77	131.77	15200.0
2007-09-11 09:00:00	DIA	ETF	131.75	132.38	131.75	132.29	1669292.0
2007-09-11 10:00:00	DIA	ETF	132.29	132.76	132.11	132.6	1791900.0
2007-09-11 11:00:00	DIA	ETF	132.61	132.61	132.25	132.36	1535400.0
2007-09-11 12:00:00	DIA	ETF	132.37	132.72	132.23	132.55	567300.0
2007-09-11 13:00:00	DIA	ETF	132.57	132.7	132.35	132.58	845400.0
2007-09-11 14:00:00	DIA	ETF	132.57	133.27	132.57	133.01	1999000.0

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

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