PREVIEW / etf_1hour / 2010-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-18.parquet
  size:    151 KB
  rows:    4,718

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-03-18 04:00:00	SPY	ETF	116.76	116.88	116.74	116.88	2000.0
2010-03-18 05:00:00	SPY	ETF	116.76	116.9	116.76	116.9	4100.0
2010-03-18 06:00:00	SPY	ETF	116.9	116.95	116.82	116.93	27700.0
2010-03-18 07:00:00	SPY	ETF	116.93	116.98	116.89	116.95	260679.0
2010-03-18 08:00:00	SPY	ETF	116.96	117.18	116.9	117.04	1742723.0
2010-03-18 09:00:00	SPY	ETF	117.05	117.2	116.97	117.13	17631000.0
2010-03-18 10:00:00	SPY	ETF	117.13	117.27	116.82	117.0501	28143721.0
2010-03-18 11:00:00	SPY	ETF	117.06	117.1706	116.71	116.76	26730820.0
2010-03-18 12:00:00	SPY	ETF	116.765	116.78	116.57	116.7	23588492.0
2010-03-18 13:00:00	SPY	ETF	116.71	116.99	116.7	116.9	14681317.0
2010-03-18 14:00:00	SPY	ETF	116.9	117.08	116.78	116.9	25107781.0
2010-03-18 15:00:00	SPY	ETF	116.9	117.13	116.83	117.03	32222058.0
2010-03-18 16:00:00	SPY	ETF	117.03	117.14	116.61	117.11	14774508.0
2010-03-18 17:00:00	SPY	ETF	117.1	117.13	117.05	117.05	7213455.0
2010-03-18 18:00:00	SPY	ETF	117.06	117.11	117.05	117.06	54238.0
2010-03-18 19:00:00	SPY	ETF	117.06	117.12	117.0	117.0	155583.0
2010-03-18 04:00:00	QQQ	ETF	47.56	47.56	47.56	47.56	1000.0
2010-03-18 06:00:00	QQQ	ETF	47.6	47.65	47.59	47.65	5905.0
2010-03-18 07:00:00	QQQ	ETF	47.64	47.66	47.64	47.66	21200.0
2010-03-18 08:00:00	QQQ	ETF	47.65	47.74	47.55	47.69	445583.0
2010-03-18 09:00:00	QQQ	ETF	47.69	47.76	47.45	47.71	8546993.0
2010-03-18 10:00:00	QQQ	ETF	47.7	47.77	47.62	47.75	8759637.0
2010-03-18 11:00:00	QQQ	ETF	47.75	47.83	47.6319	47.69	10847801.0
2010-03-18 12:00:00	QQQ	ETF	47.69	47.725	47.6	47.715	5735025.0
2010-03-18 13:00:00	QQQ	ETF	47.72	47.82	47.71	47.7899	7535668.0
2010-03-18 14:00:00	QQQ	ETF	47.78	47.85	47.7	47.779	9194219.0
2010-03-18 15:00:00	QQQ	ETF	47.77	47.88	47.72	47.82	12555327.0
2010-03-18 16:00:00	QQQ	ETF	47.82	47.89	47.6561	47.85	2786288.0
2010-03-18 17:00:00	QQQ	ETF	47.84	47.87	47.6561	47.86	9077072.0
2010-03-18 18:00:00	QQQ	ETF	47.86	47.86	47.82	47.83	32241.0
2010-03-18 19:00:00	QQQ	ETF	47.83	47.84	47.77	47.78	43125.0
2010-03-18 07:00:00	IWM	ETF	68.37	68.38	68.37	68.38	10200.0
2010-03-18 08:00:00	IWM	ETF	68.41	68.51	68.37	68.45	467016.0
2010-03-18 09:00:00	IWM	ETF	68.44	68.56	67.95	68.48	5434312.0
2010-03-18 10:00:00	IWM	ETF	68.47	68.65	68.34	68.64	12070834.0
2010-03-18 11:00:00	IWM	ETF	68.64	68.78	68.39	68.3901	9113539.0
2010-03-18 12:00:00	IWM	ETF	68.395	68.3974	68.2	68.24	6343408.0
2010-03-18 13:00:00	IWM	ETF	68.25	68.5059	68.24	68.34	6035790.0
2010-03-18 14:00:00	IWM	ETF	68.34	68.49	68.15	68.24	7151378.0
2010-03-18 15:00:00	IWM	ETF	68.238	68.39	68.14	68.27	9468597.0
2010-03-18 16:00:00	IWM	ETF	68.26	68.7	68.17	68.17	4000701.0
2010-03-18 17:00:00	IWM	ETF	68.19	68.19	68.14	68.14	3110.0
2010-03-18 18:00:00	IWM	ETF	68.14	68.17	68.1	68.1	6000.0
2010-03-18 19:00:00	IWM	ETF	68.12	68.2	68.02	68.02	1600.0
2010-03-18 07:00:00	DIA	ETF	107.48	107.48	107.46	107.46	1200.0
2010-03-18 08:00:00	DIA	ETF	107.53	107.61	107.44	107.55	11400.0
2010-03-18 09:00:00	DIA	ETF	107.53	107.78	107.5	107.76	921560.0
2010-03-18 10:00:00	DIA	ETF	107.75	107.86	107.56	107.78	1038770.0
2010-03-18 11:00:00	DIA	ETF	107.78	107.88	107.51	107.56	1166631.0
2010-03-18 12:00:00	DIA	ETF	107.55	107.68	107.4607	107.68	723347.0

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

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