PREVIEW / etf_1hour / 2007-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-19.parquet
  size:    79 KB
  rows:    2,721

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-07-19 04:00:00	SPY	ETF	154.89	154.89	154.86	154.86	7900.0
2007-07-19 05:00:00	SPY	ETF	154.82	154.87	154.81	154.87	36300.0
2007-07-19 06:00:00	SPY	ETF	154.77	155.0	154.77	155.0	91300.0
2007-07-19 07:00:00	SPY	ETF	154.99	155.14	154.98	155.03	1216300.0
2007-07-19 08:00:00	SPY	ETF	154.61	155.28	154.3	155.27	3821007.0
2007-07-19 09:00:00	SPY	ETF	155.27	155.53	155.14	155.34	20320422.0
2007-07-19 10:00:00	SPY	ETF	155.33	155.38	154.78	154.88	30210533.0
2007-07-19 11:00:00	SPY	ETF	154.88	155.24	154.87	155.06	14044201.0
2007-07-19 12:00:00	SPY	ETF	155.06	155.38	154.89	155.2585	12632601.0
2007-07-19 13:00:00	SPY	ETF	155.25	155.34	155.09	155.24	8530093.0
2007-07-19 14:00:00	SPY	ETF	155.25	155.275	154.75	155.03	22666589.0
2007-07-19 15:00:00	SPY	ETF	155.03	155.39	155.0	155.21	22587091.0
2007-07-19 16:00:00	SPY	ETF	155.24	155.275	154.68	154.72	5523100.0
2007-07-19 17:00:00	SPY	ETF	154.72	154.85	154.64	154.68	261200.0
2007-07-19 18:00:00	SPY	ETF	155.07	155.07	154.7	154.84	89200.0
2007-07-19 19:00:00	SPY	ETF	154.84	154.84	154.79	154.8	32600.0
2007-07-19 04:00:00	QQQ	ETF	50.33	50.33	50.33	50.33	500.0
2007-07-19 05:00:00	QQQ	ETF	50.37	50.37	50.37	50.37	600.0
2007-07-19 06:00:00	QQQ	ETF	50.29	50.41	50.29	50.41	123301.0
2007-07-19 07:00:00	QQQ	ETF	50.41	50.48	50.4	50.42	260383.0
2007-07-19 08:00:00	QQQ	ETF	50.41	50.53	50.4	50.52	2143174.0
2007-07-19 09:00:00	QQQ	ETF	50.52	50.53	50.38	50.45	16463691.0
2007-07-19 10:00:00	QQQ	ETF	50.45	50.47	50.31	50.36	17094586.0
2007-07-19 11:00:00	QQQ	ETF	50.36	50.47	50.36	50.41	10426439.0
2007-07-19 12:00:00	QQQ	ETF	50.418	50.6	50.37	50.55	12342741.0
2007-07-19 13:00:00	QQQ	ETF	50.55	50.66	50.51	50.64	11051841.0
2007-07-19 14:00:00	QQQ	ETF	50.63	50.64	50.47	50.57	14393936.0
2007-07-19 15:00:00	QQQ	ETF	50.57	50.63	50.41	50.42	17753939.0
2007-07-19 16:00:00	QQQ	ETF	50.42	50.58	50.22	50.22	8679213.0
2007-07-19 17:00:00	QQQ	ETF	50.23	50.24	50.18	50.21	406397.0
2007-07-19 18:00:00	QQQ	ETF	50.21	50.25	50.2	50.25	206084.0
2007-07-19 19:00:00	QQQ	ETF	50.22	50.25	50.22	50.23	8165.0
2007-07-19 07:00:00	IWM	ETF	84.62	84.69	84.62	84.69	54600.0
2007-07-19 08:00:00	IWM	ETF	84.69	84.79	84.68	84.76	374900.0
2007-07-19 09:00:00	IWM	ETF	84.76	84.95	84.66	84.72	7297734.0
2007-07-19 10:00:00	IWM	ETF	84.72	84.87	84.51	84.62	8989459.0
2007-07-19 11:00:00	IWM	ETF	84.62	84.77	84.59	84.62	5401143.0
2007-07-19 12:00:00	IWM	ETF	84.62	84.86	84.47	84.78	4657400.0
2007-07-19 13:00:00	IWM	ETF	84.77	84.89	84.67	84.8	4447018.0
2007-07-19 14:00:00	IWM	ETF	84.8	84.82	84.6	84.73	7568929.0
2007-07-19 15:00:00	IWM	ETF	84.73	84.89	84.7	84.72	11258659.0
2007-07-19 16:00:00	IWM	ETF	84.72	84.79	84.48	84.52	6491400.0
2007-07-19 17:00:00	IWM	ETF	84.58	84.58	84.34	84.35	2146500.0
2007-07-19 18:00:00	IWM	ETF	84.44	84.58	84.4	84.55	47900.0
2007-07-19 19:00:00	IWM	ETF	84.48	84.48	84.45	84.45	2900.0
2007-07-19 07:00:00	DIA	ETF	139.86	139.88	139.82	139.84	57600.0
2007-07-19 08:00:00	DIA	ETF	139.87	139.99	139.74	139.94	112300.0
2007-07-19 09:00:00	DIA	ETF	139.97	140.17	139.93	139.99	1285122.0
2007-07-19 10:00:00	DIA	ETF	140.0	140.1	139.64	139.73	1853556.0
2007-07-19 11:00:00	DIA	ETF	139.73	140.06	139.73	139.95	1019114.0

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

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