PREVIEW / etf_1hour / 2013-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-27.parquet
  size:    207 KB
  rows:    6,515

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
2013-06-27 04:00:00	SPY	ETF	160.11	160.27	160.05	160.15	42833.0
2013-06-27 05:00:00	SPY	ETF	160.1	160.34	160.05	160.34	5200.0
2013-06-27 06:00:00	SPY	ETF	160.32	160.37	160.21	160.25	89750.0
2013-06-27 07:00:00	SPY	ETF	160.22	160.84	160.17	160.69	702377.0
2013-06-27 08:00:00	SPY	ETF	160.24	161.03	160.21	160.94	1531662.0
2013-06-27 09:00:00	SPY	ETF	160.93	161.53	160.91	161.47	19368613.0
2013-06-27 10:00:00	SPY	ETF	161.465	161.82	161.135	161.55	27368118.0
2013-06-27 11:00:00	SPY	ETF	161.56	161.8	161.23	161.49	14675656.0
2013-06-27 12:00:00	SPY	ETF	161.49	161.53	160.95	161.26	13151691.0
2013-06-27 13:00:00	SPY	ETF	161.26	161.66	161.19	161.27	10990635.0
2013-06-27 14:00:00	SPY	ETF	161.27	161.47	161.1	161.23	13191631.0
2013-06-27 15:00:00	SPY	ETF	161.23	161.42	161.06	161.13	22514339.0
2013-06-27 16:00:00	SPY	ETF	161.11	161.4	161.02	161.08	4420724.0
2013-06-27 17:00:00	SPY	ETF	161.05	161.12	161.02	161.05	77436.0
2013-06-27 18:00:00	SPY	ETF	161.04	161.19	161.0	161.11	82941.0
2013-06-27 19:00:00	SPY	ETF	161.11	161.15	161.01	161.02	42151.0
2013-06-27 04:00:00	QQQ	ETF	70.84	70.92	70.83	70.88	6800.0
2013-06-27 05:00:00	QQQ	ETF	70.86	70.92	70.8	70.92	8000.0
2013-06-27 06:00:00	QQQ	ETF	70.9	70.94	70.88	70.88	4500.0
2013-06-27 07:00:00	QQQ	ETF	70.86	71.12	70.86	71.08	24300.0
2013-06-27 08:00:00	QQQ	ETF	71.09	71.21	71.06	71.14	40447.0
2013-06-27 09:00:00	QQQ	ETF	71.16	71.47	71.16	71.46	3933442.0
2013-06-27 10:00:00	QQQ	ETF	71.45	71.62	71.27	71.491	5791093.0
2013-06-27 11:00:00	QQQ	ETF	71.495	71.58	71.3	71.42	2410144.0
2013-06-27 12:00:00	QQQ	ETF	71.42	71.43	71.26	71.32	2665045.0
2013-06-27 13:00:00	QQQ	ETF	71.3284	71.455	71.29	71.32	1675931.0
2013-06-27 14:00:00	QQQ	ETF	71.329	71.33	71.13	71.19	2128818.0
2013-06-27 15:00:00	QQQ	ETF	71.19	71.3099	71.13	71.18	3208099.0
2013-06-27 16:00:00	QQQ	ETF	71.18	71.361	71.1355	71.18	1338170.0
2013-06-27 17:00:00	QQQ	ETF	71.18	71.3599	71.15	71.15	88395.0
2013-06-27 18:00:00	QQQ	ETF	71.15	71.21	71.15	71.21	390.0
2013-06-27 19:00:00	QQQ	ETF	71.19	71.19	71.16	71.16	1480.0
2013-06-27 05:00:00	IWM	ETF	96.07	96.07	96.07	96.07	200.0
2013-06-27 06:00:00	IWM	ETF	96.0	96.12	96.0	96.09	1200.0
2013-06-27 07:00:00	IWM	ETF	96.06	96.57	96.06	96.46	152999.0
2013-06-27 08:00:00	IWM	ETF	96.45	96.63	96.03	96.03	1839611.0
2013-06-27 09:00:00	IWM	ETF	96.55	97.0	96.54	96.93	3701321.0
2013-06-27 10:00:00	IWM	ETF	96.93	97.21	96.66	97.08	4291256.0
2013-06-27 11:00:00	IWM	ETF	97.08	97.36	97.02	97.27	3499697.0
2013-06-27 12:00:00	IWM	ETF	97.28	97.41	97.14	97.34	3303610.0
2013-06-27 13:00:00	IWM	ETF	97.35	97.68	97.325	97.43	3349848.0
2013-06-27 14:00:00	IWM	ETF	97.44	97.66	97.345	97.52	3580582.0
2013-06-27 15:00:00	IWM	ETF	97.5297	97.74	97.41	97.6	8266135.0
2013-06-27 16:00:00	IWM	ETF	97.6	97.6391	97.5	97.57	4028621.0
2013-06-27 17:00:00	IWM	ETF	97.58	97.6074	97.57	97.6	513700.0
2013-06-27 18:00:00	IWM	ETF	97.56	97.63	97.56	97.63	2600.0
2013-06-27 19:00:00	IWM	ETF	97.59	97.61	97.57	97.61	2100.0
2013-06-27 04:00:00	DIA	ETF	148.8	148.8	148.8	148.8	100.0
2013-06-27 06:00:00	DIA	ETF	148.95	148.95	148.95	148.95	234.0
2013-06-27 07:00:00	DIA	ETF	149.25	149.25	149.25	149.25	1100.0

> showing 50 of 6,515 rows — these rows as CSV

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