PREVIEW / etf_1hour / 2010-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-23.parquet
  size:    156 KB
  rows:    4,834

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-23 04:00:00	SPY	ETF	110.12	110.16	110.0	110.06	23565.0
2010-06-23 05:00:00	SPY	ETF	110.0	110.05	109.95	110.0	18300.0
2010-06-23 06:00:00	SPY	ETF	110.04	110.2	109.97	110.01	13480.0
2010-06-23 07:00:00	SPY	ETF	110.0	110.09	109.9	109.97	460093.0
2010-06-23 08:00:00	SPY	ETF	109.98	110.18	109.91	110.02	1418592.0
2010-06-23 09:00:00	SPY	ETF	110.01	110.02	109.19	109.5225	29831811.0
2010-06-23 10:00:00	SPY	ETF	109.55	109.56	108.48	109.029	50776262.0
2010-06-23 11:00:00	SPY	ETF	109.03	109.09	108.72	108.85	18355289.0
2010-06-23 12:00:00	SPY	ETF	108.8501	109.23	108.75	109.15	14098738.0
2010-06-23 13:00:00	SPY	ETF	109.15	109.3625	109.08	109.31	14809089.0
2010-06-23 14:00:00	SPY	ETF	109.31	110.03	108.89	109.2	52874880.0
2010-06-23 15:00:00	SPY	ETF	109.21	109.59	108.8	109.21	60310063.0
2010-06-23 16:00:00	SPY	ETF	109.21	112.4175	108.67	109.07	8827403.0
2010-06-23 17:00:00	SPY	ETF	109.05	109.08	108.92	108.98	156387.0
2010-06-23 18:00:00	SPY	ETF	108.96	109.26	108.93	108.94	125801.0
2010-06-23 19:00:00	SPY	ETF	108.96	109.08	108.95	109.06	45146.0
2010-06-23 04:00:00	QQQ	ETF	46.42	46.44	46.42	46.42	2033.0
2010-06-23 05:00:00	QQQ	ETF	46.4	46.4	46.4	46.4	13000.0
2010-06-23 06:00:00	QQQ	ETF	46.45	46.47	46.39	46.4	18200.0
2010-06-23 07:00:00	QQQ	ETF	46.39	46.41	46.36	46.36	66879.0
2010-06-23 08:00:00	QQQ	ETF	46.39	46.5	46.37	46.41	717609.0
2010-06-23 09:00:00	QQQ	ETF	46.41	46.41	46.02	46.16	12560839.0
2010-06-23 10:00:00	QQQ	ETF	46.15	46.16	45.69	45.9997	17747045.0
2010-06-23 11:00:00	QQQ	ETF	46.0	46.01	45.82	45.91	5081507.0
2010-06-23 12:00:00	QQQ	ETF	45.905	46.12	45.87	46.0699	3708505.0
2010-06-23 13:00:00	QQQ	ETF	46.07	46.19	46.02	46.16	4215200.0
2010-06-23 14:00:00	QQQ	ETF	46.16	46.47	45.9501	46.06	18973120.0
2010-06-23 15:00:00	QQQ	ETF	46.06	46.23	45.86	46.06	21746550.0
2010-06-23 16:00:00	QQQ	ETF	46.06	46.2265	45.93	45.95	4405897.0
2010-06-23 17:00:00	QQQ	ETF	45.95	45.98	45.86	45.86	374081.0
2010-06-23 18:00:00	QQQ	ETF	45.86	45.91	45.85	45.87	489457.0
2010-06-23 19:00:00	QQQ	ETF	45.86	45.95	45.86	45.95	80250.0
2010-06-23 06:00:00	IWM	ETF	65.03	65.03	64.89	64.93	4808.0
2010-06-23 07:00:00	IWM	ETF	64.93	64.99	64.8	64.95	247278.0
2010-06-23 08:00:00	IWM	ETF	64.93	65.08	64.89	64.96	446341.0
2010-06-23 09:00:00	IWM	ETF	64.96	64.96	64.31	64.64	8026391.0
2010-06-23 10:00:00	IWM	ETF	64.63	64.64	63.81	64.46	14122491.0
2010-06-23 11:00:00	IWM	ETF	64.46	64.58	64.22	64.46	5841074.0
2010-06-23 12:00:00	IWM	ETF	64.45	64.74	64.37	64.7	3432024.0
2010-06-23 13:00:00	IWM	ETF	64.69	64.91	64.65	64.86	4497459.0
2010-06-23 14:00:00	IWM	ETF	64.86	65.26	64.46	64.63	12514079.0
2010-06-23 15:00:00	IWM	ETF	64.63	64.85	64.3	64.59	14385468.0
2010-06-23 16:00:00	IWM	ETF	64.59	64.85	64.32	64.32	3757532.0
2010-06-23 17:00:00	IWM	ETF	64.36	64.37	64.31	64.35	8100.0
2010-06-23 18:00:00	IWM	ETF	64.35	64.45	64.22	64.38	23476.0
2010-06-23 19:00:00	IWM	ETF	64.44	64.44	64.35	64.41	3087.0
2010-06-23 06:00:00	DIA	ETF	103.45	103.45	103.45	103.45	100.0
2010-06-23 07:00:00	DIA	ETF	103.38	103.4	103.34	103.34	1300.0
2010-06-23 08:00:00	DIA	ETF	103.34	103.49	103.33	103.42	19015.0
2010-06-23 09:00:00	DIA	ETF	103.4	103.4	102.771	103.17	2042414.0

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

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