PREVIEW / etf_1hour / 2007-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-03.parquet
  size:    85 KB
  rows:    2,825

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-10-03 04:00:00	SPY	ETF	153.97	153.97	153.97	153.97	25000.0
2007-10-03 05:00:00	SPY	ETF	153.94	153.97	153.94	153.94	33500.0
2007-10-03 06:00:00	SPY	ETF	153.94	154.04	153.94	154.01	17300.0
2007-10-03 07:00:00	SPY	ETF	154.03	154.05	153.66	153.72	721700.0
2007-10-03 08:00:00	SPY	ETF	153.72	154.27	153.66	153.87	2566800.0
2007-10-03 09:00:00	SPY	ETF	153.86	153.95	153.49	153.5	12659630.0
2007-10-03 10:00:00	SPY	ETF	153.5	154.19	153.01	154.17	22242050.0
2007-10-03 11:00:00	SPY	ETF	154.17	154.41	154.0388	154.33	16249500.0
2007-10-03 12:00:00	SPY	ETF	154.34	154.39	154.08	154.24	8289100.0
2007-10-03 13:00:00	SPY	ETF	154.23	154.26	153.65	153.79	12128900.0
2007-10-03 14:00:00	SPY	ETF	153.79	153.8	153.45	153.71	16104064.0
2007-10-03 15:00:00	SPY	ETF	153.7	153.9	153.54	153.8	19784600.0
2007-10-03 16:00:00	SPY	ETF	153.84	153.95	153.7301	153.9	4725200.0
2007-10-03 17:00:00	SPY	ETF	153.9	153.96	153.78	153.96	1326400.0
2007-10-03 18:00:00	SPY	ETF	153.95	154.0	153.93	153.96	175900.0
2007-10-03 19:00:00	SPY	ETF	153.96	153.99	153.95	153.97	13000.0
2007-10-03 05:00:00	QQQ	ETF	51.88	51.88	51.86	51.87	100000.0
2007-10-03 07:00:00	QQQ	ETF	51.89	51.89	51.7	51.77	1074896.0
2007-10-03 08:00:00	QQQ	ETF	51.77	51.97	51.77	51.85	1128457.0
2007-10-03 09:00:00	QQQ	ETF	51.85	51.88	51.66	51.66	8969189.0
2007-10-03 10:00:00	QQQ	ETF	51.6601	51.99	51.66	51.98	18388038.0
2007-10-03 11:00:00	QQQ	ETF	51.97	52.07	51.93	52.009	8342739.0
2007-10-03 12:00:00	QQQ	ETF	52.0006	52.01	51.89	51.96	5325400.0
2007-10-03 13:00:00	QQQ	ETF	51.96	51.98	51.71	51.76	12014731.0
2007-10-03 14:00:00	QQQ	ETF	51.76	51.76	51.5	51.608	18573589.0
2007-10-03 15:00:00	QQQ	ETF	51.61	51.73	51.57	51.69	15913561.0
2007-10-03 16:00:00	QQQ	ETF	51.69	52.0159	51.6	51.63	16813846.0
2007-10-03 17:00:00	QQQ	ETF	51.63	51.72	51.61	51.7	56300.0
2007-10-03 18:00:00	QQQ	ETF	51.67	51.68	51.65	51.67	47710.0
2007-10-03 19:00:00	QQQ	ETF	51.68	51.69	51.65	51.66	36464.0
2007-10-03 07:00:00	IWM	ETF	82.3	82.3	82.22	82.22	10000.0
2007-10-03 08:00:00	IWM	ETF	82.25	82.4	82.23	82.39	45600.0
2007-10-03 09:00:00	IWM	ETF	82.38	82.67	81.99	82.03	9748147.0
2007-10-03 10:00:00	IWM	ETF	82.03	82.57	81.99	82.55	11226200.0
2007-10-03 11:00:00	IWM	ETF	82.56	82.76	82.47	82.67	5835200.0
2007-10-03 12:00:00	IWM	ETF	82.67	82.74	82.6	82.71	3419800.0
2007-10-03 13:00:00	IWM	ETF	82.71	82.72	82.22	82.26	6681300.0
2007-10-03 14:00:00	IWM	ETF	82.25	82.26	81.96	82.12	9436600.0
2007-10-03 15:00:00	IWM	ETF	82.12	82.33	81.99	82.31	7432800.0
2007-10-03 16:00:00	IWM	ETF	82.31	82.81	82.19	82.31	3075400.0
2007-10-03 17:00:00	IWM	ETF	82.31	82.31	82.28	82.31	2300.0
2007-10-03 18:00:00	IWM	ETF	82.35	82.39	82.35	82.39	600.0
2007-10-03 19:00:00	IWM	ETF	82.39	82.45	82.39	82.4	10400.0
2007-10-03 07:00:00	DIA	ETF	140.02	140.02	139.87	139.87	2000.0
2007-10-03 08:00:00	DIA	ETF	139.84	139.97	139.82	139.95	23800.0
2007-10-03 09:00:00	DIA	ETF	139.95	139.96	139.63	139.66	1043400.0
2007-10-03 10:00:00	DIA	ETF	139.66	140.15	139.66	140.12	1644600.0
2007-10-03 11:00:00	DIA	ETF	140.14	140.27	140.02	140.17	1182000.0
2007-10-03 12:00:00	DIA	ETF	140.19	140.19	139.9	140.04	694900.0
2007-10-03 13:00:00	DIA	ETF	140.04	140.07	139.51	139.61	1263900.0

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

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