PREVIEW / etf_1hour / 2007-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-07.parquet
  size:    85 KB
  rows:    2,839

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-09-07 04:00:00	SPY	ETF	148.0	148.0	148.0	148.0	100.0
2007-09-07 05:00:00	SPY	ETF	147.56	147.56	147.56	147.56	1000.0
2007-09-07 06:00:00	SPY	ETF	147.61	147.76	147.48	147.6	53600.0
2007-09-07 07:00:00	SPY	ETF	147.57	147.85	147.52	147.82	632400.0
2007-09-07 08:00:00	SPY	ETF	147.59	147.9	146.6	146.67	15831600.0
2007-09-07 09:00:00	SPY	ETF	146.65	146.83	146.16	146.51	26711079.0
2007-09-07 10:00:00	SPY	ETF	146.5	146.83	145.82	145.91	36981199.0
2007-09-07 11:00:00	SPY	ETF	145.92	146.47	145.6	146.38	25810300.0
2007-09-07 12:00:00	SPY	ETF	146.38	146.62	146.06	146.44	19793700.0
2007-09-07 13:00:00	SPY	ETF	146.44	146.89	146.05	146.14	21405700.0
2007-09-07 14:00:00	SPY	ETF	146.14	146.34	145.5	145.56	24314300.0
2007-09-07 15:00:00	SPY	ETF	145.56	146.1	145.26	145.84	54829400.0
2007-09-07 16:00:00	SPY	ETF	145.9	146.5656	145.78	146.15	4825400.0
2007-09-07 17:00:00	SPY	ETF	146.15	146.18	145.84	146.0	1573400.0
2007-09-07 18:00:00	SPY	ETF	145.88	146.2	145.88	146.2	19300.0
2007-09-07 19:00:00	SPY	ETF	146.2	146.25	146.17	146.19	2400.0
2007-09-07 07:00:00	QQQ	ETF	48.92	48.96	48.91	48.92	37996.0
2007-09-07 08:00:00	QQQ	ETF	48.99	49.25	48.66	48.66	9904447.0
2007-09-07 09:00:00	QQQ	ETF	48.65	48.67	48.36	48.511	15305774.0
2007-09-07 10:00:00	QQQ	ETF	48.51	48.59	48.04	48.081	26206670.0
2007-09-07 11:00:00	QQQ	ETF	48.0895	48.33	47.99	48.33	20367877.0
2007-09-07 12:00:00	QQQ	ETF	48.33	48.37	48.18	48.27	11281210.0
2007-09-07 13:00:00	QQQ	ETF	48.2785	48.4	48.15	48.17	10721173.0
2007-09-07 14:00:00	QQQ	ETF	48.17	48.25	48.01	48.02	11513448.0
2007-09-07 15:00:00	QQQ	ETF	48.01	48.23	47.95	48.23	27563488.0
2007-09-07 16:00:00	QQQ	ETF	48.23	48.38	48.1414	48.34	4284311.0
2007-09-07 17:00:00	QQQ	ETF	48.36	48.38	48.32	48.35	81192.0
2007-09-07 18:00:00	QQQ	ETF	48.33	48.36	48.32	48.36	14825.0
2007-09-07 19:00:00	QQQ	ETF	48.36	48.38	48.31	48.33	26696.0
2007-09-07 07:00:00	IWM	ETF	78.66	78.77	78.66	78.77	22000.0
2007-09-07 08:00:00	IWM	ETF	78.81	79.03	77.93	77.99	10287900.0
2007-09-07 09:00:00	IWM	ETF	77.95	78.02	77.4	77.73	15227648.0
2007-09-07 10:00:00	IWM	ETF	77.73	77.93	77.11	77.15	11164400.0
2007-09-07 11:00:00	IWM	ETF	77.17	77.48	76.99	77.45	7748400.0
2007-09-07 12:00:00	IWM	ETF	77.45	77.58	77.18	77.37	8432600.0
2007-09-07 13:00:00	IWM	ETF	77.37	77.68	77.15	77.26	6980400.0
2007-09-07 14:00:00	IWM	ETF	77.26	77.43	77.05	77.07	6536700.0
2007-09-07 15:00:00	IWM	ETF	77.07	77.47	77.0	77.42	12969800.0
2007-09-07 16:00:00	IWM	ETF	77.41	77.73	77.41	77.6	6246600.0
2007-09-07 17:00:00	IWM	ETF	77.52	77.52	77.42	77.42	19200.0
2007-09-07 18:00:00	IWM	ETF	77.66	77.66	77.66	77.66	10000000.0
2007-09-07 19:00:00	IWM	ETF	77.6	77.6	77.6	77.6	1000.0
2007-09-07 07:00:00	DIA	ETF	133.17	133.21	133.17	133.21	1400.0
2007-09-07 08:00:00	DIA	ETF	133.37	133.37	132.36	132.47	196600.0
2007-09-07 09:00:00	DIA	ETF	132.45	132.52	131.97	132.23	1748200.0
2007-09-07 10:00:00	DIA	ETF	132.27	132.4	131.47	131.56	2808600.0
2007-09-07 11:00:00	DIA	ETF	131.57	131.82	131.22	131.76	2106700.0
2007-09-07 12:00:00	DIA	ETF	131.77	131.94	131.5	131.83	3465500.0
2007-09-07 13:00:00	DIA	ETF	131.82	132.11	131.5	131.51	1848800.0
2007-09-07 14:00:00	DIA	ETF	131.52	131.69	131.05	131.06	2039200.0

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

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