PREVIEW / etf_1hour / 2010-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-17.parquet
  size:    159 KB
  rows:    5,073

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-09-17 04:00:00	SPY	ETF	113.12	113.72	113.12	113.61	19332.0
2010-09-17 05:00:00	SPY	ETF	113.64	113.69	113.55	113.55	18475.0
2010-09-17 06:00:00	SPY	ETF	113.54	113.57	113.35	113.44	48484.0
2010-09-17 07:00:00	SPY	ETF	113.45	113.6	112.98	113.1	876148.0
2010-09-17 08:00:00	SPY	ETF	113.13	113.59	112.85	112.91	3949201.0
2010-09-17 09:00:00	SPY	ETF	112.92	113.16	112.29	112.41	42430154.0
2010-09-17 10:00:00	SPY	ETF	112.42	112.65	112.18	112.54	40050928.0
2010-09-17 11:00:00	SPY	ETF	112.5461	112.79	112.34	112.42	20815086.0
2010-09-17 12:00:00	SPY	ETF	112.41	112.66	112.36	112.42	8706584.0
2010-09-17 13:00:00	SPY	ETF	112.42	112.57	112.31	112.5199	11717705.0
2010-09-17 14:00:00	SPY	ETF	112.52	112.74	112.46	112.64	19440940.0
2010-09-17 15:00:00	SPY	ETF	112.64	112.6699	112.35	112.49	31852811.0
2010-09-17 16:00:00	SPY	ETF	112.49	113.015	112.28	112.39	11900833.0
2010-09-17 17:00:00	SPY	ETF	112.36	112.49	112.23	112.32	1336943.0
2010-09-17 18:00:00	SPY	ETF	112.33	112.34	112.25	112.32	17592.0
2010-09-17 19:00:00	SPY	ETF	112.3	112.31	112.23	112.28	73175.0
2010-09-17 04:00:00	QQQ	ETF	48.36	48.37	48.36	48.37	11435.0
2010-09-17 05:00:00	QQQ	ETF	48.3	48.3	48.26	48.26	650.0
2010-09-17 06:00:00	QQQ	ETF	48.23	48.23	48.14	48.14	3000.0
2010-09-17 07:00:00	QQQ	ETF	48.18	48.24	48.01	48.04	367456.0
2010-09-17 08:00:00	QQQ	ETF	48.04	48.18	47.97	48.08	3557397.0
2010-09-17 09:00:00	QQQ	ETF	48.09	48.18	47.75	47.84	19188882.0
2010-09-17 10:00:00	QQQ	ETF	47.85	48.0	47.77	47.98	13377275.0
2010-09-17 11:00:00	QQQ	ETF	47.98	48.09	47.9	47.95	7982067.0
2010-09-17 12:00:00	QQQ	ETF	47.95	48.08	47.93	47.97	3450874.0
2010-09-17 13:00:00	QQQ	ETF	47.9775	48.04	47.89	48.02	3704581.0
2010-09-17 14:00:00	QQQ	ETF	48.02	48.1	47.99	48.07	3942677.0
2010-09-17 15:00:00	QQQ	ETF	48.06	48.07	47.94	47.98	8977269.0
2010-09-17 16:00:00	QQQ	ETF	47.98	48.04	47.9506	48.0	3774497.0
2010-09-17 17:00:00	QQQ	ETF	48.0	48.04	47.99	48.02	424970.0
2010-09-17 18:00:00	QQQ	ETF	48.02	48.02	47.99	48.0	10200.0
2010-09-17 19:00:00	QQQ	ETF	48.01	48.01	47.98	47.99	23400.0
2010-09-17 06:00:00	IWM	ETF	65.59	65.6	65.5	65.55	52400.0
2010-09-17 07:00:00	IWM	ETF	65.56	65.65	65.39	65.45	146000.0
2010-09-17 08:00:00	IWM	ETF	65.46	65.75	65.26	65.41	2607428.0
2010-09-17 09:00:00	IWM	ETF	65.42	65.52	64.41	64.53	10724382.0
2010-09-17 10:00:00	IWM	ETF	64.53	65.15	64.28	65.12	10242604.0
2010-09-17 11:00:00	IWM	ETF	65.1255	65.42	65.095	65.19	8687944.0
2010-09-17 12:00:00	IWM	ETF	65.2	65.42	65.12	65.175	3454680.0
2010-09-17 13:00:00	IWM	ETF	65.17	65.34	65.1	65.31	2492887.0
2010-09-17 14:00:00	IWM	ETF	65.31	65.52	65.26	65.39	3088491.0
2010-09-17 15:00:00	IWM	ETF	65.39	65.39	65.15	65.19	9570656.0
2010-09-17 16:00:00	IWM	ETF	65.19	65.569	64.6	65.17	6064892.0
2010-09-17 17:00:00	IWM	ETF	65.15	65.16	65.13	65.15	6919.0
2010-09-17 18:00:00	IWM	ETF	65.06	65.17	65.05	65.17	5800.0
2010-09-17 19:00:00	IWM	ETF	65.17	65.17	65.17	65.17	100.0
2010-09-17 07:00:00	DIA	ETF	106.8	106.8	106.44	106.44	1200.0
2010-09-17 08:00:00	DIA	ETF	106.5	106.51	106.29	106.34	35800.0
2010-09-17 09:00:00	DIA	ETF	106.31	106.49	105.76	105.83	1695307.0
2010-09-17 10:00:00	DIA	ETF	105.84	106.04	105.65	105.95	1152955.0

> showing 50 of 5,073 rows — these rows as CSV

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