PREVIEW / etf_1hour / 2010-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-30.parquet
  size:    170 KB
  rows:    5,160

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-30 04:00:00	SPY	ETF	114.5	114.5	114.5	114.5	100.0
2010-09-30 05:00:00	SPY	ETF	114.47	114.47	114.39	114.4	3600.0
2010-09-30 06:00:00	SPY	ETF	114.46	114.53	114.25	114.33	18200.0
2010-09-30 07:00:00	SPY	ETF	114.29	114.36	114.26	114.29	166121.0
2010-09-30 08:00:00	SPY	ETF	114.31	114.94	114.22	114.87	3136240.0
2010-09-30 09:00:00	SPY	ETF	114.88	115.79	114.88	115.385	47260694.0
2010-09-30 10:00:00	SPY	ETF	115.38	115.42	114.7	114.7075	43686668.0
2010-09-30 11:00:00	SPY	ETF	114.71	114.76	113.79	114.01	57742897.0
2010-09-30 12:00:00	SPY	ETF	114.01	114.35	113.59	114.3	31089018.0
2010-09-30 13:00:00	SPY	ETF	114.3	114.44	114.18	114.33	15994864.0
2010-09-30 14:00:00	SPY	ETF	114.33	114.64	114.01	114.46	19217654.0
2010-09-30 15:00:00	SPY	ETF	114.4601	114.58	114.1	114.1	44249923.0
2010-09-30 16:00:00	SPY	ETF	114.1	115.425	113.665	114.08	22554706.0
2010-09-30 17:00:00	SPY	ETF	114.07	114.4856	114.02	114.12	1166749.0
2010-09-30 18:00:00	SPY	ETF	114.1	114.12	114.04	114.04	96430.0
2010-09-30 19:00:00	SPY	ETF	114.07	114.24	114.06	114.21	78178.0
2010-09-30 05:00:00	QQQ	ETF	49.37	49.37	49.36	49.37	14080.0
2010-09-30 06:00:00	QQQ	ETF	49.3	49.3	49.3	49.3	100.0
2010-09-30 07:00:00	QQQ	ETF	49.28	49.32	49.26	49.29	163086.0
2010-09-30 08:00:00	QQQ	ETF	49.31	49.55	49.27	49.53	5360025.0
2010-09-30 09:00:00	QQQ	ETF	49.53	49.84	49.495	49.59	18691347.0
2010-09-30 10:00:00	QQQ	ETF	49.6	49.6	49.22	49.22	19552160.0
2010-09-30 11:00:00	QQQ	ETF	49.22	49.27	48.75	48.92	22882131.0
2010-09-30 12:00:00	QQQ	ETF	48.91	49.13	48.75	49.07	10430294.0
2010-09-30 13:00:00	QQQ	ETF	49.0701	49.24	49.03	49.16	8782828.0
2010-09-30 14:00:00	QQQ	ETF	49.17	49.4	49.04	49.3001	9162036.0
2010-09-30 15:00:00	QQQ	ETF	49.31	49.32	49.06	49.06	11063547.0
2010-09-30 16:00:00	QQQ	ETF	49.06	49.3186	49.04	49.05	3313285.0
2010-09-30 17:00:00	QQQ	ETF	49.05	49.3186	49.02	49.06	3608332.0
2010-09-30 18:00:00	QQQ	ETF	49.06	49.06	49.05	49.05	10699.0
2010-09-30 19:00:00	QQQ	ETF	49.05	49.13	49.05	49.1	39154.0
2010-09-30 05:00:00	IWM	ETF	67.58	67.58	67.58	67.58	2900.0
2010-09-30 06:00:00	IWM	ETF	67.59	67.59	67.53	67.53	2200.0
2010-09-30 07:00:00	IWM	ETF	67.54	67.59	67.5	67.5	35500.0
2010-09-30 08:00:00	IWM	ETF	67.59	68.03	67.31	68.0	3496545.0
2010-09-30 09:00:00	IWM	ETF	68.01	68.55	68.0	68.34	13282038.0
2010-09-30 10:00:00	IWM	ETF	68.34	68.365	67.67	67.71	13360889.0
2010-09-30 11:00:00	IWM	ETF	67.71	67.7199	66.95	67.32	15292890.0
2010-09-30 12:00:00	IWM	ETF	67.32	67.6	66.95	67.59	6809715.0
2010-09-30 13:00:00	IWM	ETF	67.59	67.75	67.45	67.625	4871329.0
2010-09-30 14:00:00	IWM	ETF	67.62	67.86	67.38	67.705	3039776.0
2010-09-30 15:00:00	IWM	ETF	67.7	67.83	67.43	67.47	13941934.0
2010-09-30 16:00:00	IWM	ETF	67.48	68.3755	67.4189	67.49	3508705.0
2010-09-30 17:00:00	IWM	ETF	67.48	67.59	67.47	67.54	35600.0
2010-09-30 18:00:00	IWM	ETF	67.5	67.51	67.48	67.5	2900.0
2010-09-30 19:00:00	IWM	ETF	67.48	67.54	67.48	67.54	900.0
2010-09-30 07:00:00	DIA	ETF	108.25	108.28	108.25	108.28	2200.0
2010-09-30 08:00:00	DIA	ETF	108.26	108.79	108.26	108.76	20330.0
2010-09-30 09:00:00	DIA	ETF	108.81	109.52	108.8	109.12	2596897.0
2010-09-30 10:00:00	DIA	ETF	109.14	109.15	108.51	108.54	1800502.0

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

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