PREVIEW / etf_1hour / 2018-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-14.parquet
  size:    321 KB
  rows:    10,661

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-12-14 04:00:00	SPY	ETF	262.24	262.35	261.8	262.1	83254.0
2018-12-14 05:00:00	SPY	ETF	262.15	262.74	262.15	262.6	148716.0
2018-12-14 06:00:00	SPY	ETF	262.62	262.95	262.51	262.8	206126.0
2018-12-14 07:00:00	SPY	ETF	262.83	263.05	262.48	262.82	384265.0
2018-12-14 08:00:00	SPY	ETF	263.4	263.4	262.02	263.08	757245.0
2018-12-14 09:00:00	SPY	ETF	263.12	263.84	262.57	263.66	11192774.0
2018-12-14 10:00:00	SPY	ETF	263.66	264.03	262.39	263.03	12827297.0
2018-12-14 11:00:00	SPY	ETF	263.04	263.53	261.05	261.24	16495283.0
2018-12-14 12:00:00	SPY	ETF	261.2266	262.4	261.1675	261.74	10696953.0
2018-12-14 13:00:00	SPY	ETF	261.73	262.25	260.84	261.11	9524836.0
2018-12-14 14:00:00	SPY	ETF	261.11	261.59	260.0	260.7388	14790712.0
2018-12-14 15:00:00	SPY	ETF	260.735	261.37	259.85	260.49	27592018.0
2018-12-14 16:00:00	SPY	ETF	260.5	260.82	260.04	260.11	9517550.0
2018-12-14 17:00:00	SPY	ETF	260.1	260.47	260.07	260.1	926946.0
2018-12-14 18:00:00	SPY	ETF	260.11	260.11	259.91	259.96	88521.0
2018-12-14 19:00:00	SPY	ETF	259.93	259.94	259.75	259.83	44279.0
2018-12-14 04:00:00	QQQ	ETF	162.81	162.83	162.27	162.5	62907.0
2018-12-14 05:00:00	QQQ	ETF	162.81	163.0	162.73	162.96	43583.0
2018-12-14 06:00:00	QQQ	ETF	163.09	163.26	162.91	163.18	29755.0
2018-12-14 07:00:00	QQQ	ETF	163.17	163.33	163.02	163.15	193261.0
2018-12-14 08:00:00	QQQ	ETF	163.0901	163.42	162.37	163.21	331925.0
2018-12-14 09:00:00	QQQ	ETF	163.26	163.43	162.37	163.24	4930879.0
2018-12-14 10:00:00	QQQ	ETF	163.22	163.81	162.75	163.37	5506292.0
2018-12-14 11:00:00	QQQ	ETF	163.37	163.78	162.06	162.2	6651204.0
2018-12-14 12:00:00	QQQ	ETF	162.19	162.9	162.08	162.39	4914346.0
2018-12-14 13:00:00	QQQ	ETF	162.39	162.77	161.66	161.88	4950460.0
2018-12-14 14:00:00	QQQ	ETF	161.88	162.18	160.94	161.49	6397433.0
2018-12-14 15:00:00	QQQ	ETF	161.5	161.86	160.7	160.92	10863458.0
2018-12-14 16:00:00	QQQ	ETF	160.92	161.3558	160.7	160.71	5353627.0
2018-12-14 17:00:00	QQQ	ETF	160.66	161.08	160.66	160.95	592257.0
2018-12-14 18:00:00	QQQ	ETF	160.94	160.97	160.84	160.92	14109.0
2018-12-14 19:00:00	QQQ	ETF	160.92	160.92	160.67	160.9	21362.0
2018-12-14 04:00:00	IWM	ETF	141.48	141.48	141.11	141.3	26402.0
2018-12-14 05:00:00	IWM	ETF	141.51	141.69	141.47	141.69	26575.0
2018-12-14 06:00:00	IWM	ETF	141.77	141.86	141.77	141.85	29975.0
2018-12-14 07:00:00	IWM	ETF	141.72	141.78	141.54	141.7	55850.0
2018-12-14 08:00:00	IWM	ETF	141.64	141.88	141.55	141.85	68012.0
2018-12-14 09:00:00	IWM	ETF	141.77	143.01	141.66	142.92	2839695.0
2018-12-14 10:00:00	IWM	ETF	142.92	143.23	142.26	142.48	2614229.0
2018-12-14 11:00:00	IWM	ETF	142.47	143.0	141.68	141.82	2888534.0
2018-12-14 12:00:00	IWM	ETF	141.8183	142.21	141.46	141.51	2641711.0
2018-12-14 13:00:00	IWM	ETF	141.5	141.88	141.27	141.36	1652968.0
2018-12-14 14:00:00	IWM	ETF	141.35	141.45	140.56	140.86	2469559.0
2018-12-14 15:00:00	IWM	ETF	140.87	141.12	140.095	140.61	4681751.0
2018-12-14 16:00:00	IWM	ETF	140.62	140.76	140.41	140.61	1821509.0
2018-12-14 17:00:00	IWM	ETF	140.5	140.65	140.5	140.65	25831.0
2018-12-14 18:00:00	IWM	ETF	140.5	140.5	140.48	140.48	2564.0
2018-12-14 19:00:00	IWM	ETF	140.4	140.49	140.35	140.49	822.0
2018-12-14 04:00:00	DIA	ETF	243.47	243.47	243.08	243.4	1025.0
2018-12-14 05:00:00	DIA	ETF	243.82	243.93	243.78	243.78	1000.0

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

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