PREVIEW / etf_1hour / 2010-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-15.parquet
  size:    165 KB
  rows:    4,975

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-06-15 04:00:00	SPY	ETF	109.84	110.14	109.84	110.14	1300.0
2010-06-15 05:00:00	SPY	ETF	110.02	110.5	109.84	110.45	21946.0
2010-06-15 06:00:00	SPY	ETF	110.42	110.47	110.32	110.32	50800.0
2010-06-15 07:00:00	SPY	ETF	110.33	110.4	110.08	110.25	266298.0
2010-06-15 08:00:00	SPY	ETF	110.23	110.43	109.4761	110.21	7593066.0
2010-06-15 09:00:00	SPY	ETF	110.22	110.67	110.09	110.51	29800407.0
2010-06-15 10:00:00	SPY	ETF	110.51	110.8	110.21	110.7684	30653077.0
2010-06-15 11:00:00	SPY	ETF	110.77	110.97	110.56	110.8617	19419489.0
2010-06-15 12:00:00	SPY	ETF	110.869	111.07	110.77	111.04	18094059.0
2010-06-15 13:00:00	SPY	ETF	111.04	111.36	110.84	111.33	22279474.0
2010-06-15 14:00:00	SPY	ETF	111.33	111.73	111.2	111.5	31082740.0
2010-06-15 15:00:00	SPY	ETF	111.5	112.1	111.4	111.98	52918981.0
2010-06-15 16:00:00	SPY	ETF	111.98	112.08	110.15	111.81	23835756.0
2010-06-15 17:00:00	SPY	ETF	111.81	111.95	111.72	111.78	423605.0
2010-06-15 18:00:00	SPY	ETF	111.76	111.95	111.65	111.72	468773.0
2010-06-15 19:00:00	SPY	ETF	111.71	111.72	111.62	111.67	130932.0
2010-06-15 04:00:00	QQQ	ETF	45.78	45.78	45.78	45.78	200.0
2010-06-15 05:00:00	QQQ	ETF	45.72	45.93	45.72	45.93	7300.0
2010-06-15 06:00:00	QQQ	ETF	45.92	45.92	45.85	45.88	71085.0
2010-06-15 07:00:00	QQQ	ETF	45.86	45.91	45.76	45.8	249121.0
2010-06-15 08:00:00	QQQ	ETF	45.79	45.84	45.64	45.66	2451447.0
2010-06-15 09:00:00	QQQ	ETF	45.67	46.21	45.66	46.13	13550835.0
2010-06-15 10:00:00	QQQ	ETF	46.13	46.2	45.9562	46.18	10867429.0
2010-06-15 11:00:00	QQQ	ETF	46.19	46.31	46.0619	46.27	5959404.0
2010-06-15 12:00:00	QQQ	ETF	46.27	46.38	46.25	46.36	6121119.0
2010-06-15 13:00:00	QQQ	ETF	46.36	46.49	45.4532	46.47	8816737.0
2010-06-15 14:00:00	QQQ	ETF	46.47	46.61	46.46	46.525	7249923.0
2010-06-15 15:00:00	QQQ	ETF	46.525	46.77	46.49	46.702	13088055.0
2010-06-15 16:00:00	QQQ	ETF	46.7	46.7536	45.4532	46.63	4314697.0
2010-06-15 17:00:00	QQQ	ETF	46.63	46.64	46.61	46.63	19518.0
2010-06-15 18:00:00	QQQ	ETF	46.62	46.63	46.58	46.58	33406.0
2010-06-15 19:00:00	QQQ	ETF	46.6	46.6	46.55	46.59	67100.0
2010-06-15 04:00:00	IWM	ETF	65.68	65.88	65.68	65.88	2100.0
2010-06-15 05:00:00	IWM	ETF	66.01	66.01	66.01	66.01	3000.0
2010-06-15 06:00:00	IWM	ETF	66.1	66.15	66.1	66.11	12278.0
2010-06-15 07:00:00	IWM	ETF	66.09	66.17	65.92	65.98	118803.0
2010-06-15 08:00:00	IWM	ETF	65.96	66.08	65.76	65.9	480538.0
2010-06-15 09:00:00	IWM	ETF	65.88	66.17	65.67	66.0	10515762.0
2010-06-15 10:00:00	IWM	ETF	66.0	66.03	65.62	66.03	10869469.0
2010-06-15 11:00:00	IWM	ETF	66.03	66.14	65.84	66.07	4884174.0
2010-06-15 12:00:00	IWM	ETF	66.08	66.27	66.05	66.19	4093786.0
2010-06-15 13:00:00	IWM	ETF	66.2	66.39	66.03	66.39	5930421.0
2010-06-15 14:00:00	IWM	ETF	66.38	66.78	66.38	66.58	7432009.0
2010-06-15 15:00:00	IWM	ETF	66.58	67.17	66.48	66.93	18473533.0
2010-06-15 16:00:00	IWM	ETF	66.92	67.1093	65.3555	66.71	6218977.0
2010-06-15 17:00:00	IWM	ETF	66.74	66.74	66.67	66.71	6535.0
2010-06-15 18:00:00	IWM	ETF	66.68	66.73	66.64	66.64	6047.0
2010-06-15 19:00:00	IWM	ETF	66.71	66.71	66.62	66.62	1529.0
2010-06-15 05:00:00	DIA	ETF	102.68	102.78	102.68	102.78	1000.0
2010-06-15 06:00:00	DIA	ETF	102.82	102.83	102.82	102.83	1000.0

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

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