PREVIEW / etf_1hour / 2007-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-24.parquet
  size:    91 KB
  rows:    3,016

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-10-24 04:00:00	SPY	ETF	150.88	150.88	150.88	150.88	2000.0
2007-10-24 05:00:00	SPY	ETF	151.01	151.01	150.98	150.98	18500.0
2007-10-24 06:00:00	SPY	ETF	150.97	151.0	150.85	150.85	78200.0
2007-10-24 07:00:00	SPY	ETF	150.84	151.26	150.57	151.07	2278100.0
2007-10-24 08:00:00	SPY	ETF	151.09	151.76	150.6	151.15	3706100.0
2007-10-24 09:00:00	SPY	ETF	151.15	151.48	150.95	151.28	20818347.0
2007-10-24 10:00:00	SPY	ETF	151.29	151.3	149.0	150.0	55334207.0
2007-10-24 11:00:00	SPY	ETF	150.0	151.0	148.84	149.51	62740649.0
2007-10-24 12:00:00	SPY	ETF	149.51	150.07	149.37	149.7	26891817.0
2007-10-24 13:00:00	SPY	ETF	149.7	150.0	148.0	149.56	24246100.0
2007-10-24 14:00:00	SPY	ETF	149.56	150.71	148.95	150.65	49686600.0
2007-10-24 15:00:00	SPY	ETF	150.65	151.73	150.51	151.56	64066700.0
2007-10-24 16:00:00	SPY	ETF	151.53	151.8739	149.4932	151.73	8747200.0
2007-10-24 17:00:00	SPY	ETF	151.8	151.95	151.54	151.78	3953500.0
2007-10-24 18:00:00	SPY	ETF	151.78	151.82	151.73	151.81	139300.0
2007-10-24 19:00:00	SPY	ETF	151.81	151.89	151.7	151.7	77200.0
2007-10-24 04:00:00	QQQ	ETF	53.62	53.67	53.62	53.62	38000.0
2007-10-24 05:00:00	QQQ	ETF	53.6	53.65	53.6	53.65	76556.0
2007-10-24 06:00:00	QQQ	ETF	53.63	53.63	53.59	53.59	88300.0
2007-10-24 07:00:00	QQQ	ETF	53.58	53.7	53.52	53.69	720786.0
2007-10-24 08:00:00	QQQ	ETF	53.7	54.18	53.45	53.75	2294138.0
2007-10-24 09:00:00	QQQ	ETF	53.75	53.94	53.57	53.85	23189263.0
2007-10-24 10:00:00	QQQ	ETF	53.85	53.85	53.17	53.25	45190672.0
2007-10-24 11:00:00	QQQ	ETF	53.26	53.27	52.64	52.97	57390024.0
2007-10-24 12:00:00	QQQ	ETF	52.9615	53.3	52.91	53.07	34049178.0
2007-10-24 13:00:00	QQQ	ETF	53.08	53.12	52.75	52.8	20002030.0
2007-10-24 14:00:00	QQQ	ETF	52.8	53.27	52.0	53.242	41455242.0
2007-10-24 15:00:00	QQQ	ETF	53.2485	53.8	53.19	53.8	62476771.0
2007-10-24 16:00:00	QQQ	ETF	53.8	53.96	53.1659	53.95	10235023.0
2007-10-24 17:00:00	QQQ	ETF	53.93	54.0	53.78	53.9	1057164.0
2007-10-24 18:00:00	QQQ	ETF	53.9	53.95	53.9	53.95	67104.0
2007-10-24 19:00:00	QQQ	ETF	53.97	53.98	53.92	53.92	14793.0
2007-10-24 07:00:00	IWM	ETF	80.78	80.96	80.69	80.85	156100.0
2007-10-24 08:00:00	IWM	ETF	80.81	80.9	80.71	80.82	831200.0
2007-10-24 09:00:00	IWM	ETF	80.87	81.17	80.56	80.92	10118352.0
2007-10-24 10:00:00	IWM	ETF	80.93	80.93	79.6	79.67	24979100.0
2007-10-24 11:00:00	IWM	ETF	79.67	79.95	79.11	79.72	24530400.0
2007-10-24 12:00:00	IWM	ETF	79.72	79.99	79.59	79.77	9453600.0
2007-10-24 13:00:00	IWM	ETF	79.77	79.94	79.49	79.63	9045700.0
2007-10-24 14:00:00	IWM	ETF	79.64	80.43	79.2	80.42	19202797.0
2007-10-24 15:00:00	IWM	ETF	80.42	81.0	80.31	80.7	24453276.0
2007-10-24 16:00:00	IWM	ETF	80.7	81.09	79.51	81.08	3367100.0
2007-10-24 17:00:00	IWM	ETF	81.09	81.23	80.87	81.15	617700.0
2007-10-24 18:00:00	IWM	ETF	81.1	81.15	81.06	81.08	11600.0
2007-10-24 19:00:00	IWM	ETF	81.04	81.06	81.02	81.02	43300.0
2007-10-24 07:00:00	DIA	ETF	136.13	136.13	136.1	136.1	700.0
2007-10-24 08:00:00	DIA	ETF	136.03	136.12	135.9	136.08	42700.0
2007-10-24 09:00:00	DIA	ETF	136.09	136.44	136.05	136.28	1658830.0
2007-10-24 10:00:00	DIA	ETF	136.27	136.29	135.16	135.34	3836800.0
2007-10-24 11:00:00	DIA	ETF	135.35	135.43	134.56	134.98	3621100.0

> showing 50 of 3,016 rows — these rows as CSV

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