PREVIEW / etf_1hour / 2017-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-13.parquet
  size:    282 KB
  rows:    9,279

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-10-13 04:00:00	SPY	ETF	254.65	254.65	254.58	254.63	14203.0
2017-10-13 05:00:00	SPY	ETF	254.67	254.8	254.67	254.8	3103.0
2017-10-13 06:00:00	SPY	ETF	254.8	254.87	254.8	254.87	4700.0
2017-10-13 07:00:00	SPY	ETF	254.87	255.04	254.81	254.97	196939.0
2017-10-13 08:00:00	SPY	ETF	255.0	255.26	254.96	255.13	980728.0
2017-10-13 09:00:00	SPY	ETF	255.13	255.15	254.76	254.91	4232095.0
2017-10-13 10:00:00	SPY	ETF	254.92	255.27	254.64	255.125	6287512.0
2017-10-13 11:00:00	SPY	ETF	255.125	255.23	254.94	255.12	3025566.0
2017-10-13 12:00:00	SPY	ETF	255.115	255.2	255.04	255.165	4023891.0
2017-10-13 13:00:00	SPY	ETF	255.16	255.27	255.07	255.0775	2874291.0
2017-10-13 14:00:00	SPY	ETF	255.075	255.17	254.95	255.0607	3412453.0
2017-10-13 15:00:00	SPY	ETF	255.07	255.179	254.77	254.91	14197108.0
2017-10-13 16:00:00	SPY	ETF	254.91	255.16	254.8423	254.98	12822256.0
2017-10-13 17:00:00	SPY	ETF	254.98	255.07	254.95	255.02	911243.0
2017-10-13 18:00:00	SPY	ETF	255.05	255.11	254.95	254.96	118340.0
2017-10-13 19:00:00	SPY	ETF	254.96	254.96	254.82	254.91	46548.0
2017-10-13 05:00:00	QQQ	ETF	147.84	147.91	147.83	147.91	300.0
2017-10-13 06:00:00	QQQ	ETF	147.92	148.0	147.91	147.92	45291.0
2017-10-13 07:00:00	QQQ	ETF	147.96	148.05	147.89	148.04	56683.0
2017-10-13 08:00:00	QQQ	ETF	147.93	148.4	147.93	148.3	259854.0
2017-10-13 09:00:00	QQQ	ETF	148.33	148.4	148.19	148.25	2422642.0
2017-10-13 10:00:00	QQQ	ETF	148.25	148.5	148.24	148.3	1821883.0
2017-10-13 11:00:00	QQQ	ETF	148.305	148.42	148.235	148.39	1225704.0
2017-10-13 12:00:00	QQQ	ETF	148.395	148.47	148.33	148.43	840230.0
2017-10-13 13:00:00	QQQ	ETF	148.425	148.51	148.36	148.375	1110606.0
2017-10-13 14:00:00	QQQ	ETF	148.38	148.4473	148.32	148.41	1033410.0
2017-10-13 15:00:00	QQQ	ETF	148.4	148.45	148.24	148.34	3070489.0
2017-10-13 16:00:00	QQQ	ETF	148.33	148.8	148.3	148.43	1650901.0
2017-10-13 17:00:00	QQQ	ETF	148.43	148.56	148.43	148.49	24466.0
2017-10-13 18:00:00	QQQ	ETF	148.49	148.54	148.48	148.49	26955.0
2017-10-13 19:00:00	QQQ	ETF	148.45	148.45	148.41	148.44	4501.0
2017-10-13 04:00:00	IWM	ETF	149.74	149.74	149.74	149.74	100.0
2017-10-13 05:00:00	IWM	ETF	149.75	149.75	149.75	149.75	1000.0
2017-10-13 06:00:00	IWM	ETF	149.87	149.87	149.87	149.87	3654.0
2017-10-13 07:00:00	IWM	ETF	149.93	150.1	149.9	150.05	46419.0
2017-10-13 08:00:00	IWM	ETF	150.05	150.11	149.97	149.97	78133.0
2017-10-13 09:00:00	IWM	ETF	149.98	149.98	149.23	149.44	2231314.0
2017-10-13 10:00:00	IWM	ETF	149.45	149.99	149.43	149.82	2273656.0
2017-10-13 11:00:00	IWM	ETF	149.82	149.93	149.53	149.64	997228.0
2017-10-13 12:00:00	IWM	ETF	149.645	149.725	149.45	149.64	715474.0
2017-10-13 13:00:00	IWM	ETF	149.65	149.74	149.51	149.54	586392.0
2017-10-13 14:00:00	IWM	ETF	149.54	149.62	149.45	149.61	1040067.0
2017-10-13 15:00:00	IWM	ETF	149.61	149.69	149.27	149.36	2619192.0
2017-10-13 16:00:00	IWM	ETF	149.37	149.53	149.35	149.44	1234372.0
2017-10-13 17:00:00	IWM	ETF	149.43	149.52	149.42	149.42	1021.0
2017-10-13 18:00:00	IWM	ETF	149.37	149.5	149.37	149.5	44644.0
2017-10-13 19:00:00	IWM	ETF	149.45	149.45	149.43	149.43	1399.0
2017-10-13 06:00:00	DIA	ETF	228.44	228.44	228.44	228.44	500.0
2017-10-13 07:00:00	DIA	ETF	228.72	228.83	228.72	228.83	900.0
2017-10-13 08:00:00	DIA	ETF	228.8	228.88	228.76	228.83	3430.0

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

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