PREVIEW / etf_1hour / 2018-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-02.parquet
  size:    325 KB
  rows:    10,664

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-11-02 04:00:00	SPY	ETF	275.5	276.0	275.41	275.55	180575.0
2018-11-02 05:00:00	SPY	ETF	275.5	275.6	275.08	275.14	56034.0
2018-11-02 06:00:00	SPY	ETF	275.11	275.61	275.01	275.51	140922.0
2018-11-02 07:00:00	SPY	ETF	275.46	276.19	275.33	275.95	527220.0
2018-11-02 08:00:00	SPY	ETF	275.54	276.11	273.42	275.15	2551300.0
2018-11-02 09:00:00	SPY	ETF	275.17	275.32	274.08	274.41	10286375.0
2018-11-02 10:00:00	SPY	ETF	274.39	274.48	271.79	272.87	19564063.0
2018-11-02 11:00:00	SPY	ETF	272.88	273.73	271.16	271.9399	13581455.0
2018-11-02 12:00:00	SPY	ETF	271.93	273.8143	269.78	270.2075	12092383.0
2018-11-02 13:00:00	SPY	ETF	270.195	271.3798	269.59	270.91	11535092.0
2018-11-02 14:00:00	SPY	ETF	270.92	272.9801	270.03	271.53	17297786.0
2018-11-02 15:00:00	SPY	ETF	271.53	272.14	270.81	271.8	20369501.0
2018-11-02 16:00:00	SPY	ETF	271.84	272.14	271.4684	271.9	12501046.0
2018-11-02 17:00:00	SPY	ETF	271.9	272.05	271.62	271.77	245784.0
2018-11-02 18:00:00	SPY	ETF	271.77	271.93	271.71	271.75	36398.0
2018-11-02 19:00:00	SPY	ETF	271.74	271.84	271.7	271.82	12091.0
2018-11-02 04:00:00	QQQ	ETF	172.75	173.39	172.69	172.82	178053.0
2018-11-02 05:00:00	QQQ	ETF	172.76	172.76	172.32	172.46	83006.0
2018-11-02 06:00:00	QQQ	ETF	172.36	172.62	172.32	172.53	93207.0
2018-11-02 07:00:00	QQQ	ETF	172.49	172.88	172.36	172.68	297645.0
2018-11-02 08:00:00	QQQ	ETF	172.5699	173.68	171.0	172.04	1130927.0
2018-11-02 09:00:00	QQQ	ETF	171.99	172.55	170.93	171.345	9014399.0
2018-11-02 10:00:00	QQQ	ETF	171.34	171.45	169.2	170.28	11549096.0
2018-11-02 11:00:00	QQQ	ETF	170.295	170.35	169.06	169.98	8903359.0
2018-11-02 12:00:00	QQQ	ETF	169.97	170.07	168.3	168.68	7480463.0
2018-11-02 13:00:00	QQQ	ETF	168.68	169.6	168.22	169.22	5836527.0
2018-11-02 14:00:00	QQQ	ETF	169.22	169.98	168.32	169.58	9132733.0
2018-11-02 15:00:00	QQQ	ETF	169.58	170.0	169.01	169.54	8852457.0
2018-11-02 16:00:00	QQQ	ETF	169.515	169.91	169.38	169.78	2002220.0
2018-11-02 17:00:00	QQQ	ETF	169.68	169.83	169.38	169.69	208923.0
2018-11-02 18:00:00	QQQ	ETF	169.7	169.82	169.61	169.82	5171.0
2018-11-02 19:00:00	QQQ	ETF	169.76	169.76	169.59	169.6	9024.0
2018-11-02 04:00:00	IWM	ETF	154.9	154.9	154.37	154.37	34475.0
2018-11-02 05:00:00	IWM	ETF	154.32	154.36	154.32	154.35	6000.0
2018-11-02 06:00:00	IWM	ETF	154.34	154.4	154.3	154.3	736.0
2018-11-02 07:00:00	IWM	ETF	154.38	154.88	154.34	154.74	46000.0
2018-11-02 08:00:00	IWM	ETF	154.39	154.8	153.56	154.35	165031.0
2018-11-02 09:00:00	IWM	ETF	154.33	154.89	153.81	154.62	2708435.0
2018-11-02 10:00:00	IWM	ETF	154.624	154.705	152.95	154.09	4535320.0
2018-11-02 11:00:00	IWM	ETF	154.1	154.15	152.81	153.63	2586425.0
2018-11-02 12:00:00	IWM	ETF	153.63	153.75	152.6	152.79	2235160.0
2018-11-02 13:00:00	IWM	ETF	152.7885	153.65	152.4365	153.62	2047580.0
2018-11-02 14:00:00	IWM	ETF	153.63	153.87	152.73	153.57	2980064.0
2018-11-02 15:00:00	IWM	ETF	153.56	154.01	153.2	153.94	5108972.0
2018-11-02 16:00:00	IWM	ETF	153.8574	154.15	153.8415	153.89	1868764.0
2018-11-02 17:00:00	IWM	ETF	153.96	154.0	153.96	154.0	5090.0
2018-11-02 18:00:00	IWM	ETF	153.99	154.0	153.9	153.9	795.0
2018-11-02 19:00:00	IWM	ETF	153.92	153.94	153.92	153.94	200.0
2018-11-02 04:00:00	DIA	ETF	255.1	256.0	255.1	255.72	1535.0
2018-11-02 06:00:00	DIA	ETF	255.66	255.78	255.66	255.78	200.0

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

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