PREVIEW / etf_1hour / 2007-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-13.parquet
  size:    85 KB
  rows:    2,841

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-08-13 04:00:00	SPY	ETF	146.11	146.16	145.75	145.75	45400.0
2007-08-13 05:00:00	SPY	ETF	145.74	145.75	145.65	145.66	43700.0
2007-08-13 06:00:00	SPY	ETF	145.64	145.84	145.64	145.75	39700.0
2007-08-13 07:00:00	SPY	ETF	145.75	146.21	145.7	146.05	1999100.0
2007-08-13 08:00:00	SPY	ETF	146.06	146.57	144.71	146.44	4135600.0
2007-08-13 09:00:00	SPY	ETF	146.45	146.77	146.04	146.23	23793100.0
2007-08-13 10:00:00	SPY	ETF	146.23	146.67	145.98	146.25	24365700.0
2007-08-13 11:00:00	SPY	ETF	146.27	146.89	145.88	146.62	21555700.0
2007-08-13 12:00:00	SPY	ETF	146.629	146.65	145.92	146.215	16214900.0
2007-08-13 13:00:00	SPY	ETF	146.22	146.64	145.55	146.21	21060700.0
2007-08-13 14:00:00	SPY	ETF	146.21	146.58	145.94	146.11	20832600.0
2007-08-13 15:00:00	SPY	ETF	146.12	146.31	145.28	145.51	31518400.0
2007-08-13 16:00:00	SPY	ETF	145.48	145.64	145.01	145.06	5282000.0
2007-08-13 17:00:00	SPY	ETF	145.05	145.5469	144.9	145.09	6258500.0
2007-08-13 18:00:00	SPY	ETF	145.06	145.12	145.0	145.08	60600.0
2007-08-13 19:00:00	SPY	ETF	145.05	145.05	144.88	144.95	42600.0
2007-08-13 04:00:00	QQQ	ETF	47.59	47.59	47.59	47.59	200.0
2007-08-13 05:00:00	QQQ	ETF	47.41	47.44	47.41	47.44	20000.0
2007-08-13 06:00:00	QQQ	ETF	47.42	47.51	47.42	47.5	65400.0
2007-08-13 07:00:00	QQQ	ETF	47.49	47.61	47.48	47.6	303111.0
2007-08-13 08:00:00	QQQ	ETF	47.6	47.76	47.39	47.73	1225709.0
2007-08-13 09:00:00	QQQ	ETF	47.73	47.78	47.54	47.59	15860711.0
2007-08-13 10:00:00	QQQ	ETF	47.586	47.81	47.56	47.67	15293778.0
2007-08-13 11:00:00	QQQ	ETF	47.67	47.88	47.59	47.81	14124106.0
2007-08-13 12:00:00	QQQ	ETF	47.8115	47.85	47.62	47.75	11923903.0
2007-08-13 13:00:00	QQQ	ETF	47.74	47.76	47.48	47.6915	12200244.0
2007-08-13 14:00:00	QQQ	ETF	47.6989	47.83	47.6	47.7	13322800.0
2007-08-13 15:00:00	QQQ	ETF	47.7	47.8	47.5	47.61	21938906.0
2007-08-13 16:00:00	QQQ	ETF	47.61	47.63	47.5	47.52	2612883.0
2007-08-13 17:00:00	QQQ	ETF	47.51	47.55	47.47	47.55	5379334.0
2007-08-13 18:00:00	QQQ	ETF	47.51	47.53	47.49	47.52	27326.0
2007-08-13 19:00:00	QQQ	ETF	47.52	47.52	47.46	47.46	22952.0
2007-08-13 06:00:00	IWM	ETF	78.58	78.58	78.51	78.51	7500.0
2007-08-13 07:00:00	IWM	ETF	78.64	79.14	78.59	79.05	603700.0
2007-08-13 08:00:00	IWM	ETF	79.05	79.44	78.06	79.42	1564900.0
2007-08-13 09:00:00	IWM	ETF	79.41	79.96	79.1	79.14	18062000.0
2007-08-13 10:00:00	IWM	ETF	79.14	79.52	78.76	78.94	16146400.0
2007-08-13 11:00:00	IWM	ETF	78.95	78.99	78.51	78.76	18313000.0
2007-08-13 12:00:00	IWM	ETF	78.76	78.76	77.95	78.29	13567500.0
2007-08-13 13:00:00	IWM	ETF	78.29	78.32	77.61	78.15	12560000.0
2007-08-13 14:00:00	IWM	ETF	78.14	78.28	77.77	77.97	10274500.0
2007-08-13 15:00:00	IWM	ETF	77.96	78.2	77.56	77.59	17678400.0
2007-08-13 16:00:00	IWM	ETF	77.59	77.72	77.53	77.6	1525400.0
2007-08-13 17:00:00	IWM	ETF	77.65	77.66	77.61	77.63	3800.0
2007-08-13 18:00:00	IWM	ETF	77.64	77.64	77.64	77.64	2000.0
2007-08-13 19:00:00	IWM	ETF	77.54	77.54	77.54	77.54	1000.0
2007-08-13 07:00:00	DIA	ETF	132.55	132.95	132.55	132.95	9700.0
2007-08-13 08:00:00	DIA	ETF	132.96	133.3	132.88	133.23	919000.0
2007-08-13 09:00:00	DIA	ETF	133.24	133.37	132.91	133.06	2041300.0
2007-08-13 10:00:00	DIA	ETF	133.05	133.37	132.77	132.98	3040200.0

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

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