PREVIEW / etf_1hour / 2017-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-18.parquet
  size:    281 KB
  rows:    9,090

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
2017-08-18 04:00:00	SPY	ETF	243.11	243.11	242.72	242.8	26172.0
2017-08-18 05:00:00	SPY	ETF	242.78	243.25	242.77	243.1	18053.0
2017-08-18 06:00:00	SPY	ETF	243.15	243.38	243.15	243.23	35878.0
2017-08-18 07:00:00	SPY	ETF	243.23	243.45	243.0	243.4	335328.0
2017-08-18 08:00:00	SPY	ETF	243.23	243.56	242.61	243.38	1444259.0
2017-08-18 09:00:00	SPY	ETF	243.36	243.36	242.2	242.21	18470465.0
2017-08-18 10:00:00	SPY	ETF	242.22	242.99	242.21	242.7	26562177.0
2017-08-18 11:00:00	SPY	ETF	242.7	243.76	242.28	243.58	15754415.0
2017-08-18 12:00:00	SPY	ETF	243.58	244.189	243.24	243.8	12745175.0
2017-08-18 13:00:00	SPY	ETF	243.81	243.94	243.08	243.1	11928943.0
2017-08-18 14:00:00	SPY	ETF	243.09	243.49	243.08	243.19	7852209.0
2017-08-18 15:00:00	SPY	ETF	243.19	243.47	242.63	242.69	22783111.0
2017-08-18 16:00:00	SPY	ETF	242.7	242.98	242.6757	242.72	17285942.0
2017-08-18 17:00:00	SPY	ETF	242.72	242.8	242.59	242.6	310007.0
2017-08-18 18:00:00	SPY	ETF	242.59	242.61	242.48	242.52	54698.0
2017-08-18 19:00:00	SPY	ETF	242.59	242.66	242.53	242.58	15276.0
2017-08-18 04:00:00	QQQ	ETF	141.37	141.38	141.14	141.18	3904.0
2017-08-18 05:00:00	QQQ	ETF	141.32	141.61	141.32	141.5	33144.0
2017-08-18 06:00:00	QQQ	ETF	141.47	141.74	141.47	141.72	30310.0
2017-08-18 07:00:00	QQQ	ETF	141.74	141.82	141.61	141.8	111970.0
2017-08-18 08:00:00	QQQ	ETF	141.75	141.97	141.73	141.88	208140.0
2017-08-18 09:00:00	QQQ	ETF	141.86	141.87	140.65	140.67	10590141.0
2017-08-18 10:00:00	QQQ	ETF	140.68	141.61	140.67	141.41	7788409.0
2017-08-18 11:00:00	QQQ	ETF	141.4135	142.09	140.99	141.97	5825455.0
2017-08-18 12:00:00	QQQ	ETF	141.97	142.2	141.66	142.0	5242478.0
2017-08-18 13:00:00	QQQ	ETF	141.99	142.08	141.41	141.42	4144279.0
2017-08-18 14:00:00	QQQ	ETF	141.42	141.77	141.42	141.56	2815597.0
2017-08-18 15:00:00	QQQ	ETF	141.57	141.74	141.165	141.21	7425471.0
2017-08-18 16:00:00	QQQ	ETF	141.21	141.6587	140.869	141.3	5315760.0
2017-08-18 17:00:00	QQQ	ETF	141.3	141.3	141.1	141.11	20411.0
2017-08-18 18:00:00	QQQ	ETF	141.11	141.23	141.11	141.23	14966.0
2017-08-18 19:00:00	QQQ	ETF	141.18	141.34	141.18	141.23	34666.0
2017-08-18 04:00:00	IWM	ETF	134.57	134.57	134.25	134.25	4365.0
2017-08-18 05:00:00	IWM	ETF	134.28	134.43	134.26	134.43	21441.0
2017-08-18 06:00:00	IWM	ETF	134.52	134.67	134.52	134.6	32371.0
2017-08-18 07:00:00	IWM	ETF	134.58	134.77	134.47	134.7	161954.0
2017-08-18 08:00:00	IWM	ETF	134.7	134.88	134.7	134.75	179068.0
2017-08-18 09:00:00	IWM	ETF	134.73	134.78	134.12	134.29	4828468.0
2017-08-18 10:00:00	IWM	ETF	134.29	134.74	134.26	134.72	5007242.0
2017-08-18 11:00:00	IWM	ETF	134.73	135.305	134.48	135.25	4519449.0
2017-08-18 12:00:00	IWM	ETF	135.26	135.46	135.02	135.28	3372805.0
2017-08-18 13:00:00	IWM	ETF	135.29	135.39	135.0	135.02	2604814.0
2017-08-18 14:00:00	IWM	ETF	135.01	135.26	135.0	135.08	1918988.0
2017-08-18 15:00:00	IWM	ETF	135.08	135.23	134.86	134.91	6385434.0
2017-08-18 16:00:00	IWM	ETF	134.91	135.0966	134.83	134.95	3027344.0
2017-08-18 17:00:00	IWM	ETF	135.0	135.0	134.76	134.83	181857.0
2017-08-18 18:00:00	IWM	ETF	134.79	134.79	134.79	134.79	999.0
2017-08-18 19:00:00	IWM	ETF	134.8	134.89	134.8	134.89	3657.0
2017-08-18 05:00:00	DIA	ETF	217.28	217.28	217.2	217.2	1000.0
2017-08-18 07:00:00	DIA	ETF	217.24	217.29	217.16	217.29	1700.0

> showing 50 of 9,090 rows — these rows as CSV

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