PREVIEW / etf_1hour / 2010-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-04.parquet
  size:    160 KB
  rows:    4,923

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-08-04 04:00:00	SPY	ETF	112.15	112.15	111.85	111.94	1870.0
2010-08-04 05:00:00	SPY	ETF	111.84	111.84	111.76	111.76	2550.0
2010-08-04 06:00:00	SPY	ETF	111.92	112.08	111.92	112.03	8200.0
2010-08-04 07:00:00	SPY	ETF	112.04	112.21	112.01	112.07	516555.0
2010-08-04 08:00:00	SPY	ETF	112.08	112.66	111.94	112.53	2922877.0
2010-08-04 09:00:00	SPY	ETF	112.54	112.73	112.35	112.69	15985333.0
2010-08-04 10:00:00	SPY	ETF	112.7	113.03	112.16	112.41	41305743.0
2010-08-04 11:00:00	SPY	ETF	112.41	112.78	112.33	112.61	12710184.0
2010-08-04 12:00:00	SPY	ETF	112.6075	112.93	112.55	112.75	12640487.0
2010-08-04 13:00:00	SPY	ETF	112.74	112.79	112.45	112.589	11138940.0
2010-08-04 14:00:00	SPY	ETF	112.58	112.91	112.54	112.84	14837065.0
2010-08-04 15:00:00	SPY	ETF	112.83	113.11	112.75	112.97	28917916.0
2010-08-04 16:00:00	SPY	ETF	112.98	113.07	112.165	113.03	14081279.0
2010-08-04 17:00:00	SPY	ETF	113.03	113.03	112.9	112.95	216488.0
2010-08-04 18:00:00	SPY	ETF	112.95	112.97	112.85	112.86	117129.0
2010-08-04 19:00:00	SPY	ETF	112.85	113.0	112.82	112.99	59707.0
2010-08-04 04:00:00	QQQ	ETF	46.49	46.49	46.41	46.41	2900.0
2010-08-04 05:00:00	QQQ	ETF	46.36	46.36	46.36	46.36	200.0
2010-08-04 06:00:00	QQQ	ETF	46.43	46.43	46.43	46.43	100.0
2010-08-04 07:00:00	QQQ	ETF	46.45	46.56	46.44	46.48	317212.0
2010-08-04 08:00:00	QQQ	ETF	46.48	46.76	46.45	46.69	972602.0
2010-08-04 09:00:00	QQQ	ETF	46.7	46.89	46.64	46.7896	6239845.0
2010-08-04 10:00:00	QQQ	ETF	46.79	46.93	46.5	46.63	12250424.0
2010-08-04 11:00:00	QQQ	ETF	46.63	46.84	46.6	46.745	4470054.0
2010-08-04 12:00:00	QQQ	ETF	46.74	46.96	46.73	46.87	3396567.0
2010-08-04 13:00:00	QQQ	ETF	46.875	46.8999	46.71	46.78	4097781.0
2010-08-04 14:00:00	QQQ	ETF	46.78	46.92	46.77	46.88	3601666.0
2010-08-04 15:00:00	QQQ	ETF	46.875	46.99	46.815	46.9399	6996840.0
2010-08-04 16:00:00	QQQ	ETF	46.93	46.9501	46.9	46.94	1319370.0
2010-08-04 17:00:00	QQQ	ETF	46.91	46.92	46.86	46.92	37895.0
2010-08-04 18:00:00	QQQ	ETF	46.89	46.9	46.85	46.86	20253.0
2010-08-04 19:00:00	QQQ	ETF	46.86	46.92	46.86	46.89	3841.0
2010-08-04 05:00:00	IWM	ETF	65.33	65.41	65.32	65.41	3100.0
2010-08-04 06:00:00	IWM	ETF	65.42	65.56	65.42	65.56	3700.0
2010-08-04 07:00:00	IWM	ETF	65.5	65.66	65.44	65.46	38847.0
2010-08-04 08:00:00	IWM	ETF	65.46	66.01	65.39	65.9	306488.0
2010-08-04 09:00:00	IWM	ETF	65.91	66.27	65.84	66.13	4203523.0
2010-08-04 10:00:00	IWM	ETF	66.15	66.48	65.715	65.96	8361403.0
2010-08-04 11:00:00	IWM	ETF	65.96	66.28	65.85	66.09	3856568.0
2010-08-04 12:00:00	IWM	ETF	66.09	66.37	66.02	66.14	3910306.0
2010-08-04 13:00:00	IWM	ETF	66.15	66.19	65.85	65.98	3688328.0
2010-08-04 14:00:00	IWM	ETF	65.99	66.25	65.8417	66.14	3480096.0
2010-08-04 15:00:00	IWM	ETF	66.14	66.3	66.02	66.3	6331879.0
2010-08-04 16:00:00	IWM	ETF	66.3	66.37	65.5724	66.35	3801588.0
2010-08-04 17:00:00	IWM	ETF	66.33	66.33	66.26	66.28	22759.0
2010-08-04 18:00:00	IWM	ETF	66.29	66.29	66.29	66.29	300.0
2010-08-04 19:00:00	IWM	ETF	66.29	66.29	66.29	66.29	400.0
2010-08-04 07:00:00	DIA	ETF	106.37	106.37	106.37	106.37	1000.0
2010-08-04 08:00:00	DIA	ETF	106.31	106.81	106.22	106.72	189726.0
2010-08-04 09:00:00	DIA	ETF	106.71	106.89	106.5	106.89	925734.0

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

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