PREVIEW / etf_1hour / 2018-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-17.parquet
  size:    314 KB
  rows:    10,241

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-01-17 04:00:00	SPY	ETF	278.11	278.14	277.98	278.03	100715.0
2018-01-17 05:00:00	SPY	ETF	278.1	278.19	277.98	278.16	48256.0
2018-01-17 06:00:00	SPY	ETF	278.19	278.47	278.19	278.44	413444.0
2018-01-17 07:00:00	SPY	ETF	278.41	278.46	278.29	278.35	498302.0
2018-01-17 08:00:00	SPY	ETF	278.33	278.47	278.2	278.44	541553.0
2018-01-17 09:00:00	SPY	ETF	278.45	278.55	277.19	277.28	8810661.0
2018-01-17 10:00:00	SPY	ETF	277.28	278.0	277.2725	277.93	8556797.0
2018-01-17 11:00:00	SPY	ETF	277.9311	278.48	277.78	278.42	10846191.0
2018-01-17 12:00:00	SPY	ETF	278.42	279.05	278.4	279.02	9256493.0
2018-01-17 13:00:00	SPY	ETF	279.02	279.31	278.93	279.175	7773800.0
2018-01-17 14:00:00	SPY	ETF	279.175	279.87	279.1749	279.81	12126452.0
2018-01-17 15:00:00	SPY	ETF	279.81	280.05	279.33	279.61	26186066.0
2018-01-17 16:00:00	SPY	ETF	279.61	279.69	278.8071	279.5	23587880.0
2018-01-17 17:00:00	SPY	ETF	279.51	279.6	279.51	279.52	171841.0
2018-01-17 18:00:00	SPY	ETF	279.51	279.88	279.44	279.8	350114.0
2018-01-17 19:00:00	SPY	ETF	279.8	279.85	279.7	279.78	32540.0
2018-01-17 04:00:00	QQQ	ETF	164.56	164.74	164.56	164.74	33200.0
2018-01-17 05:00:00	QQQ	ETF	164.77	164.84	164.68	164.82	31989.0
2018-01-17 06:00:00	QQQ	ETF	164.84	165.01	164.84	164.89	88796.0
2018-01-17 07:00:00	QQQ	ETF	164.93	164.99	164.8	164.81	134620.0
2018-01-17 08:00:00	QQQ	ETF	164.84	165.1	164.77	165.08	239882.0
2018-01-17 09:00:00	QQQ	ETF	165.06	165.11	164.03	164.245	5843992.0
2018-01-17 10:00:00	QQQ	ETF	164.24	164.66	164.15	164.585	3389545.0
2018-01-17 11:00:00	QQQ	ETF	164.6	165.04	164.46	164.75	3286046.0
2018-01-17 12:00:00	QQQ	ETF	164.7446	165.26	164.74	165.25	2921689.0
2018-01-17 13:00:00	QQQ	ETF	165.245	165.56	165.18	165.3162	2902085.0
2018-01-17 14:00:00	QQQ	ETF	165.32	165.86	165.31	165.795	2954687.0
2018-01-17 15:00:00	QQQ	ETF	165.7901	166.04	165.65	165.781	5121224.0
2018-01-17 16:00:00	QQQ	ETF	165.79	165.88	164.705	165.7	2485521.0
2018-01-17 17:00:00	QQQ	ETF	165.74	165.78	165.74	165.75	18525.0
2018-01-17 18:00:00	QQQ	ETF	165.72	166.0	165.66	165.95	133427.0
2018-01-17 19:00:00	QQQ	ETF	165.8	166.02	165.76	165.99	26160.0
2018-01-17 04:00:00	IWM	ETF	156.99	157.13	156.98	157.13	5170.0
2018-01-17 05:00:00	IWM	ETF	157.06	157.06	157.04	157.05	2950.0
2018-01-17 06:00:00	IWM	ETF	157.15	157.33	157.15	157.29	5318.0
2018-01-17 07:00:00	IWM	ETF	157.31	157.32	157.23	157.27	49715.0
2018-01-17 08:00:00	IWM	ETF	157.31	157.31	157.05	157.12	122120.0
2018-01-17 09:00:00	IWM	ETF	157.11	157.13	156.28	156.4	2315815.0
2018-01-17 10:00:00	IWM	ETF	156.39	156.88	156.31	156.68	2213258.0
2018-01-17 11:00:00	IWM	ETF	156.68	156.96	156.39	156.86	1066166.0
2018-01-17 12:00:00	IWM	ETF	156.86	157.2646	156.85	157.24	1118853.0
2018-01-17 13:00:00	IWM	ETF	157.23	157.39	157.04	157.26	1099922.0
2018-01-17 14:00:00	IWM	ETF	157.27	157.88	157.27	157.87	1574271.0
2018-01-17 15:00:00	IWM	ETF	157.87	157.935	157.39	157.62	3353872.0
2018-01-17 16:00:00	IWM	ETF	157.63	157.69	157.4	157.58	1366916.0
2018-01-17 17:00:00	IWM	ETF	157.54	157.67	157.54	157.67	1297.0
2018-01-17 18:00:00	IWM	ETF	157.56	157.79	157.5	157.77	22941.0
2018-01-17 19:00:00	IWM	ETF	157.68	157.72	157.63	157.72	21727.0
2018-01-17 04:00:00	DIA	ETF	259.4	259.4	259.18	259.18	2600.0
2018-01-17 05:00:00	DIA	ETF	259.18	259.18	259.18	259.18	1000.0

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

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