PREVIEW / etf_1hour / 2009-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-24.parquet
  size:    140 KB
  rows:    4,289

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
2009-07-24 04:00:00	SPY	ETF	97.5	97.81	97.5	97.53	51024.0
2009-07-24 05:00:00	SPY	ETF	97.48	97.64	97.48	97.64	21300.0
2009-07-24 06:00:00	SPY	ETF	97.61	97.65	97.47	97.6	220915.0
2009-07-24 07:00:00	SPY	ETF	97.56	97.64	97.47	97.57	1029531.0
2009-07-24 08:00:00	SPY	ETF	97.56	97.63	97.15	97.18	2681192.0
2009-07-24 09:00:00	SPY	ETF	97.18	97.64	96.92	96.97	22031943.0
2009-07-24 10:00:00	SPY	ETF	96.98	97.24	96.7	96.8	27610710.0
2009-07-24 11:00:00	SPY	ETF	96.8	97.52	96.69	97.46	21269011.0
2009-07-24 12:00:00	SPY	ETF	97.45	97.54	97.315	97.38	12261997.0
2009-07-24 13:00:00	SPY	ETF	97.38	97.9	97.33	97.76	17295450.0
2009-07-24 14:00:00	SPY	ETF	97.76	97.94	97.63	97.74	16291886.0
2009-07-24 15:00:00	SPY	ETF	97.75	98.14	97.68	98.06	23734017.0
2009-07-24 16:00:00	SPY	ETF	98.07	98.35	97.1494	98.3	8538598.0
2009-07-24 17:00:00	SPY	ETF	98.3	98.39	97.2	98.35	260964.0
2009-07-24 18:00:00	SPY	ETF	98.34	98.4	98.04	98.3	95433.0
2009-07-24 19:00:00	SPY	ETF	98.31	98.42	98.26	98.4	42706.0
2009-07-24 04:00:00	QQQ	ETF	39.1	39.2	39.08	39.08	16849.0
2009-07-24 05:00:00	QQQ	ETF	39.01	39.01	39.01	39.01	2490.0
2009-07-24 06:00:00	QQQ	ETF	39.09	39.09	39.02	39.07	15490.0
2009-07-24 07:00:00	QQQ	ETF	39.06	39.06	38.96	39.01	630525.0
2009-07-24 08:00:00	QQQ	ETF	39.01	39.05	38.79	38.82	1966888.0
2009-07-24 09:00:00	QQQ	ETF	38.82	39.18	38.7799	38.82	22145428.0
2009-07-24 10:00:00	QQQ	ETF	38.83	39.04	38.78	38.88	15470207.0
2009-07-24 11:00:00	QQQ	ETF	38.88	39.15	38.85	39.15	11120811.0
2009-07-24 12:00:00	QQQ	ETF	39.15	39.2	39.06	39.0899	10275120.0
2009-07-24 13:00:00	QQQ	ETF	39.08	39.31	39.05	39.25	12212826.0
2009-07-24 14:00:00	QQQ	ETF	39.24	39.34	38.91	39.2	10814273.0
2009-07-24 15:00:00	QQQ	ETF	39.21	39.37	39.16	39.35	14784949.0
2009-07-24 16:00:00	QQQ	ETF	39.35	39.391	39.05	39.38	5295914.0
2009-07-24 17:00:00	QQQ	ETF	39.36	39.38	39.32	39.35	86100.0
2009-07-24 18:00:00	QQQ	ETF	39.36	39.41	39.35	39.41	30450.0
2009-07-24 19:00:00	QQQ	ETF	39.42	39.42	39.36	39.41	19375.0
2009-07-24 06:00:00	IWM	ETF	54.51	54.51	54.51	54.51	185.0
2009-07-24 07:00:00	IWM	ETF	54.5	54.52	54.37	54.43	8581.0
2009-07-24 08:00:00	IWM	ETF	54.43	54.44	54.16	54.18	152960.0
2009-07-24 09:00:00	IWM	ETF	54.19	54.66	54.06	54.13	5224179.0
2009-07-24 10:00:00	IWM	ETF	54.14	54.39	53.96	54.06	5397321.0
2009-07-24 11:00:00	IWM	ETF	54.06	54.53	54.0	54.5	3059233.0
2009-07-24 12:00:00	IWM	ETF	54.5	54.62	54.42	54.48	2619612.0
2009-07-24 13:00:00	IWM	ETF	54.49	54.83	54.42	54.67	4362934.0
2009-07-24 14:00:00	IWM	ETF	54.67	54.81	54.59	54.67	2446544.0
2009-07-24 15:00:00	IWM	ETF	54.66	54.85	54.6	54.83	4778876.0
2009-07-24 16:00:00	IWM	ETF	54.86	54.99	54.4352	54.92	1567839.0
2009-07-24 17:00:00	IWM	ETF	54.94	54.95	54.92	54.93	1798.0
2009-07-24 18:00:00	IWM	ETF	54.96	54.98	54.92	54.97	1800.0
2009-07-24 19:00:00	IWM	ETF	54.86	54.91	54.86	54.91	700.0
2009-07-24 06:00:00	DIA	ETF	90.63	90.69	90.63	90.69	1800.0
2009-07-24 07:00:00	DIA	ETF	90.7	90.76	90.6	90.65	88890.0
2009-07-24 08:00:00	DIA	ETF	90.62	90.62	90.3	90.31	301525.0
2009-07-24 09:00:00	DIA	ETF	90.32	90.69	90.14	90.21	1655586.0

> showing 50 of 4,289 rows — these rows as CSV

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