PREVIEW / etf_1hour / 2018-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-11.parquet
  size:    296 KB
  rows:    9,721

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-04-11 04:00:00	SPY	ETF	263.9	263.9	263.36	263.62	32739.0
2018-04-11 05:00:00	SPY	ETF	263.65	263.81	263.64	263.64	10900.0
2018-04-11 06:00:00	SPY	ETF	263.64	263.71	262.48	262.87	171238.0
2018-04-11 07:00:00	SPY	ETF	262.9	263.08	262.15	263.08	1066739.0
2018-04-11 08:00:00	SPY	ETF	263.03	263.79	262.22	262.78	1003360.0
2018-04-11 09:00:00	SPY	ETF	262.81	264.56	262.66	264.48	10077091.0
2018-04-11 10:00:00	SPY	ETF	264.47	264.96	263.86	263.89	15883933.0
2018-04-11 11:00:00	SPY	ETF	263.88	265.23	263.55	264.925	9999258.0
2018-04-11 12:00:00	SPY	ETF	264.925	265.64	264.4	264.63	7974181.0
2018-04-11 13:00:00	SPY	ETF	264.63	265.0	264.12	264.6986	8110551.0
2018-04-11 14:00:00	SPY	ETF	264.7	265.01	263.96	264.47	10244435.0
2018-04-11 15:00:00	SPY	ETF	264.46	264.6	263.39	263.75	16792245.0
2018-04-11 16:00:00	SPY	ETF	263.75	263.83	263.54	263.78	8248313.0
2018-04-11 17:00:00	SPY	ETF	263.78	263.8	263.6	263.73	200963.0
2018-04-11 18:00:00	SPY	ETF	263.76	264.2	263.74	264.1	41303.0
2018-04-11 19:00:00	SPY	ETF	264.15	264.32	264.08	264.27	41835.0
2018-04-11 04:00:00	QQQ	ETF	160.4	160.4	160.11	160.28	7747.0
2018-04-11 05:00:00	QQQ	ETF	160.35	160.45	160.28	160.31	22500.0
2018-04-11 06:00:00	QQQ	ETF	160.33	160.33	159.4	159.74	113135.0
2018-04-11 07:00:00	QQQ	ETF	159.79	159.87	159.32	159.87	367717.0
2018-04-11 08:00:00	QQQ	ETF	159.52	159.96	159.4	159.78	371135.0
2018-04-11 09:00:00	QQQ	ETF	159.81	160.94	159.71	160.8823	5020867.0
2018-04-11 10:00:00	QQQ	ETF	160.88	161.5399	160.3	160.7495	5054109.0
2018-04-11 11:00:00	QQQ	ETF	160.75	161.64	160.39	161.38	3858057.0
2018-04-11 12:00:00	QQQ	ETF	161.37	162.0	160.89	161.0099	3952775.0
2018-04-11 13:00:00	QQQ	ETF	161.0	161.44	160.73	161.29	3293997.0
2018-04-11 14:00:00	QQQ	ETF	161.3	161.54	160.65	160.9211	3567237.0
2018-04-11 15:00:00	QQQ	ETF	160.93	161.03	160.1	160.33	7577340.0
2018-04-11 16:00:00	QQQ	ETF	160.32	160.9101	160.15	160.33	872998.0
2018-04-11 17:00:00	QQQ	ETF	160.26	160.45	160.22	160.32	5693.0
2018-04-11 18:00:00	QQQ	ETF	160.38	160.64	160.37	160.59	53699.0
2018-04-11 19:00:00	QQQ	ETF	160.61	160.82	160.61	160.81	29737.0
2018-04-11 04:00:00	IWM	ETF	152.75	152.77	152.55	152.73	11736.0
2018-04-11 05:00:00	IWM	ETF	152.67	152.72	152.67	152.72	500.0
2018-04-11 06:00:00	IWM	ETF	152.5	152.5	152.15	152.3	19159.0
2018-04-11 07:00:00	IWM	ETF	152.33	152.43	151.97	152.43	155151.0
2018-04-11 08:00:00	IWM	ETF	152.33	152.53	152.27	152.45	281635.0
2018-04-11 09:00:00	IWM	ETF	152.4	153.63	152.39	153.56	2186689.0
2018-04-11 10:00:00	IWM	ETF	153.55	153.94	153.1625	153.19	1751449.0
2018-04-11 11:00:00	IWM	ETF	153.2	154.27	153.08	154.08	1873129.0
2018-04-11 12:00:00	IWM	ETF	154.08	154.31	153.72	153.8828	1002607.0
2018-04-11 13:00:00	IWM	ETF	153.91	154.13	153.73	153.97	964738.0
2018-04-11 14:00:00	IWM	ETF	154.0	154.13	153.4917	153.93	1341419.0
2018-04-11 15:00:00	IWM	ETF	153.925	153.99	153.32	153.71	2409902.0
2018-04-11 16:00:00	IWM	ETF	153.71	153.8569	153.61	153.8	934144.0
2018-04-11 17:00:00	IWM	ETF	153.71	153.79	153.71	153.79	200.0
2018-04-11 18:00:00	IWM	ETF	153.8	154.08	153.71	154.04	14584.0
2018-04-11 19:00:00	IWM	ETF	154.05	154.15	154.04	154.09	2433.0
2018-04-11 04:00:00	DIA	ETF	243.13	243.13	242.8	242.8	300.0
2018-04-11 05:00:00	DIA	ETF	242.86	242.86	242.86	242.86	400.0

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

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