PREVIEW / etf_1hour / 2007-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-09.parquet
  size:    71 KB
  rows:    2,299

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-09 05:00:00	SPY	ETF	150.83	150.83	150.83	150.83	500.0
2007-05-09 06:00:00	SPY	ETF	150.79	150.79	150.66	150.66	22700.0
2007-05-09 07:00:00	SPY	ETF	150.68	150.72	150.64	150.64	50200.0
2007-05-09 08:00:00	SPY	ETF	150.61	150.65	150.51	150.64	1750400.0
2007-05-09 09:00:00	SPY	ETF	150.65	150.77	150.46	150.63	8776008.0
2007-05-09 10:00:00	SPY	ETF	150.64	150.93	150.63	150.7115	6714250.0
2007-05-09 11:00:00	SPY	ETF	150.72	150.94	150.72	150.72	6575176.0
2007-05-09 12:00:00	SPY	ETF	150.72	151.16	150.72	151.07	6749356.0
2007-05-09 13:00:00	SPY	ETF	151.08	151.12	150.95	150.95	6525005.0
2007-05-09 14:00:00	SPY	ETF	150.96	152.82	150.37	151.3	42179434.0
2007-05-09 15:00:00	SPY	ETF	151.3	151.52	151.15	151.38	17493746.0
2007-05-09 16:00:00	SPY	ETF	151.38	151.38	151.08	151.11	3905200.0
2007-05-09 17:00:00	SPY	ETF	151.13	151.2	151.11	151.14	911400.0
2007-05-09 18:00:00	SPY	ETF	151.13	151.15	151.1	151.1	3200.0
2007-05-09 19:00:00	SPY	ETF	151.1	151.12	151.09	151.12	2700.0
2007-05-09 07:00:00	QQQ	ETF	46.53	46.58	46.52	46.54	103955.0
2007-05-09 08:00:00	QQQ	ETF	46.54	46.65	46.49	46.53	409988.0
2007-05-09 09:00:00	QQQ	ETF	46.54	46.56	46.43	46.49	14192888.0
2007-05-09 10:00:00	QQQ	ETF	46.49	46.64	46.49	46.54	8842671.0
2007-05-09 11:00:00	QQQ	ETF	46.54	46.63	46.52	46.52	6241975.0
2007-05-09 12:00:00	QQQ	ETF	46.52	46.74	46.52	46.69	7445101.0
2007-05-09 13:00:00	QQQ	ETF	46.69	46.7	46.6	46.6	3548179.0
2007-05-09 14:00:00	QQQ	ETF	46.6	46.92	46.49	46.85	43902415.0
2007-05-09 15:00:00	QQQ	ETF	46.86	46.97	46.8	46.84	24969972.0
2007-05-09 16:00:00	QQQ	ETF	46.84	46.86	46.74	46.76	4198911.0
2007-05-09 17:00:00	QQQ	ETF	46.76	46.77	46.75	46.76	644563.0
2007-05-09 18:00:00	QQQ	ETF	46.75	46.76	46.75	46.76	4600.0
2007-05-09 19:00:00	QQQ	ETF	46.75	46.76	46.75	46.76	31324.0
2007-05-09 08:00:00	IWM	ETF	82.07	82.12	82.07	82.1	53700.0
2007-05-09 09:00:00	IWM	ETF	82.1	82.25	81.95	82.15	5542913.0
2007-05-09 10:00:00	IWM	ETF	82.15	82.5	82.15	82.36	7348900.0
2007-05-09 11:00:00	IWM	ETF	82.36	82.51	82.35	82.42	5656385.0
2007-05-09 12:00:00	IWM	ETF	82.42	82.84	82.42	82.76	5264387.0
2007-05-09 13:00:00	IWM	ETF	82.76	82.8	82.55	82.57	3844450.0
2007-05-09 14:00:00	IWM	ETF	82.57	83.23	82.29	82.91	19595237.0
2007-05-09 15:00:00	IWM	ETF	82.91	83.02	82.76	82.9	8985008.0
2007-05-09 16:00:00	IWM	ETF	82.89	83.03	82.55	82.6	5472200.0
2007-05-09 17:00:00	IWM	ETF	82.57	82.6	82.57	82.57	2200.0
2007-05-09 18:00:00	IWM	ETF	82.6	82.6	82.57	82.57	2500.0
2007-05-09 19:00:00	IWM	ETF	82.6	82.63	82.59	82.59	5000.0
2007-05-09 07:00:00	DIA	ETF	133.04	133.04	133.04	133.04	5100.0
2007-05-09 08:00:00	DIA	ETF	133.0	133.04	132.97	133.03	20900.0
2007-05-09 09:00:00	DIA	ETF	133.05	133.17	132.8	133.07	973600.0
2007-05-09 10:00:00	DIA	ETF	133.08	133.23	133.05	133.13	862300.0
2007-05-09 11:00:00	DIA	ETF	133.13	133.24	133.12	133.14	672600.0
2007-05-09 12:00:00	DIA	ETF	133.14	133.53	133.14	133.47	1042100.0
2007-05-09 13:00:00	DIA	ETF	133.46	133.48	133.31	133.34	464200.0
2007-05-09 14:00:00	DIA	ETF	133.33	133.77	132.85	133.59	3837111.0
2007-05-09 15:00:00	DIA	ETF	133.59	133.76	133.5	133.69	1425500.0
2007-05-09 16:00:00	DIA	ETF	133.69	133.69	133.48	133.5	48200.0

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

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