PREVIEW / etf_1hour / 2007-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-30.parquet
  size:    72 KB
  rows:    2,298

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-04-30 04:00:00	SPY	ETF	149.4	149.4	149.4	149.4	100.0
2007-04-30 06:00:00	SPY	ETF	149.58	149.6	149.47	149.47	11500.0
2007-04-30 07:00:00	SPY	ETF	149.53	149.69	149.53	149.62	332300.0
2007-04-30 08:00:00	SPY	ETF	149.62	149.9	149.58	149.67	2164700.0
2007-04-30 09:00:00	SPY	ETF	149.68	149.68	149.14	149.34	11582211.0
2007-04-30 10:00:00	SPY	ETF	149.34	149.74	149.19	149.68	15390435.0
2007-04-30 11:00:00	SPY	ETF	149.68	149.74	149.34	149.38	9643029.0
2007-04-30 12:00:00	SPY	ETF	149.38	149.67	149.31	149.52	7022304.0
2007-04-30 13:00:00	SPY	ETF	149.51	149.67	149.42	149.51	4594463.0
2007-04-30 14:00:00	SPY	ETF	149.51	149.59	148.9	148.98	16623784.0
2007-04-30 15:00:00	SPY	ETF	148.98	149.59	148.21	148.23	26766748.0
2007-04-30 16:00:00	SPY	ETF	148.24	149.03	148.18	148.21	4530800.0
2007-04-30 17:00:00	SPY	ETF	148.25	148.29	148.15	148.2	254100.0
2007-04-30 18:00:00	SPY	ETF	148.17	148.29	148.15	148.29	130000.0
2007-04-30 19:00:00	SPY	ETF	148.23	148.33	148.23	148.33	9600.0
2007-04-30 06:00:00	QQQ	ETF	46.53	46.53	46.53	46.53	2500.0
2007-04-30 07:00:00	QQQ	ETF	46.5	46.56	46.49	46.54	55900.0
2007-04-30 08:00:00	QQQ	ETF	46.52	46.62	46.51	46.53	560818.0
2007-04-30 09:00:00	QQQ	ETF	46.52	46.53	46.28	46.35	12495249.0
2007-04-30 10:00:00	QQQ	ETF	46.34	46.53	46.28	46.5	13668586.0
2007-04-30 11:00:00	QQQ	ETF	46.5	46.51	46.32	46.35	10648560.0
2007-04-30 12:00:00	QQQ	ETF	46.35	46.44	46.34	46.38	4682560.0
2007-04-30 13:00:00	QQQ	ETF	46.37	46.44	46.34	46.3699	3665288.0
2007-04-30 14:00:00	QQQ	ETF	46.36	46.39	46.11	46.15	15678926.0
2007-04-30 15:00:00	QQQ	ETF	46.15	46.2	45.92	45.96	25147224.0
2007-04-30 16:00:00	QQQ	ETF	45.96	45.99	45.89	45.9	3534079.0
2007-04-30 17:00:00	QQQ	ETF	45.9	45.96	45.84	45.86	1488607.0
2007-04-30 18:00:00	QQQ	ETF	45.86	45.92	45.86	45.92	104031.0
2007-04-30 19:00:00	QQQ	ETF	45.92	45.95	45.9	45.94	31885.0
2007-04-30 08:00:00	IWM	ETF	82.52	82.71	82.46	82.57	1161300.0
2007-04-30 09:00:00	IWM	ETF	82.54	82.54	82.05	82.21	6322523.0
2007-04-30 10:00:00	IWM	ETF	82.21	82.34	81.9615	82.29	7426680.0
2007-04-30 11:00:00	IWM	ETF	82.29	82.3	82.09	82.12	3831765.0
2007-04-30 12:00:00	IWM	ETF	82.11	82.23	82.1	82.12	3706301.0
2007-04-30 13:00:00	IWM	ETF	82.12	82.21	82.06	82.12	3180982.0
2007-04-30 14:00:00	IWM	ETF	82.12	82.19	81.04	81.32	28395352.0
2007-04-30 15:00:00	IWM	ETF	81.32	82.06	80.75	80.77	25728339.0
2007-04-30 16:00:00	IWM	ETF	80.76	82.3811	80.66	80.74	3432600.0
2007-04-30 17:00:00	IWM	ETF	80.74	80.74	80.56	80.56	68300.0
2007-04-30 18:00:00	IWM	ETF	80.66	80.72	80.65	80.72	187500.0
2007-04-30 07:00:00	DIA	ETF	131.27	131.28	131.26	131.26	700.0
2007-04-30 08:00:00	DIA	ETF	131.25	131.4	131.17	131.22	17300.0
2007-04-30 09:00:00	DIA	ETF	131.16	131.18	130.87	131.07	807900.0
2007-04-30 10:00:00	DIA	ETF	131.09	131.47	130.95	131.38	2074821.0
2007-04-30 11:00:00	DIA	ETF	131.37	131.4	131.14	131.2	624555.0
2007-04-30 12:00:00	DIA	ETF	131.2	131.49	131.19	131.38	827750.0
2007-04-30 13:00:00	DIA	ETF	131.37	131.53	131.34	131.41	449850.0
2007-04-30 14:00:00	DIA	ETF	131.42	131.47	131.0	131.11	1227700.0
2007-04-30 15:00:00	DIA	ETF	131.11	131.98	130.54	130.56	2570773.0
2007-04-30 16:00:00	DIA	ETF	130.54	131.1115	130.54	130.67	1327800.0

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

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