PREVIEW / etf_1hour / 2010-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-09.parquet
  size:    153 KB
  rows:    4,726

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-07-09 04:00:00	SPY	ETF	107.29	107.29	107.14	107.14	2300.0
2010-07-09 05:00:00	SPY	ETF	107.02	107.16	107.02	107.16	600.0
2010-07-09 06:00:00	SPY	ETF	107.15	107.22	107.06	107.06	7800.0
2010-07-09 07:00:00	SPY	ETF	107.06	107.38	107.06	107.16	457128.0
2010-07-09 08:00:00	SPY	ETF	107.17	107.32	106.85	107.04	1349380.0
2010-07-09 09:00:00	SPY	ETF	107.03	107.35	106.93	107.1725	20855993.0
2010-07-09 10:00:00	SPY	ETF	107.17	107.69	107.145	107.33	26569547.0
2010-07-09 11:00:00	SPY	ETF	107.32	107.44	107.07	107.25	13980412.0
2010-07-09 12:00:00	SPY	ETF	107.23	107.44	107.18	107.33	8699029.0
2010-07-09 13:00:00	SPY	ETF	107.33	107.52	107.25	107.48	11301392.0
2010-07-09 14:00:00	SPY	ETF	107.47	107.86	107.3	107.79	15488054.0
2010-07-09 15:00:00	SPY	ETF	107.79	107.97	107.56	107.92	32272975.0
2010-07-09 16:00:00	SPY	ETF	107.94	107.99	107.035	107.7	8298451.0
2010-07-09 17:00:00	SPY	ETF	107.69	107.71	107.61	107.7	144798.0
2010-07-09 18:00:00	SPY	ETF	107.7	107.93	107.61	107.7	36294.0
2010-07-09 19:00:00	SPY	ETF	107.7	107.74	107.6	107.7	33006.0
2010-07-09 05:00:00	QQQ	ETF	44.19	44.2	44.19	44.2	300.0
2010-07-09 06:00:00	QQQ	ETF	44.23	44.23	44.21	44.21	3700.0
2010-07-09 07:00:00	QQQ	ETF	44.24	44.28	44.21	44.21	89746.0
2010-07-09 08:00:00	QQQ	ETF	44.2	44.26	44.04	44.11	451269.0
2010-07-09 09:00:00	QQQ	ETF	44.11	44.36	44.08	44.2604	6156915.0
2010-07-09 10:00:00	QQQ	ETF	44.26	44.48	44.2066	44.34	10197081.0
2010-07-09 11:00:00	QQQ	ETF	44.34	44.45	44.26	44.3201	5332100.0
2010-07-09 12:00:00	QQQ	ETF	44.33	44.41	44.28	44.34	2894637.0
2010-07-09 13:00:00	QQQ	ETF	44.33	44.4	44.28	44.38	3999124.0
2010-07-09 14:00:00	QQQ	ETF	44.38	44.52	44.3	44.5	4646868.0
2010-07-09 15:00:00	QQQ	ETF	44.5	44.63	44.43	44.6	10628141.0
2010-07-09 16:00:00	QQQ	ETF	44.61	44.68	44.4863	44.6	2437403.0
2010-07-09 17:00:00	QQQ	ETF	44.6	44.6	44.56	44.56	10622.0
2010-07-09 18:00:00	QQQ	ETF	44.59	44.59	44.58	44.59	2747.0
2010-07-09 19:00:00	QQQ	ETF	44.59	44.62	44.57	44.58	7997.0
2010-07-09 04:00:00	IWM	ETF	62.1	62.1	62.1	62.1	400.0
2010-07-09 05:00:00	IWM	ETF	62.01	62.01	62.01	62.01	400.0
2010-07-09 07:00:00	IWM	ETF	62.09	62.13	61.94	61.94	53900.0
2010-07-09 08:00:00	IWM	ETF	61.97	62.0	61.73	61.83	292083.0
2010-07-09 09:00:00	IWM	ETF	61.84	62.3	61.77	62.1	4420133.0
2010-07-09 10:00:00	IWM	ETF	62.09	62.6	61.98	62.3	6641056.0
2010-07-09 11:00:00	IWM	ETF	62.3	62.4	62.04	62.14	3838769.0
2010-07-09 12:00:00	IWM	ETF	62.15	62.27	62.06	62.18	2229596.0
2010-07-09 13:00:00	IWM	ETF	62.18	62.3501	62.159	62.3199	2185652.0
2010-07-09 14:00:00	IWM	ETF	62.31	62.69	62.21	62.65	3427739.0
2010-07-09 15:00:00	IWM	ETF	62.66	62.93	62.49	62.92	10519140.0
2010-07-09 16:00:00	IWM	ETF	62.93	62.94	62.01	62.73	2245177.0
2010-07-09 17:00:00	IWM	ETF	62.72	62.73	62.72	62.72	400.0
2010-07-09 19:00:00	IWM	ETF	62.77	62.81	62.76	62.76	700.0
2010-07-09 06:00:00	DIA	ETF	101.39	101.39	101.39	101.39	100.0
2010-07-09 07:00:00	DIA	ETF	101.4	101.54	101.4	101.44	5370.0
2010-07-09 08:00:00	DIA	ETF	101.44	101.45	101.18	101.33	32908.0
2010-07-09 09:00:00	DIA	ETF	101.35	101.63	101.28	101.52	1006242.0
2010-07-09 10:00:00	DIA	ETF	101.5	101.95	101.48	101.63	1889216.0

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

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