PREVIEW / etf_1hour / 2007-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-15.parquet
  size:    66 KB
  rows:    2,078

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-03-15 06:00:00	SPY	ETF	139.4	139.4	139.4	139.4	5000.0
2007-03-15 07:00:00	SPY	ETF	139.48	139.7	139.4	139.67	471900.0
2007-03-15 08:00:00	SPY	ETF	139.67	139.82	139.01	139.16	10055400.0
2007-03-15 09:00:00	SPY	ETF	139.17	139.61	138.8	139.57	20664800.0
2007-03-15 10:00:00	SPY	ETF	139.58	139.99	139.33	139.73	27520800.0
2007-03-15 11:00:00	SPY	ETF	139.72	139.84	139.33	139.43	13658684.0
2007-03-15 12:00:00	SPY	ETF	139.43	139.9	139.34	139.72	11142219.0
2007-03-15 13:00:00	SPY	ETF	139.71	139.92	139.08	139.5	19358975.0
2007-03-15 14:00:00	SPY	ETF	139.5	139.83	139.29	139.67	10992694.0
2007-03-15 15:00:00	SPY	ETF	139.66	139.76	139.47	139.57	14825940.0
2007-03-15 16:00:00	SPY	ETF	139.58	139.67	139.34	139.37	1782100.0
2007-03-15 17:00:00	SPY	ETF	139.37	139.37	139.2	139.25	163000.0
2007-03-15 18:00:00	SPY	ETF	139.25	139.32	139.21	139.32	11700.0
2007-03-15 19:00:00	SPY	ETF	139.3	139.32	139.2	139.23	17500.0
2007-03-15 07:00:00	QQQ	ETF	43.03	43.15	43.03	43.13	335829.0
2007-03-15 08:00:00	QQQ	ETF	43.11	43.17	42.88	42.94	3749461.0
2007-03-15 09:00:00	QQQ	ETF	42.94	43.04	42.81	43.02	14403642.0
2007-03-15 10:00:00	QQQ	ETF	43.03	43.06	42.87	42.95	14927400.0
2007-03-15 11:00:00	QQQ	ETF	42.95	43.06	42.8	42.84	19375100.0
2007-03-15 12:00:00	QQQ	ETF	42.84	42.99	42.8	42.91	11451200.0
2007-03-15 13:00:00	QQQ	ETF	42.92	42.96	42.72	42.84	17116600.0
2007-03-15 14:00:00	QQQ	ETF	42.84	42.97	42.82	42.9	8562700.0
2007-03-15 15:00:00	QQQ	ETF	42.9	42.98	42.87	42.89	13987100.0
2007-03-15 16:00:00	QQQ	ETF	42.89	42.93	42.83	42.83	3273499.0
2007-03-15 17:00:00	QQQ	ETF	42.85	42.85	42.81	42.83	195970.0
2007-03-15 18:00:00	QQQ	ETF	42.83	42.86	42.83	42.86	19498.0
2007-03-15 19:00:00	QQQ	ETF	42.86	42.86	42.81	42.84	15156.0
2007-03-15 08:00:00	IWM	ETF	77.5	77.61	76.92	77.06	1424800.0
2007-03-15 09:00:00	IWM	ETF	77.13	77.8	76.98	77.79	17818338.0
2007-03-15 10:00:00	IWM	ETF	77.8	77.83	77.54	77.6	19910263.0
2007-03-15 11:00:00	IWM	ETF	77.61	77.72	77.35	77.39	6567769.0
2007-03-15 12:00:00	IWM	ETF	77.39	77.73	77.37	77.66	6235275.0
2007-03-15 13:00:00	IWM	ETF	77.66	77.69	77.32	77.5401	6686300.0
2007-03-15 14:00:00	IWM	ETF	77.54	77.71	77.42	77.65	11000150.0
2007-03-15 15:00:00	IWM	ETF	77.65	77.88	77.55	77.87	8441338.0
2007-03-15 16:00:00	IWM	ETF	77.87	77.92	77.7	77.7	4068100.0
2007-03-15 17:00:00	IWM	ETF	77.68	77.75	77.56	77.56	47400.0
2007-03-15 18:00:00	IWM	ETF	77.64	77.66	77.64	77.66	6600.0
2007-03-15 07:00:00	DIA	ETF	121.83	121.98	121.83	121.98	500.0
2007-03-15 08:00:00	DIA	ETF	121.99	122.04	121.36	121.46	74200.0
2007-03-15 09:00:00	DIA	ETF	121.49	121.82	121.21	121.79	1258000.0
2007-03-15 10:00:00	DIA	ETF	121.78	122.04	121.598	121.87	1747500.0
2007-03-15 11:00:00	DIA	ETF	121.86	121.96	121.49	121.57	1191700.0
2007-03-15 12:00:00	DIA	ETF	121.56	121.93	121.5	121.81	674900.0
2007-03-15 13:00:00	DIA	ETF	121.81	122.0	121.29	121.61	1255500.0
2007-03-15 14:00:00	DIA	ETF	121.6	121.83	121.43	121.8	689300.0
2007-03-15 15:00:00	DIA	ETF	121.79	121.88	121.62	121.73	926800.0
2007-03-15 16:00:00	DIA	ETF	121.74	121.8	121.59	121.59	51400.0
2007-03-15 17:00:00	DIA	ETF	121.62	121.64	121.62	121.64	1500.0
2007-03-15 19:00:00	DIA	ETF	121.6	121.6	121.6	121.6	100.0

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

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