PREVIEW / etf_1hour / 2016-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-02.parquet
  size:    250 KB
  rows:    7,987

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-03-02 04:00:00	SPY	ETF	198.6	198.6	197.89	197.92	36797.0
2016-03-02 05:00:00	SPY	ETF	197.89	198.04	197.8	197.83	15494.0
2016-03-02 06:00:00	SPY	ETF	197.83	198.03	197.83	197.96	52740.0
2016-03-02 07:00:00	SPY	ETF	198.02	198.25	197.78	198.07	192308.0
2016-03-02 08:00:00	SPY	ETF	197.9	198.21	197.74	197.82	896435.0
2016-03-02 09:00:00	SPY	ETF	197.81	198.09	197.44	197.65	13620633.0
2016-03-02 10:00:00	SPY	ETF	197.66	198.25	197.25	198.03	16522662.0
2016-03-02 11:00:00	SPY	ETF	198.03	198.47	197.71	197.73	11872162.0
2016-03-02 12:00:00	SPY	ETF	197.73	198.18	197.55	198.12	6655482.0
2016-03-02 13:00:00	SPY	ETF	198.1225	198.45	197.98	198.0001	7394834.0
2016-03-02 14:00:00	SPY	ETF	198.005	198.645	197.76	198.46	11151456.0
2016-03-02 15:00:00	SPY	ETF	198.45	199.06	198.17	199.0	21897518.0
2016-03-02 16:00:00	SPY	ETF	199.01	199.09	198.0504	198.88	9317498.0
2016-03-02 17:00:00	SPY	ETF	198.86	198.93	198.83	198.84	112124.0
2016-03-02 18:00:00	SPY	ETF	198.83	198.83	198.51	198.58	187630.0
2016-03-02 19:00:00	SPY	ETF	198.68	198.86	198.59	198.86	77346.0
2016-03-02 04:00:00	QQQ	ETF	106.02	106.02	105.78	105.81	1200.0
2016-03-02 05:00:00	QQQ	ETF	105.78	105.78	105.78	105.78	755.0
2016-03-02 06:00:00	QQQ	ETF	105.75	105.75	105.75	105.75	100.0
2016-03-02 07:00:00	QQQ	ETF	105.75	105.88	105.73	105.83	2505.0
2016-03-02 08:00:00	QQQ	ETF	105.81	105.89	105.64	105.68	140892.0
2016-03-02 09:00:00	QQQ	ETF	105.66	105.805	105.275	105.45	3887616.0
2016-03-02 10:00:00	QQQ	ETF	105.46	105.85	105.22	105.56	5076434.0
2016-03-02 11:00:00	QQQ	ETF	105.55	105.73	105.07	105.1	3868691.0
2016-03-02 12:00:00	QQQ	ETF	105.09	105.335	105.01	105.31	2997243.0
2016-03-02 13:00:00	QQQ	ETF	105.312	105.81	105.15	105.165	1974411.0
2016-03-02 14:00:00	QQQ	ETF	105.16	105.62	105.01	105.5	2369444.0
2016-03-02 15:00:00	QQQ	ETF	105.5	105.83	105.27	105.805	5999710.0
2016-03-02 16:00:00	QQQ	ETF	105.81	105.86	105.65	105.65	867276.0
2016-03-02 17:00:00	QQQ	ETF	105.67	105.72	105.65	105.68	11800.0
2016-03-02 18:00:00	QQQ	ETF	105.67	105.67	105.5	105.51	15808.0
2016-03-02 19:00:00	QQQ	ETF	105.59	105.73	105.59	105.73	11305.0
2016-03-02 05:00:00	IWM	ETF	104.97	104.97	104.94	104.94	230.0
2016-03-02 06:00:00	IWM	ETF	104.92	104.92	104.92	104.92	200.0
2016-03-02 07:00:00	IWM	ETF	104.96	105.05	104.92	104.99	17504.0
2016-03-02 08:00:00	IWM	ETF	104.97	105.02	104.76	104.8	39029.0
2016-03-02 09:00:00	IWM	ETF	104.79	105.08	104.59	104.77	3988201.0
2016-03-02 10:00:00	IWM	ETF	104.78	105.36	104.64	105.33	4078070.0
2016-03-02 11:00:00	IWM	ETF	105.3	105.48	105.08	105.11	2678597.0
2016-03-02 12:00:00	IWM	ETF	105.1	105.35	105.02	105.32	1283959.0
2016-03-02 13:00:00	IWM	ETF	105.34	105.67	105.25	105.4	1701290.0
2016-03-02 14:00:00	IWM	ETF	105.3935	105.7	105.26	105.5801	1828899.0
2016-03-02 15:00:00	IWM	ETF	105.58	106.06	105.41	106.05	4669161.0
2016-03-02 16:00:00	IWM	ETF	106.07	106.1	105.93	106.0	897596.0
2016-03-02 17:00:00	IWM	ETF	105.98	106.07	105.98	106.05	27805.0
2016-03-02 18:00:00	IWM	ETF	105.98	105.98	105.9	105.9	3733.0
2016-03-02 19:00:00	IWM	ETF	105.93	106.04	105.93	106.04	2275.0
2016-03-02 04:00:00	DIA	ETF	168.52	168.52	168.52	168.52	2200.0
2016-03-02 07:00:00	DIA	ETF	168.13	168.13	168.13	168.13	100.0
2016-03-02 08:00:00	DIA	ETF	168.49	168.49	168.33	168.33	1000.0

> showing 50 of 7,987 rows — these rows as CSV

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