PREVIEW / etf_1hour / 2016-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-12.parquet
  size:    257 KB
  rows:    8,211

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
2016-02-12 04:00:00	SPY	ETF	184.35	184.85	184.1	184.54	46755.0
2016-02-12 05:00:00	SPY	ETF	184.61	184.87	184.33	184.39	50287.0
2016-02-12 06:00:00	SPY	ETF	184.35	185.35	184.35	185.17	195887.0
2016-02-12 07:00:00	SPY	ETF	185.17	185.17	184.61	184.73	375763.0
2016-02-12 08:00:00	SPY	ETF	184.73	185.43	182.86	185.02	2114113.0
2016-02-12 09:00:00	SPY	ETF	185.04	185.15	184.13	184.29	16992612.0
2016-02-12 10:00:00	SPY	ETF	184.3	185.13	183.96	184.74	20302823.0
2016-02-12 11:00:00	SPY	ETF	184.74	186.13	184.74	185.62	19074956.0
2016-02-12 12:00:00	SPY	ETF	185.62	185.99	185.53	185.69	9092576.0
2016-02-12 13:00:00	SPY	ETF	185.68	185.87	185.16	185.45	10271102.0
2016-02-12 14:00:00	SPY	ETF	185.46	186.35	185.39	186.1858	12108895.0
2016-02-12 15:00:00	SPY	ETF	186.18	186.65	186.03	186.64	24212028.0
2016-02-12 16:00:00	SPY	ETF	186.65	186.65	185.35	186.56	8212406.0
2016-02-12 17:00:00	SPY	ETF	186.54	186.57	186.45	186.55	152702.0
2016-02-12 18:00:00	SPY	ETF	186.55	186.59	186.5	186.55	20355.0
2016-02-12 19:00:00	SPY	ETF	186.58	186.75	186.53	186.74	48814.0
2016-02-12 04:00:00	QQQ	ETF	97.4	97.7	97.36	97.57	8372.0
2016-02-12 05:00:00	QQQ	ETF	97.62	97.62	97.48	97.48	7300.0
2016-02-12 06:00:00	QQQ	ETF	97.45	97.9	97.45	97.88	18855.0
2016-02-12 07:00:00	QQQ	ETF	97.8	97.8	97.5	97.59	28643.0
2016-02-12 08:00:00	QQQ	ETF	97.52	97.94	96.55	97.68	200360.0
2016-02-12 09:00:00	QQQ	ETF	97.65	97.79	96.79	96.8599	5661916.0
2016-02-12 10:00:00	QQQ	ETF	96.83	97.4	96.73	97.05	5346405.0
2016-02-12 11:00:00	QQQ	ETF	97.06	98.06	97.06	97.64	6536687.0
2016-02-12 12:00:00	QQQ	ETF	97.65	97.872	97.59	97.61	3334488.0
2016-02-12 13:00:00	QQQ	ETF	97.61	97.645	97.14	97.36	3602671.0
2016-02-12 14:00:00	QQQ	ETF	97.36	98.02	97.33	97.87	3794707.0
2016-02-12 15:00:00	QQQ	ETF	97.87	98.12	97.74	98.02	7143188.0
2016-02-12 16:00:00	QQQ	ETF	98.02	98.0492	97.74	98.04	1148407.0
2016-02-12 17:00:00	QQQ	ETF	98.0	98.01	97.9	97.93	17530.0
2016-02-12 18:00:00	QQQ	ETF	97.92	97.98	97.92	97.92	661.0
2016-02-12 19:00:00	QQQ	ETF	97.93	98.03	97.9	98.0	11074.0
2016-02-12 04:00:00	IWM	ETF	95.0	95.54	95.0	95.54	2200.0
2016-02-12 05:00:00	IWM	ETF	95.54	95.6	95.54	95.6	200.0
2016-02-12 06:00:00	IWM	ETF	95.43	96.06	95.43	95.95	33400.0
2016-02-12 07:00:00	IWM	ETF	95.9	95.92	95.67	95.8	30531.0
2016-02-12 08:00:00	IWM	ETF	95.7	96.0	95.43	95.69	258894.0
2016-02-12 09:00:00	IWM	ETF	95.74	96.0	95.27	95.37	4486953.0
2016-02-12 10:00:00	IWM	ETF	95.34	95.855	95.19	95.37	5871784.0
2016-02-12 11:00:00	IWM	ETF	95.3789	96.5	95.3789	96.05	6086550.0
2016-02-12 12:00:00	IWM	ETF	96.07	96.35	95.98	96.15	2949546.0
2016-02-12 13:00:00	IWM	ETF	96.17	96.25	95.86	96.04	2310978.0
2016-02-12 14:00:00	IWM	ETF	96.025	96.775	96.0	96.65	3420621.0
2016-02-12 15:00:00	IWM	ETF	96.66	96.79	96.35	96.59	7205370.0
2016-02-12 16:00:00	IWM	ETF	96.6	96.6345	96.2	96.54	2347150.0
2016-02-12 17:00:00	IWM	ETF	96.47	96.49	96.42	96.43	22408.0
2016-02-12 18:00:00	IWM	ETF	96.43	96.43	96.41	96.41	1210.0
2016-02-12 19:00:00	IWM	ETF	96.42	96.49	96.41	96.49	5682.0
2016-02-12 04:00:00	DIA	ETF	157.76	157.76	157.76	157.76	100.0
2016-02-12 07:00:00	DIA	ETF	158.31	158.36	158.31	158.36	1250.0

> showing 50 of 8,211 rows — these rows as CSV

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