PREVIEW / etf_1hour / 2018-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-14.parquet
  size:    295 KB
  rows:    9,626

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-03-14 04:00:00	SPY	ETF	277.58	278.0	277.39	277.72	57875.0
2018-03-14 05:00:00	SPY	ETF	277.93	278.0	277.72	277.93	27936.0
2018-03-14 06:00:00	SPY	ETF	277.92	278.1	277.64	277.64	67757.0
2018-03-14 07:00:00	SPY	ETF	277.67	277.94	277.67	277.85	134716.0
2018-03-14 08:00:00	SPY	ETF	277.86	277.98	276.65	277.68	467861.0
2018-03-14 09:00:00	SPY	ETF	277.7	278.02	276.94	277.29	7546480.0
2018-03-14 10:00:00	SPY	ETF	277.29	277.61	276.41	276.8	9335269.0
2018-03-14 11:00:00	SPY	ETF	276.8	276.92	275.03	275.32	12312055.0
2018-03-14 12:00:00	SPY	ETF	275.33	276.0	274.84	275.52	11825848.0
2018-03-14 13:00:00	SPY	ETF	275.51	276.58	274.87	276.225	10940281.0
2018-03-14 14:00:00	SPY	ETF	276.23	276.38	274.73	275.53	10476437.0
2018-03-14 15:00:00	SPY	ETF	275.53	275.6	274.67	275.27	26317343.0
2018-03-14 16:00:00	SPY	ETF	275.26	275.7639	275.05	275.35	13215128.0
2018-03-14 17:00:00	SPY	ETF	275.39	275.44	275.2117	275.31	1587119.0
2018-03-14 18:00:00	SPY	ETF	275.33	275.62	275.27	275.62	80404.0
2018-03-14 19:00:00	SPY	ETF	275.6	275.62	275.13	275.42	52403.0
2018-03-14 04:00:00	QQQ	ETF	172.37	172.84	172.2	172.73	23460.0
2018-03-14 05:00:00	QQQ	ETF	172.88	172.91	172.71	172.78	20550.0
2018-03-14 06:00:00	QQQ	ETF	172.95	173.0	172.75	172.75	19880.0
2018-03-14 07:00:00	QQQ	ETF	172.77	172.92	172.71	172.75	70726.0
2018-03-14 08:00:00	QQQ	ETF	172.76	172.87	171.3	172.65	234901.0
2018-03-14 09:00:00	QQQ	ETF	172.66	172.76	171.87	172.12	3086160.0
2018-03-14 10:00:00	QQQ	ETF	172.13	172.64	171.71	172.3	4471793.0
2018-03-14 11:00:00	QQQ	ETF	172.3	172.3999	170.96	171.25	4617630.0
2018-03-14 12:00:00	QQQ	ETF	171.26	172.08	170.93	171.84	3670699.0
2018-03-14 13:00:00	QQQ	ETF	171.81	172.66	171.43	172.3557	4150799.0
2018-03-14 14:00:00	QQQ	ETF	172.36	172.46	171.3	171.84	4473914.0
2018-03-14 15:00:00	QQQ	ETF	171.835	171.88	171.31	171.69	4970869.0
2018-03-14 16:00:00	QQQ	ETF	171.68	172.145	171.42	171.51	3919904.0
2018-03-14 17:00:00	QQQ	ETF	171.44	171.68	171.44	171.6	40809.0
2018-03-14 18:00:00	QQQ	ETF	171.6	171.69	171.48	171.69	38211.0
2018-03-14 19:00:00	QQQ	ETF	171.74	171.75	171.45	171.59	44997.0
2018-03-14 04:00:00	IWM	ETF	160.0	160.0	159.31	159.4	12500.0
2018-03-14 05:00:00	IWM	ETF	159.52	159.53	159.32	159.44	5704.0
2018-03-14 06:00:00	IWM	ETF	159.47	159.47	159.4	159.44	3478.0
2018-03-14 07:00:00	IWM	ETF	159.39	159.5	159.3	159.39	56471.0
2018-03-14 08:00:00	IWM	ETF	159.38	159.46	159.19	159.32	25703.0
2018-03-14 09:00:00	IWM	ETF	159.32	159.42	158.185	158.59	1351996.0
2018-03-14 10:00:00	IWM	ETF	158.61	158.96	158.02	158.27	1800557.0
2018-03-14 11:00:00	IWM	ETF	158.28	158.39	157.41	157.72	2447668.0
2018-03-14 12:00:00	IWM	ETF	157.73	158.21	157.46	158.016	1533270.0
2018-03-14 13:00:00	IWM	ETF	157.97	158.6701	157.64	158.405	1475071.0
2018-03-14 14:00:00	IWM	ETF	158.41	158.45	157.47	157.92	1363203.0
2018-03-14 15:00:00	IWM	ETF	157.92	157.95	157.42	157.7	3205742.0
2018-03-14 16:00:00	IWM	ETF	157.71	158.1494	157.4611	157.71	2298528.0
2018-03-14 17:00:00	IWM	ETF	157.66	157.66	157.65	157.65	200.0
2018-03-14 18:00:00	IWM	ETF	157.65	157.78	157.65	157.78	5572.0
2018-03-14 19:00:00	IWM	ETF	157.79	157.79	157.64	157.78	2906.0
2018-03-14 04:00:00	DIA	ETF	251.0	251.52	251.0	251.52	1602.0
2018-03-14 05:00:00	DIA	ETF	251.48	251.5	251.48	251.5	202.0

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

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