PREVIEW / etf_1hour / 2018-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-12.parquet
  size:    298 KB
  rows:    9,762

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-12 04:00:00	SPY	ETF	277.69	277.76	277.37	277.47	10001.0
2018-07-12 05:00:00	SPY	ETF	277.63	278.04	277.63	277.99	17494.0
2018-07-12 06:00:00	SPY	ETF	277.96	278.44	277.78	278.42	80275.0
2018-07-12 07:00:00	SPY	ETF	278.39	278.43	278.15	278.22	238340.0
2018-07-12 08:00:00	SPY	ETF	278.39	278.46	276.86	278.37	613770.0
2018-07-12 09:00:00	SPY	ETF	278.38	278.44	277.6	278.17	6485815.0
2018-07-12 10:00:00	SPY	ETF	278.16	278.76	278.15	278.325	5700125.0
2018-07-12 11:00:00	SPY	ETF	278.33	278.94	278.24	278.89	5892975.0
2018-07-12 12:00:00	SPY	ETF	278.89	279.27	278.56	279.18	7354269.0
2018-07-12 13:00:00	SPY	ETF	279.18	279.35	278.87	278.92	5521242.0
2018-07-12 14:00:00	SPY	ETF	278.9288	279.08	278.79	278.96	4798287.0
2018-07-12 15:00:00	SPY	ETF	278.955	279.43	278.67	279.3	14686731.0
2018-07-12 16:00:00	SPY	ETF	279.3	279.37	278.9	279.16	5864931.0
2018-07-12 17:00:00	SPY	ETF	279.16	279.37	279.06	279.18	257651.0
2018-07-12 18:00:00	SPY	ETF	279.18	279.26	279.09	279.15	42923.0
2018-07-12 19:00:00	SPY	ETF	279.19	279.6	279.19	279.49	90437.0
2018-07-12 04:00:00	QQQ	ETF	176.91	176.93	176.58	176.82	12450.0
2018-07-12 05:00:00	QQQ	ETF	177.0	177.18	176.92	176.95	7505.0
2018-07-12 06:00:00	QQQ	ETF	177.01	177.1	176.85	177.1	21837.0
2018-07-12 07:00:00	QQQ	ETF	177.17	177.19	177.06	177.16	72580.0
2018-07-12 08:00:00	QQQ	ETF	177.1299	177.37	176.42	177.29	179439.0
2018-07-12 09:00:00	QQQ	ETF	177.329	177.815	177.08	177.775	2488432.0
2018-07-12 10:00:00	QQQ	ETF	177.77	178.455	177.76	178.14	3523318.0
2018-07-12 11:00:00	QQQ	ETF	178.15	178.88	178.145	178.85	2857117.0
2018-07-12 12:00:00	QQQ	ETF	178.85	179.0	178.61	178.94	2684813.0
2018-07-12 13:00:00	QQQ	ETF	178.94	179.17	178.8	178.8403	1827274.0
2018-07-12 14:00:00	QQQ	ETF	178.8445	179.17	178.72	179.13	1523571.0
2018-07-12 15:00:00	QQQ	ETF	179.13	179.44	178.85	179.37	5165930.0
2018-07-12 16:00:00	QQQ	ETF	179.365	179.46	179.1	179.34	1567345.0
2018-07-12 17:00:00	QQQ	ETF	179.28	179.37	179.28	179.33	24519.0
2018-07-12 18:00:00	QQQ	ETF	179.33	179.44	179.28	179.35	19673.0
2018-07-12 19:00:00	QQQ	ETF	179.45	179.7	179.45	179.65	40583.0
2018-07-12 05:00:00	IWM	ETF	167.89	167.89	167.85	167.85	1200.0
2018-07-12 06:00:00	IWM	ETF	167.85	168.02	167.81	168.02	4958.0
2018-07-12 07:00:00	IWM	ETF	168.01	168.05	167.94	168.05	49944.0
2018-07-12 08:00:00	IWM	ETF	167.9599	168.19	167.93	168.14	38713.0
2018-07-12 09:00:00	IWM	ETF	168.14	168.15	166.64	167.165	2519383.0
2018-07-12 10:00:00	IWM	ETF	167.17	167.6	166.76	166.85	2875921.0
2018-07-12 11:00:00	IWM	ETF	166.86	167.35	166.75	167.1825	1956713.0
2018-07-12 12:00:00	IWM	ETF	167.19	168.19	167.0	168.15	2076200.0
2018-07-12 13:00:00	IWM	ETF	168.16	168.25	167.79	167.82	1747369.0
2018-07-12 14:00:00	IWM	ETF	167.825	167.975	167.63	167.795	1559212.0
2018-07-12 15:00:00	IWM	ETF	167.79	167.9	167.61	167.87	3146327.0
2018-07-12 16:00:00	IWM	ETF	167.92	167.92	167.66	167.71	1406304.0
2018-07-12 17:00:00	IWM	ETF	167.67	167.67	167.67	167.67	121.0
2018-07-12 18:00:00	IWM	ETF	167.72	167.92	167.7	167.75	4103.0
2018-07-12 19:00:00	IWM	ETF	167.75	168.0	167.74	167.87	10236.0
2018-07-12 04:00:00	DIA	ETF	247.66	248.06	247.66	248.06	211.0
2018-07-12 05:00:00	DIA	ETF	248.12	248.52	248.12	248.52	1800.0
2018-07-12 06:00:00	DIA	ETF	248.54	248.85	248.54	248.85	2400.0

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

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