PREVIEW / etf_1hour / 2017-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-01.parquet
  size:    280 KB
  rows:    9,239

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-01 04:00:00	SPY	ETF	247.4	247.67	247.38	247.64	13014.0
2017-08-01 05:00:00	SPY	ETF	247.5	247.56	247.49	247.56	47185.0
2017-08-01 06:00:00	SPY	ETF	247.5	247.5	247.3	247.34	10250.0
2017-08-01 07:00:00	SPY	ETF	247.33	247.33	247.09	247.27	42071.0
2017-08-01 08:00:00	SPY	ETF	247.3	247.47	246.77	247.45	534321.0
2017-08-01 09:00:00	SPY	ETF	247.47	247.59	246.92	247.0	6114679.0
2017-08-01 10:00:00	SPY	ETF	247.005	247.32	246.86	247.245	8321132.0
2017-08-01 11:00:00	SPY	ETF	247.24	247.32	246.8	247.265	5082635.0
2017-08-01 12:00:00	SPY	ETF	247.26	247.39	247.21	247.27	3821968.0
2017-08-01 13:00:00	SPY	ETF	247.26	247.38	247.23	247.33	3372436.0
2017-08-01 14:00:00	SPY	ETF	247.34	247.37	246.716	247.335	2916748.0
2017-08-01 15:00:00	SPY	ETF	247.3314	247.365	247.15	247.309	8614251.0
2017-08-01 16:00:00	SPY	ETF	247.31	247.46	247.11	247.41	14230801.0
2017-08-01 17:00:00	SPY	ETF	247.42	247.47	247.31	247.39	230685.0
2017-08-01 18:00:00	SPY	ETF	247.41	247.52	247.37	247.39	60314.0
2017-08-01 19:00:00	SPY	ETF	247.43	247.56	247.41	247.54	15240.0
2017-08-01 04:00:00	QQQ	ETF	143.69	143.97	143.69	143.97	4107.0
2017-08-01 05:00:00	QQQ	ETF	143.95	144.0	143.87	143.88	13600.0
2017-08-01 06:00:00	QQQ	ETF	143.88	143.9	143.7	143.75	24704.0
2017-08-01 07:00:00	QQQ	ETF	143.75	143.75	143.52	143.67	30294.0
2017-08-01 08:00:00	QQQ	ETF	143.65	143.75	143.23	143.68	296955.0
2017-08-01 09:00:00	QQQ	ETF	143.69	143.77	143.31	143.4214	3991597.0
2017-08-01 10:00:00	QQQ	ETF	143.42	143.73	143.12	143.63	3557111.0
2017-08-01 11:00:00	QQQ	ETF	143.62	143.67	143.22	143.49	1851900.0
2017-08-01 12:00:00	QQQ	ETF	143.49	143.52	143.32	143.41	1113199.0
2017-08-01 13:00:00	QQQ	ETF	143.41	143.55	143.36	143.49	804704.0
2017-08-01 14:00:00	QQQ	ETF	143.48	143.5698	143.35	143.43	1337656.0
2017-08-01 15:00:00	QQQ	ETF	143.43	143.56	143.29	143.52	3883676.0
2017-08-01 16:00:00	QQQ	ETF	143.53	144.41	143.16	144.37	1549249.0
2017-08-01 17:00:00	QQQ	ETF	144.37	144.54	143.56	144.46	224169.0
2017-08-01 18:00:00	QQQ	ETF	144.49	144.54	144.32	144.36	101430.0
2017-08-01 19:00:00	QQQ	ETF	144.37	144.51	144.34	144.47	10330.0
2017-08-01 04:00:00	IWM	ETF	141.83	142.05	141.83	142.05	300.0
2017-08-01 05:00:00	IWM	ETF	142.1	142.11	142.05	142.05	4700.0
2017-08-01 06:00:00	IWM	ETF	142.08	142.08	142.01	142.01	2593.0
2017-08-01 07:00:00	IWM	ETF	141.95	141.98	141.85	141.98	13833.0
2017-08-01 08:00:00	IWM	ETF	141.99	142.04	141.51	142.03	219777.0
2017-08-01 09:00:00	IWM	ETF	142.04	142.24	141.17	141.27	2185247.0
2017-08-01 10:00:00	IWM	ETF	141.29	141.66	140.965	141.59	2573090.0
2017-08-01 11:00:00	IWM	ETF	141.58	141.75	141.4267	141.56	1730806.0
2017-08-01 12:00:00	IWM	ETF	141.55	141.575	141.24	141.38	1141256.0
2017-08-01 13:00:00	IWM	ETF	141.38	141.66	141.36	141.64	1038425.0
2017-08-01 14:00:00	IWM	ETF	141.63	141.74	141.54	141.65	1395934.0
2017-08-01 15:00:00	IWM	ETF	141.655	141.94	141.61	141.81	3792119.0
2017-08-01 16:00:00	IWM	ETF	141.82	141.91	141.5419	141.84	1776599.0
2017-08-01 17:00:00	IWM	ETF	141.85	141.99	141.8	141.8	1107.0
2017-08-01 18:00:00	IWM	ETF	141.86	141.86	141.86	141.86	1600.0
2017-08-01 19:00:00	IWM	ETF	141.93	141.93	141.93	141.93	100.0
2017-08-01 04:00:00	DIA	ETF	219.2	219.2	219.2	219.2	200.0
2017-08-01 05:00:00	DIA	ETF	219.66	219.7	219.66	219.7	300.0

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

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