PREVIEW / etf_1hour / 2018-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-16.parquet
  size:    309 KB
  rows:    10,142

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-02-16 04:00:00	SPY	ETF	274.03	274.53	274.03	274.3	44504.0
2018-02-16 05:00:00	SPY	ETF	274.3	274.52	273.75	273.94	39014.0
2018-02-16 06:00:00	SPY	ETF	273.9	274.06	273.54	273.8	22335.0
2018-02-16 07:00:00	SPY	ETF	273.74	274.05	273.61	273.92	227278.0
2018-02-16 08:00:00	SPY	ETF	273.91	273.95	272.98	273.05	601194.0
2018-02-16 09:00:00	SPY	ETF	273.04	273.46	272.13	272.76	12828121.0
2018-02-16 10:00:00	SPY	ETF	272.78	274.025	272.45	273.53	31882189.0
2018-02-16 11:00:00	SPY	ETF	273.52	274.69	273.52	274.57	8794896.0
2018-02-16 12:00:00	SPY	ETF	274.565	275.32	274.01	274.49	12889913.0
2018-02-16 13:00:00	SPY	ETF	274.51	274.78	272.905	273.66	15976046.0
2018-02-16 14:00:00	SPY	ETF	273.67	274.07	272.5	273.84	18493465.0
2018-02-16 15:00:00	SPY	ETF	273.835	274.21	273.02	273.09	27206419.0
2018-02-16 16:00:00	SPY	ETF	273.12	274.13	273.0	273.51	22330192.0
2018-02-16 17:00:00	SPY	ETF	273.53	273.8	273.11	273.45	4870071.0
2018-02-16 18:00:00	SPY	ETF	273.45	273.45	273.05	273.12	46473.0
2018-02-16 19:00:00	SPY	ETF	273.13	273.34	273.12	273.34	11319.0
2018-02-16 04:00:00	QQQ	ETF	166.68	167.05	166.68	166.74	22387.0
2018-02-16 05:00:00	QQQ	ETF	166.81	166.96	166.42	166.5	56490.0
2018-02-16 06:00:00	QQQ	ETF	166.48	166.59	166.25	166.4	53380.0
2018-02-16 07:00:00	QQQ	ETF	166.38	166.54	166.26	166.44	83717.0
2018-02-16 08:00:00	QQQ	ETF	166.4	166.92	165.62	165.64	480671.0
2018-02-16 09:00:00	QQQ	ETF	165.61	166.25	165.07	165.74	5201921.0
2018-02-16 10:00:00	QQQ	ETF	165.77	166.42	165.3015	165.95	6763450.0
2018-02-16 11:00:00	QQQ	ETF	165.9634	166.47	165.85	166.37	3363778.0
2018-02-16 12:00:00	QQQ	ETF	166.37	166.755	165.89	166.24	4843215.0
2018-02-16 13:00:00	QQQ	ETF	166.25	166.3911	164.99	165.36	6166918.0
2018-02-16 14:00:00	QQQ	ETF	165.3667	165.68	164.6799	165.55	6116089.0
2018-02-16 15:00:00	QQQ	ETF	165.56	165.7784	164.995	165.03	7805190.0
2018-02-16 16:00:00	QQQ	ETF	165.04	165.33	164.96	165.14	1246601.0
2018-02-16 17:00:00	QQQ	ETF	165.14	165.2	164.96	165.02	6981124.0
2018-02-16 18:00:00	QQQ	ETF	165.01	165.01	164.74	164.91	24425.0
2018-02-16 19:00:00	QQQ	ETF	164.99	165.16	164.92	165.14	12600.0
2018-02-16 04:00:00	IWM	ETF	153.62	153.81	153.62	153.65	3177.0
2018-02-16 05:00:00	IWM	ETF	153.69	153.69	153.51	153.53	3200.0
2018-02-16 06:00:00	IWM	ETF	153.44	153.44	153.2	153.31	4539.0
2018-02-16 07:00:00	IWM	ETF	153.31	153.5	153.31	153.42	17875.0
2018-02-16 08:00:00	IWM	ETF	153.26	153.4	152.92	153.0	146201.0
2018-02-16 09:00:00	IWM	ETF	152.88	153.52	152.47	153.12	2855094.0
2018-02-16 10:00:00	IWM	ETF	153.12	153.71	152.96	153.46	3546332.0
2018-02-16 11:00:00	IWM	ETF	153.46	154.14	153.41	154.03	1984564.0
2018-02-16 12:00:00	IWM	ETF	154.03	154.29	153.55	153.87	2341921.0
2018-02-16 13:00:00	IWM	ETF	153.87	154.0	153.02	153.53	2487379.0
2018-02-16 14:00:00	IWM	ETF	153.54	153.725	152.88	153.65	3586697.0
2018-02-16 15:00:00	IWM	ETF	153.64	153.84	153.28	153.3	5702707.0
2018-02-16 16:00:00	IWM	ETF	153.3	153.62	153.25	153.49	1058451.0
2018-02-16 17:00:00	IWM	ETF	153.48	153.49	153.34	153.35	755113.0
2018-02-16 18:00:00	IWM	ETF	153.36	153.36	153.34	153.35	500.0
2018-02-16 19:00:00	IWM	ETF	153.34	153.36	153.34	153.36	500.0
2018-02-16 04:00:00	DIA	ETF	253.07	253.07	253.07	253.07	100.0
2018-02-16 07:00:00	DIA	ETF	252.5	252.75	252.5	252.72	1225.0

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

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