PREVIEW / etf_1hour / 2018-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-02.parquet
  size:    307 KB
  rows:    10,205

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
2018-07-02 04:00:00	SPY	ETF	269.8	270.13	269.5	270.11	53350.0
2018-07-02 05:00:00	SPY	ETF	270.06	270.08	269.7	269.9	35684.0
2018-07-02 06:00:00	SPY	ETF	269.9	270.03	269.42	269.97	134614.0
2018-07-02 07:00:00	SPY	ETF	269.97	270.1	269.8	270.08	167421.0
2018-07-02 08:00:00	SPY	ETF	270.0	271.28	269.21	269.66	448753.0
2018-07-02 09:00:00	SPY	ETF	271.28	271.28	269.24	270.0675	8484434.0
2018-07-02 10:00:00	SPY	ETF	270.04	270.77	269.61	270.53	8846666.0
2018-07-02 11:00:00	SPY	ETF	270.53	271.07	269.96	270.175	6506528.0
2018-07-02 12:00:00	SPY	ETF	270.17	270.35	269.69	270.13	4639322.0
2018-07-02 13:00:00	SPY	ETF	270.125	270.68	269.58	270.55	5177655.0
2018-07-02 14:00:00	SPY	ETF	270.54	271.38	270.51	270.78	6026411.0
2018-07-02 15:00:00	SPY	ETF	270.78	272.04	270.62	271.94	13526641.0
2018-07-02 16:00:00	SPY	ETF	271.91	272.0	270.0441	271.91	7720782.0
2018-07-02 17:00:00	SPY	ETF	271.88	271.97	271.87	271.88	210044.0
2018-07-02 18:00:00	SPY	ETF	271.91	271.92	271.71	271.76	123020.0
2018-07-02 19:00:00	SPY	ETF	271.77	271.93	271.74	271.91	22085.0
2018-07-02 04:00:00	QQQ	ETF	170.29	170.52	170.1	170.42	17275.0
2018-07-02 05:00:00	QQQ	ETF	170.45	170.51	170.26	170.4	15800.0
2018-07-02 06:00:00	QQQ	ETF	170.37	170.53	170.13	170.46	24180.0
2018-07-02 07:00:00	QQQ	ETF	170.48	170.74	170.36	170.52	160711.0
2018-07-02 08:00:00	QQQ	ETF	170.5	171.65	170.15	170.23	236174.0
2018-07-02 09:00:00	QQQ	ETF	171.65	171.65	169.67	170.8388	5476126.0
2018-07-02 10:00:00	QQQ	ETF	170.81	171.52	170.5586	171.24	4803579.0
2018-07-02 11:00:00	QQQ	ETF	171.24	171.65	170.79	170.98	2852404.0
2018-07-02 12:00:00	QQQ	ETF	170.97	171.17	170.76	171.04	1682955.0
2018-07-02 13:00:00	QQQ	ETF	171.035	171.74	170.66	171.665	2476366.0
2018-07-02 14:00:00	QQQ	ETF	171.6699	172.47	171.64	171.89	5189861.0
2018-07-02 15:00:00	QQQ	ETF	171.89	172.85	171.82	172.81	4590873.0
2018-07-02 16:00:00	QQQ	ETF	172.8	172.87	172.72	172.8	1036925.0
2018-07-02 17:00:00	QQQ	ETF	172.73	172.83	172.66	172.74	23321.0
2018-07-02 18:00:00	QQQ	ETF	172.73	172.73	172.6	172.6	28830.0
2018-07-02 19:00:00	QQQ	ETF	172.6	172.76	172.6	172.75	23111.0
2018-07-02 04:00:00	IWM	ETF	162.84	162.84	162.62	162.62	410.0
2018-07-02 05:00:00	IWM	ETF	162.95	162.96	162.82	162.86	8000.0
2018-07-02 06:00:00	IWM	ETF	162.83	162.83	162.59	162.73	11806.0
2018-07-02 07:00:00	IWM	ETF	162.71	162.79	162.69	162.79	12550.0
2018-07-02 08:00:00	IWM	ETF	162.6601	164.9	162.6	162.78	488269.0
2018-07-02 09:00:00	IWM	ETF	163.77	163.77	162.48	163.2178	2045961.0
2018-07-02 10:00:00	IWM	ETF	163.16	164.02	162.84	163.63	3256820.0
2018-07-02 11:00:00	IWM	ETF	163.65	163.91	162.79	163.27	2124356.0
2018-07-02 12:00:00	IWM	ETF	163.27	163.74	163.13	163.59	1372951.0
2018-07-02 13:00:00	IWM	ETF	163.59	163.82	163.21	163.6	1558054.0
2018-07-02 14:00:00	IWM	ETF	163.605	164.16	163.54	163.98	2351800.0
2018-07-02 15:00:00	IWM	ETF	163.99	164.96	163.91	164.93	4196236.0
2018-07-02 16:00:00	IWM	ETF	164.9266	165.07	164.81	165.0	1772400.0
2018-07-02 17:00:00	IWM	ETF	164.93	164.98	164.9	164.98	453055.0
2018-07-02 18:00:00	IWM	ETF	164.91	164.91	164.88	164.88	600.0
2018-07-02 19:00:00	IWM	ETF	164.95	164.96	164.95	164.96	400.0
2018-07-02 04:00:00	DIA	ETF	241.2	241.3	240.99	241.3	750.0
2018-07-02 06:00:00	DIA	ETF	240.87	241.42	240.87	241.42	2600.0

> showing 50 of 10,205 rows — these rows as CSV

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