PREVIEW / etf_1hour / 2007-05-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	149.42	149.42	149.42	149.42	500.0
2007-05-11 06:00:00	SPY	ETF	149.81	149.81	149.7	149.7	16100.0
2007-05-11 07:00:00	SPY	ETF	149.61	149.77	149.61	149.7	122900.0
2007-05-11 08:00:00	SPY	ETF	149.68	150.03	149.64	149.85	7119600.0
2007-05-11 09:00:00	SPY	ETF	149.85	150.06	149.72	149.83	12435009.0
2007-05-11 10:00:00	SPY	ETF	149.85	150.55	149.72	150.46	27469432.0
2007-05-11 11:00:00	SPY	ETF	150.46	150.61	150.12	150.4	15506700.0
2007-05-11 12:00:00	SPY	ETF	150.4	150.44	150.15	150.38	13287050.0
2007-05-11 13:00:00	SPY	ETF	150.38	150.53	150.25	150.31	7699428.0
2007-05-11 14:00:00	SPY	ETF	150.31	150.43	150.19	150.33	8133353.0
2007-05-11 15:00:00	SPY	ETF	150.32	150.82	150.25	150.81	16505169.0
2007-05-11 16:00:00	SPY	ETF	150.82	150.98	150.74	150.9	3023400.0
2007-05-11 17:00:00	SPY	ETF	150.9	150.9	150.84	150.9	880400.0
2007-05-11 18:00:00	SPY	ETF	150.9	150.9	150.85	150.85	1800.0
2007-05-11 19:00:00	SPY	ETF	150.93	150.94	150.91	150.94	2600.0
2007-05-11 06:00:00	QQQ	ETF	46.15	46.22	46.15	46.22	1100.0
2007-05-11 07:00:00	QQQ	ETF	46.24	46.25	46.19	46.2	193195.0
2007-05-11 08:00:00	QQQ	ETF	46.2	46.46	46.09	46.2	3830475.0
2007-05-11 09:00:00	QQQ	ETF	46.21	46.36	46.15	46.22	6352367.0
2007-05-11 10:00:00	QQQ	ETF	46.22	46.49	46.18	46.47	22651565.0
2007-05-11 11:00:00	QQQ	ETF	46.47	46.64	46.46	46.56	16880096.0
2007-05-11 12:00:00	QQQ	ETF	46.56	46.6	46.46	46.56	7798233.0
2007-05-11 13:00:00	QQQ	ETF	46.55	46.63	46.5	46.56	9413393.0
2007-05-11 14:00:00	QQQ	ETF	46.55	46.59	46.5	46.57	6807255.0
2007-05-11 15:00:00	QQQ	ETF	46.56	46.74	46.54	46.73	17250887.0
2007-05-11 16:00:00	QQQ	ETF	46.73	46.8	46.54	46.76	1446791.0
2007-05-11 17:00:00	QQQ	ETF	46.8	46.83	46.24	46.79	2234860.0
2007-05-11 18:00:00	QQQ	ETF	46.79	46.8	46.78	46.8	8325.0
2007-05-11 19:00:00	QQQ	ETF	46.79	46.8	46.79	46.8	10197.0
2007-05-11 07:00:00	IWM	ETF	81.65	81.78	81.65	81.78	1100.0
2007-05-11 08:00:00	IWM	ETF	81.7	81.92	81.65	81.85	1859100.0
2007-05-11 09:00:00	IWM	ETF	81.82	81.94	81.65	81.77	6835500.0
2007-05-11 10:00:00	IWM	ETF	81.77	82.21	81.65	82.12	12109340.0
2007-05-11 11:00:00	IWM	ETF	82.11	82.36	81.97	82.17	11986660.0
2007-05-11 12:00:00	IWM	ETF	82.17	82.17	81.95	82.07	6765755.0
2007-05-11 13:00:00	IWM	ETF	82.07	82.21	81.99	82.11	2940015.0
2007-05-11 14:00:00	IWM	ETF	82.11	82.19	81.95	82.1	2569900.0
2007-05-11 15:00:00	IWM	ETF	82.1	82.45	82.05	82.43	7229854.0
2007-05-11 16:00:00	IWM	ETF	82.43	82.45	81.82	82.25	2240600.0
2007-05-11 07:00:00	DIA	ETF	132.33	132.49	132.33	132.49	200.0
2007-05-11 08:00:00	DIA	ETF	132.63	132.96	132.59	132.75	188600.0
2007-05-11 09:00:00	DIA	ETF	132.72	132.95	132.64	132.71	1148350.0
2007-05-11 10:00:00	DIA	ETF	132.71	133.28	132.6	133.18	2686807.0
2007-05-11 11:00:00	DIA	ETF	133.19	133.32	133.16	133.28	1429800.0
2007-05-11 12:00:00	DIA	ETF	133.28	133.28	133.04	133.2	927100.0
2007-05-11 13:00:00	DIA	ETF	133.2	133.29	133.07	133.13	631700.0
2007-05-11 14:00:00	DIA	ETF	133.13	133.15	132.95	133.08	820700.0
2007-05-11 15:00:00	DIA	ETF	133.08	133.47	133.0	133.45	1434500.0
2007-05-11 16:00:00	DIA	ETF	133.45	133.56	133.42	133.56	114300.0
2007-05-11 17:00:00	DIA	ETF	133.56	133.56	133.46	133.46	10900.0

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

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