PREVIEW / etf_1hour / 2010-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-07.parquet
  size:    176 KB
  rows:    5,362

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-05-07 04:00:00	SPY	ETF	113.0	113.73	113.0	113.09	24490.0
2010-05-07 05:00:00	SPY	ETF	113.02	113.38	112.76	113.22	16370.0
2010-05-07 06:00:00	SPY	ETF	113.32	113.88	113.28	113.82	222920.0
2010-05-07 07:00:00	SPY	ETF	113.82	113.89	113.04	113.1	2666139.0
2010-05-07 08:00:00	SPY	ETF	113.1	114.1	112.0	113.37	18307644.0
2010-05-07 09:00:00	SPY	ETF	113.37	113.77	112.15	112.52	72851135.0
2010-05-07 10:00:00	SPY	ETF	112.51	113.35	109.58	110.96	147504305.0
2010-05-07 11:00:00	SPY	ETF	110.96	113.0895	110.55	112.41	108519170.0
2010-05-07 12:00:00	SPY	ETF	112.41	113.26	109.41	111.94	58892955.0
2010-05-07 13:00:00	SPY	ETF	111.94	112.47	111.29	111.99	46734555.0
2010-05-07 14:00:00	SPY	ETF	111.99	112.18	111.13	111.5	46213183.0
2010-05-07 15:00:00	SPY	ETF	111.5	111.58	110.55	111.3	99273572.0
2010-05-07 16:00:00	SPY	ETF	111.18	113.2	110.5804	111.63	26475383.0
2010-05-07 17:00:00	SPY	ETF	111.64	111.91	111.57	111.6	3625609.0
2010-05-07 18:00:00	SPY	ETF	111.58	111.65	111.3	111.4	467503.0
2010-05-07 19:00:00	SPY	ETF	111.44	111.86	111.4	111.79	284399.0
2010-05-07 04:00:00	QQQ	ETF	46.7	46.75	46.6	46.6	5250.0
2010-05-07 05:00:00	QQQ	ETF	46.58	46.64	46.46	46.64	1500.0
2010-05-07 06:00:00	QQQ	ETF	46.69	46.98	46.69	46.93	23713.0
2010-05-07 07:00:00	QQQ	ETF	46.94	46.94	46.64	46.64	815601.0
2010-05-07 08:00:00	QQQ	ETF	46.6	47.0	46.52	46.62	6485891.0
2010-05-07 09:00:00	QQQ	ETF	46.63	46.8	45.91	46.11	37786894.0
2010-05-07 10:00:00	QQQ	ETF	46.1199	46.2	44.47	45.421	81207976.0
2010-05-07 11:00:00	QQQ	ETF	45.43	46.37	45.19	46.08	48208585.0
2010-05-07 12:00:00	QQQ	ETF	46.07	46.4	45.78	45.8401	17544303.0
2010-05-07 13:00:00	QQQ	ETF	45.85	46.04	45.61	45.8	17544924.0
2010-05-07 14:00:00	QQQ	ETF	45.8062	45.89	45.42	45.59	17528863.0
2010-05-07 15:00:00	QQQ	ETF	45.6	45.64	44.2833	45.48	37715609.0
2010-05-07 16:00:00	QQQ	ETF	45.47	46.5859	45.25	45.63	11185375.0
2010-05-07 17:00:00	QQQ	ETF	45.62	45.7	45.62	45.62	52837.0
2010-05-07 18:00:00	QQQ	ETF	45.62	45.63	45.5	45.55	103284.0
2010-05-07 19:00:00	QQQ	ETF	45.56	45.7	45.55	45.67	21974.0
2010-05-07 04:00:00	IWM	ETF	67.45	67.47	67.42	67.42	5400.0
2010-05-07 06:00:00	IWM	ETF	67.25	67.51	67.25	67.47	33200.0
2010-05-07 07:00:00	IWM	ETF	67.48	67.55	67.13	67.14	187517.0
2010-05-07 08:00:00	IWM	ETF	67.14	67.69	66.89	67.35	3211825.0
2010-05-07 09:00:00	IWM	ETF	67.35	67.62	66.23	66.82	25564021.0
2010-05-07 10:00:00	IWM	ETF	66.83	66.9	64.64	65.61	44131724.0
2010-05-07 11:00:00	IWM	ETF	65.6	67.23	65.52	66.4	26718983.0
2010-05-07 12:00:00	IWM	ETF	66.39	67.15	66.02	66.04	17553053.0
2010-05-07 13:00:00	IWM	ETF	66.04	66.61	65.59	66.07	14246157.0
2010-05-07 14:00:00	IWM	ETF	66.08	66.23	65.45	65.61	11182695.0
2010-05-07 15:00:00	IWM	ETF	65.62	65.71	65.14	65.39	32246988.0
2010-05-07 16:00:00	IWM	ETF	65.39	67.3063	65.19	65.44	6088564.0
2010-05-07 17:00:00	IWM	ETF	65.48	65.55	65.44	65.45	16215.0
2010-05-07 18:00:00	IWM	ETF	65.65	65.65	65.39	65.39	2550.0
2010-05-07 19:00:00	IWM	ETF	65.6	66.25	65.49	66.25	10562.0
2010-05-07 04:00:00	DIA	ETF	105.36	105.81	105.36	105.7	25201.0
2010-05-07 05:00:00	DIA	ETF	105.07	105.07	105.0	105.0	10000.0
2010-05-07 06:00:00	DIA	ETF	105.5	105.81	105.5	105.81	24796.0

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

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