PREVIEW / etf_1hour / 2007-05-17

all etf 1-hour files

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

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-17 06:00:00	SPY	ETF	151.46	151.47	151.44	151.47	27000.0
2007-05-17 07:00:00	SPY	ETF	151.49	151.51	151.44	151.49	53900.0
2007-05-17 08:00:00	SPY	ETF	151.47	151.63	151.31	151.43	1102900.0
2007-05-17 09:00:00	SPY	ETF	151.41	151.47	151.11	151.23	11419479.0
2007-05-17 10:00:00	SPY	ETF	151.23	151.57	151.11	151.51	14849475.0
2007-05-17 11:00:00	SPY	ETF	151.51	151.73	151.38	151.47	12182359.0
2007-05-17 12:00:00	SPY	ETF	151.48	151.59	151.25	151.32	10244044.0
2007-05-17 13:00:00	SPY	ETF	151.32	151.54	151.21	151.44	8316223.0
2007-05-17 14:00:00	SPY	ETF	151.44	151.86	151.36	151.8	12894823.0
2007-05-17 15:00:00	SPY	ETF	151.8	151.96	151.44	151.44	26656273.0
2007-05-17 16:00:00	SPY	ETF	151.42	151.48	151.27	151.36	1358700.0
2007-05-17 17:00:00	SPY	ETF	151.36	151.42	151.31	151.4	574100.0
2007-05-17 18:00:00	SPY	ETF	151.31	151.38	151.31	151.38	22600.0
2007-05-17 19:00:00	SPY	ETF	151.38	151.38	151.35	151.37	700.0
2007-05-17 07:00:00	QQQ	ETF	46.51	46.54	46.51	46.54	5200.0
2007-05-17 08:00:00	QQQ	ETF	46.54	46.58	46.46	46.51	2082507.0
2007-05-17 09:00:00	QQQ	ETF	46.5	46.51	46.38	46.465	11988309.0
2007-05-17 10:00:00	QQQ	ETF	46.46	46.57	46.32	46.477	19668708.0
2007-05-17 11:00:00	QQQ	ETF	46.4786	46.52	46.35	46.42	13588528.0
2007-05-17 12:00:00	QQQ	ETF	46.42	46.48	46.34	46.34	13513628.0
2007-05-17 13:00:00	QQQ	ETF	46.34	46.45	46.29	46.37	10711375.0
2007-05-17 14:00:00	QQQ	ETF	46.37	46.51	46.34	46.5	13498583.0
2007-05-17 15:00:00	QQQ	ETF	46.4986	46.55	46.33	46.34	20131882.0
2007-05-17 16:00:00	QQQ	ETF	46.33	46.37	46.28	46.35	3138740.0
2007-05-17 17:00:00	QQQ	ETF	46.35	46.39	46.34	46.39	636666.0
2007-05-17 18:00:00	QQQ	ETF	46.37	46.39	46.34	46.37	340588.0
2007-05-17 19:00:00	QQQ	ETF	46.37	46.38	46.34	46.36	81029.0
2007-05-17 07:00:00	IWM	ETF	81.1	81.37	81.1	81.37	1900.0
2007-05-17 08:00:00	IWM	ETF	81.4	81.45	81.25	81.36	315400.0
2007-05-17 09:00:00	IWM	ETF	81.34	81.36	80.89	80.98	8877200.0
2007-05-17 10:00:00	IWM	ETF	80.97	81.18	80.78	81.02	11657417.0
2007-05-17 11:00:00	IWM	ETF	81.01	81.33	80.89	81.08	8724282.0
2007-05-17 12:00:00	IWM	ETF	81.09	81.14	80.84	80.86	6486589.0
2007-05-17 13:00:00	IWM	ETF	80.86	81.06	80.71	80.98	5157300.0
2007-05-17 14:00:00	IWM	ETF	80.98	81.3	80.93	81.27	9318800.0
2007-05-17 15:00:00	IWM	ETF	81.28	81.41	80.94	80.95	13961625.0
2007-05-17 16:00:00	IWM	ETF	80.94	80.96	80.75	80.79	1287400.0
2007-05-17 17:00:00	IWM	ETF	80.81	81.4894	80.76	81.4894	1323100.0
2007-05-17 18:00:00	IWM	ETF	80.78	80.78	80.77	80.77	600.0
2007-05-17 07:00:00	DIA	ETF	135.0	135.03	134.98	135.02	5500.0
2007-05-17 08:00:00	DIA	ETF	134.98	135.06	134.88	134.94	110800.0
2007-05-17 09:00:00	DIA	ETF	134.96	134.99	134.72	134.83	885000.0
2007-05-17 10:00:00	DIA	ETF	134.83	135.33	134.75	135.04	2333451.0
2007-05-17 11:00:00	DIA	ETF	135.05	135.22	134.94	134.97	1490500.0
2007-05-17 12:00:00	DIA	ETF	134.98	135.07	134.73	134.8	1027777.0
2007-05-17 13:00:00	DIA	ETF	134.79	134.99	134.71	134.86	650800.0
2007-05-17 14:00:00	DIA	ETF	134.87	135.33	134.8	135.28	2161800.0
2007-05-17 15:00:00	DIA	ETF	135.28	135.4	134.95	134.95	2071805.0
2007-05-17 16:00:00	DIA	ETF	134.95	134.98	134.89	134.96	109700.0
2007-05-17 17:00:00	DIA	ETF	134.96	134.96	134.96	134.96	409000.0

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

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