PREVIEW / etf_1hour / 2007-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-15.parquet
  size:    76 KB
  rows:    2,387

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-05-15 05:00:00	SPY	ETF	150.28	150.39	150.28	150.39	30000.0
2007-05-15 06:00:00	SPY	ETF	150.33	150.33	150.12	150.12	10500.0
2007-05-15 07:00:00	SPY	ETF	150.05	150.21	150.05	150.19	505600.0
2007-05-15 08:00:00	SPY	ETF	150.19	150.9	150.06	150.73	7567300.0
2007-05-15 09:00:00	SPY	ETF	150.73	150.98	150.05	150.76	18316318.0
2007-05-15 10:00:00	SPY	ETF	150.76	151.57	150.74	151.1	37601013.0
2007-05-15 11:00:00	SPY	ETF	151.1	151.56	150.89	151.39	19351350.0
2007-05-15 12:00:00	SPY	ETF	151.39	151.665	151.28	151.32	14801051.0
2007-05-15 13:00:00	SPY	ETF	151.32	151.435	150.84	151.07	24763221.0
2007-05-15 14:00:00	SPY	ETF	151.07	151.15	150.22	150.56	26665000.0
2007-05-15 15:00:00	SPY	ETF	150.55	150.68	150.19	150.38	23829955.0
2007-05-15 16:00:00	SPY	ETF	150.38	150.57	150.38	150.4	6421600.0
2007-05-15 17:00:00	SPY	ETF	150.42	150.53	150.41	150.53	251800.0
2007-05-15 18:00:00	SPY	ETF	150.53	150.56	150.46	150.52	232200.0
2007-05-15 19:00:00	SPY	ETF	150.5	150.53	150.45	150.45	14100.0
2007-05-15 05:00:00	QQQ	ETF	46.39	46.39	46.38	46.38	15000.0
2007-05-15 06:00:00	QQQ	ETF	46.36	46.36	46.36	46.36	200.0
2007-05-15 07:00:00	QQQ	ETF	46.27	46.29	46.26	46.28	249566.0
2007-05-15 08:00:00	QQQ	ETF	46.3	46.53	46.25	46.43	3206428.0
2007-05-15 09:00:00	QQQ	ETF	46.43	46.5	46.23	46.3978	22238377.0
2007-05-15 10:00:00	QQQ	ETF	46.39	46.7	46.38	46.5	39733701.0
2007-05-15 11:00:00	QQQ	ETF	46.5	46.65	46.42	46.56	16996089.0
2007-05-15 12:00:00	QQQ	ETF	46.57	46.68	46.48	46.48	12170921.0
2007-05-15 13:00:00	QQQ	ETF	46.48	46.55	46.26	46.37	22026600.0
2007-05-15 14:00:00	QQQ	ETF	46.37	46.4	46.01	46.18	27605240.0
2007-05-15 15:00:00	QQQ	ETF	46.17	46.21	45.99	46.04	26264458.0
2007-05-15 16:00:00	QQQ	ETF	46.03	46.15	46.02	46.07	5326098.0
2007-05-15 17:00:00	QQQ	ETF	46.07	46.1	46.03	46.05	497225.0
2007-05-15 18:00:00	QQQ	ETF	46.07	46.09	46.05	46.06	33658.0
2007-05-15 19:00:00	QQQ	ETF	46.06	46.07	46.04	46.07	5601.0
2007-05-15 07:00:00	IWM	ETF	81.3	81.35	81.3	81.35	1100.0
2007-05-15 08:00:00	IWM	ETF	81.31	81.76	81.26	81.67	884900.0
2007-05-15 09:00:00	IWM	ETF	81.62	81.75	81.22	81.59	9049185.0
2007-05-15 10:00:00	IWM	ETF	81.58	82.28	81.25	81.82	21712184.0
2007-05-15 11:00:00	IWM	ETF	81.81	82.19	81.67	82.05	7786776.0
2007-05-15 12:00:00	IWM	ETF	82.06	82.14	81.73	81.81	7197500.0
2007-05-15 13:00:00	IWM	ETF	81.8	81.89	81.33	81.48	15237200.0
2007-05-15 14:00:00	IWM	ETF	81.49	81.57	80.84	81.12	18147126.0
2007-05-15 15:00:00	IWM	ETF	81.12	81.18	80.78	80.89	23912124.0
2007-05-15 16:00:00	IWM	ETF	80.9	81.0	80.85	80.89	1574800.0
2007-05-15 17:00:00	IWM	ETF	80.87	80.97	80.87	80.97	10800.0
2007-05-15 19:00:00	IWM	ETF	80.93	80.93	80.93	80.93	100.0
2007-05-15 07:00:00	DIA	ETF	133.34	133.38	133.31	133.38	3500.0
2007-05-15 08:00:00	DIA	ETF	133.38	133.97	133.35	133.8	370500.0
2007-05-15 09:00:00	DIA	ETF	133.82	134.0	133.63	133.89	1796832.0
2007-05-15 10:00:00	DIA	ETF	133.89	134.66	133.75	134.45	4927552.0
2007-05-15 11:00:00	DIA	ETF	134.45	134.85	134.31	134.73	2861750.0
2007-05-15 12:00:00	DIA	ETF	134.73	134.94	134.67	134.75	2693579.0
2007-05-15 13:00:00	DIA	ETF	134.75	134.78	134.31	134.47	2660200.0
2007-05-15 14:00:00	DIA	ETF	134.47	134.55	133.91	134.13	2819189.0

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

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