PREVIEW / etf_1hour / 2010-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-07.parquet
  size:    149 KB
  rows:    4,709

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
2010-01-07 04:00:00	SPY	ETF	113.43	113.43	113.2	113.2	763.0
2010-01-07 05:00:00	SPY	ETF	113.21	113.3	113.2	113.29	30400.0
2010-01-07 06:00:00	SPY	ETF	113.29	113.36	113.25	113.36	11400.0
2010-01-07 07:00:00	SPY	ETF	113.35	113.43	113.28	113.31	920780.0
2010-01-07 08:00:00	SPY	ETF	113.31	113.73	113.31	113.48	4679830.0
2010-01-07 09:00:00	SPY	ETF	113.49	113.69	113.18	113.24	16907419.0
2010-01-07 10:00:00	SPY	ETF	113.2	113.92	113.2	113.81	21042279.0
2010-01-07 11:00:00	SPY	ETF	113.81	113.87	113.558	113.78	10913046.0
2010-01-07 12:00:00	SPY	ETF	113.78	114.03	113.75	113.87	11977490.0
2010-01-07 13:00:00	SPY	ETF	113.88	114.01	113.78	113.92	6762365.0
2010-01-07 14:00:00	SPY	ETF	113.92	114.3	113.7736	114.2	13228582.0
2010-01-07 15:00:00	SPY	ETF	114.2	114.33	113.89	114.2	30309731.0
2010-01-07 16:00:00	SPY	ETF	114.2	114.25	113.48	114.16	11194913.0
2010-01-07 17:00:00	SPY	ETF	114.17	114.21	113.7736	114.15	2077844.0
2010-01-07 18:00:00	SPY	ETF	114.16	114.19	113.7736	114.16	533482.0
2010-01-07 19:00:00	SPY	ETF	114.19	114.26	114.18	114.23	55549.0
2010-01-07 04:00:00	QQQ	ETF	46.07	46.07	46.07	46.07	500.0
2010-01-07 05:00:00	QQQ	ETF	46.09	46.09	46.03	46.03	1200.0
2010-01-07 06:00:00	QQQ	ETF	46.05	46.11	46.05	46.11	600.0
2010-01-07 07:00:00	QQQ	ETF	46.12	46.12	46.05	46.06	550221.0
2010-01-07 08:00:00	QQQ	ETF	46.06	46.2	46.02	46.16	1075543.0
2010-01-07 09:00:00	QQQ	ETF	46.17	46.27	45.96	45.98	9055794.0
2010-01-07 10:00:00	QQQ	ETF	45.98	46.25	45.92	46.16	12764228.0
2010-01-07 11:00:00	QQQ	ETF	46.165	46.18	45.99	46.02	7395464.0
2010-01-07 12:00:00	QQQ	ETF	46.02	46.13	45.99	46.01	7540289.0
2010-01-07 13:00:00	QQQ	ETF	46.0	46.075	45.95	46.01	4942706.0
2010-01-07 14:00:00	QQQ	ETF	46.01	46.15	46.0	46.1225	7988004.0
2010-01-07 15:00:00	QQQ	ETF	46.125	46.17	46.01	46.17	14933417.0
2010-01-07 16:00:00	QQQ	ETF	46.17	46.23	46.0	46.22	3482370.0
2010-01-07 17:00:00	QQQ	ETF	46.22	46.22	46.19	46.2	39017.0
2010-01-07 18:00:00	QQQ	ETF	46.2	46.21	46.19	46.19	118927.0
2010-01-07 19:00:00	QQQ	ETF	46.2	46.22	46.2	46.22	11700.0
2010-01-07 04:00:00	IWM	ETF	63.46	63.46	63.46	63.46	600.0
2010-01-07 07:00:00	IWM	ETF	63.55	63.55	63.48	63.52	24500.0
2010-01-07 08:00:00	IWM	ETF	63.32	63.7	63.32	63.65	612359.0
2010-01-07 09:00:00	IWM	ETF	63.65	64.01	63.14	63.23	11757252.0
2010-01-07 10:00:00	IWM	ETF	63.24	63.93	63.16	63.81	9892144.0
2010-01-07 11:00:00	IWM	ETF	63.82	63.85	63.6	63.73	6754648.0
2010-01-07 12:00:00	IWM	ETF	63.73	63.92	63.71	63.745	3236376.0
2010-01-07 13:00:00	IWM	ETF	63.75	63.86	63.66	63.79	2044288.0
2010-01-07 14:00:00	IWM	ETF	63.79	64.085	63.72	64.03	5020319.0
2010-01-07 15:00:00	IWM	ETF	64.03	64.218	63.87	64.16	9718660.0
2010-01-07 16:00:00	IWM	ETF	64.15	64.19	63.7621	64.1	3090527.0
2010-01-07 17:00:00	IWM	ETF	64.1	64.1	64.05	64.07	34950.0
2010-01-07 19:00:00	IWM	ETF	64.14	64.15	64.14	64.15	400.0
2010-01-07 08:00:00	DIA	ETF	105.4	105.41	105.3	105.33	18800.0
2010-01-07 09:00:00	DIA	ETF	105.35	105.53	104.9499	104.99	898684.0
2010-01-07 10:00:00	DIA	ETF	104.99	105.81	104.98	105.7	1372757.0
2010-01-07 11:00:00	DIA	ETF	105.7	105.73	105.55	105.6501	524831.0
2010-01-07 12:00:00	DIA	ETF	105.65	105.81	105.61	105.68	484402.0

> showing 50 of 4,709 rows — these rows as CSV

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