PREVIEW / etf_1hour / 2018-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-19.parquet
  size:    301 KB
  rows:    9,871

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-07-19 04:00:00	SPY	ETF	280.59	280.68	280.29	280.59	42517.0
2018-07-19 05:00:00	SPY	ETF	280.64	280.64	280.35	280.35	36221.0
2018-07-19 06:00:00	SPY	ETF	280.38	280.41	280.09	280.32	65581.0
2018-07-19 07:00:00	SPY	ETF	280.36	280.38	280.15	280.16	208170.0
2018-07-19 08:00:00	SPY	ETF	280.15	280.88	280.05	280.12	589334.0
2018-07-19 09:00:00	SPY	ETF	280.11	280.69	279.46	279.78	7200846.0
2018-07-19 10:00:00	SPY	ETF	279.77	280.21	279.63	280.01	8527001.0
2018-07-19 11:00:00	SPY	ETF	280.02	280.58	280.0161	280.45	5495259.0
2018-07-19 12:00:00	SPY	ETF	280.46	280.52	279.9	280.09	4212606.0
2018-07-19 13:00:00	SPY	ETF	280.09	280.57	279.77	280.55	7384529.0
2018-07-19 14:00:00	SPY	ETF	280.55	280.74	280.11	280.265	5757872.0
2018-07-19 15:00:00	SPY	ETF	280.27	280.41	279.8	280.01	9796117.0
2018-07-19 16:00:00	SPY	ETF	280.0	280.1758	279.8	279.97	9319186.0
2018-07-19 17:00:00	SPY	ETF	279.94	280.02	279.9	279.99	450149.0
2018-07-19 18:00:00	SPY	ETF	280.04	280.17	279.92	280.0	46101.0
2018-07-19 19:00:00	SPY	ETF	280.16	280.22	279.9703	280.11	64089.0
2018-07-19 04:00:00	QQQ	ETF	179.71	179.77	179.54	179.75	5450.0
2018-07-19 05:00:00	QQQ	ETF	179.69	179.7	179.49	179.54	8210.0
2018-07-19 06:00:00	QQQ	ETF	179.51	179.51	179.17	179.3	18375.0
2018-07-19 07:00:00	QQQ	ETF	179.41	179.46	179.23	179.26	255381.0
2018-07-19 08:00:00	QQQ	ETF	179.3001	180.0	179.15	179.2	180947.0
2018-07-19 09:00:00	QQQ	ETF	179.21	179.88	178.9	179.16	3090155.0
2018-07-19 10:00:00	QQQ	ETF	179.15	179.42	178.92	179.31	5487042.0
2018-07-19 11:00:00	QQQ	ETF	179.314	179.76	179.31	179.59	1799581.0
2018-07-19 12:00:00	QQQ	ETF	179.59	179.64	178.84	179.11	1995884.0
2018-07-19 13:00:00	QQQ	ETF	179.11	179.635	178.86	179.5	2913607.0
2018-07-19 14:00:00	QQQ	ETF	179.51	179.66	179.06	179.22	1571300.0
2018-07-19 15:00:00	QQQ	ETF	179.23	179.28	178.82	179.09	4926607.0
2018-07-19 16:00:00	QQQ	ETF	179.07	179.5217	178.74	179.06	1557083.0
2018-07-19 17:00:00	QQQ	ETF	179.05	179.4	178.92	179.31	69200.0
2018-07-19 18:00:00	QQQ	ETF	179.39	179.63	179.37	179.45	170035.0
2018-07-19 19:00:00	QQQ	ETF	179.45	179.6	179.45	179.55	49242.0
2018-07-19 04:00:00	IWM	ETF	167.79	167.86	167.7	167.86	4074.0
2018-07-19 05:00:00	IWM	ETF	167.77	167.83	167.69	167.69	2530.0
2018-07-19 06:00:00	IWM	ETF	167.66	167.66	167.51	167.51	2917.0
2018-07-19 07:00:00	IWM	ETF	167.6	167.63	167.47	167.49	20295.0
2018-07-19 08:00:00	IWM	ETF	167.455	167.62	167.36	167.4	176603.0
2018-07-19 09:00:00	IWM	ETF	167.54	167.93	167.26	167.67	1671674.0
2018-07-19 10:00:00	IWM	ETF	167.67	168.57	167.58	168.46	2548603.0
2018-07-19 11:00:00	IWM	ETF	168.47	168.84	168.4	168.83	2444115.0
2018-07-19 12:00:00	IWM	ETF	168.83	168.94	168.54	168.66	1267512.0
2018-07-19 13:00:00	IWM	ETF	168.65	169.13	168.44	169.1	1642179.0
2018-07-19 14:00:00	IWM	ETF	169.1015	169.25	168.9685	169.15	1627557.0
2018-07-19 15:00:00	IWM	ETF	169.15	169.2	168.79	169.13	3704243.0
2018-07-19 16:00:00	IWM	ETF	169.13	169.17	168.9	169.02	1133135.0
2018-07-19 17:00:00	IWM	ETF	168.0329	169.05	168.0329	168.91	70176.0
2018-07-19 18:00:00	IWM	ETF	168.98	169.08	168.9	169.08	12087.0
2018-07-19 19:00:00	IWM	ETF	169.12	169.12	168.98	168.98	3157.0
2018-07-19 05:00:00	DIA	ETF	251.52	251.52	251.52	251.52	250.0
2018-07-19 06:00:00	DIA	ETF	251.35	251.35	251.18	251.18	800.0

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

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