PREVIEW / etf_1hour / 2018-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-08.parquet
  size:    328 KB
  rows:    10,689

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-08 04:00:00	SPY	ETF	266.89	267.5	266.72	267.08	85084.0
2018-02-08 05:00:00	SPY	ETF	266.92	266.92	266.02	266.02	112089.0
2018-02-08 06:00:00	SPY	ETF	266.0	266.39	265.55	265.92	114473.0
2018-02-08 07:00:00	SPY	ETF	265.85	267.25	265.85	267.04	952949.0
2018-02-08 08:00:00	SPY	ETF	267.04	268.27	265.89	268.09	982771.0
2018-02-08 09:00:00	SPY	ETF	268.07	268.45	266.1	266.95	15072446.0
2018-02-08 10:00:00	SPY	ETF	266.9401	267.54	264.31	264.91	23264660.0
2018-02-08 11:00:00	SPY	ETF	264.95	265.77	263.68	264.61	23555452.0
2018-02-08 12:00:00	SPY	ETF	264.59	265.02	261.16	262.21	25135294.0
2018-02-08 13:00:00	SPY	ETF	262.22	264.73	261.53	264.1717	30565839.0
2018-02-08 14:00:00	SPY	ETF	264.15	264.5	261.62	262.2099	20823508.0
2018-02-08 15:00:00	SPY	ETF	262.21	263.1	257.59	257.72	67848284.0
2018-02-08 16:00:00	SPY	ETF	257.72	265.8182	257.63	259.55	29913704.0
2018-02-08 17:00:00	SPY	ETF	259.43	259.55	257.63	259.29	2710470.0
2018-02-08 18:00:00	SPY	ETF	259.3	259.75	257.63	258.5	1007089.0
2018-02-08 19:00:00	SPY	ETF	258.73	260.34	258.62	259.72	223416.0
2018-02-08 04:00:00	QQQ	ETF	160.11	160.46	160.11	160.18	21743.0
2018-02-08 05:00:00	QQQ	ETF	160.09	160.09	159.57	159.63	54066.0
2018-02-08 06:00:00	QQQ	ETF	159.56	159.82	159.33	159.43	23361.0
2018-02-08 07:00:00	QQQ	ETF	159.49	160.45	159.49	160.29	147155.0
2018-02-08 08:00:00	QQQ	ETF	160.11	161.17	159.69	160.74	485527.0
2018-02-08 09:00:00	QQQ	ETF	160.83	161.06	159.4	159.93	6267686.0
2018-02-08 10:00:00	QQQ	ETF	159.9067	160.36	157.62	158.19	12737093.0
2018-02-08 11:00:00	QQQ	ETF	158.21	158.84	157.26	158.2	9453906.0
2018-02-08 12:00:00	QQQ	ETF	158.19	158.53	155.58	156.32	10207372.0
2018-02-08 13:00:00	QQQ	ETF	156.33	158.14	155.95	157.8086	9427137.0
2018-02-08 14:00:00	QQQ	ETF	157.79	158.0	155.98	156.36	6896588.0
2018-02-08 15:00:00	QQQ	ETF	156.39	156.98	153.47	153.47	18750081.0
2018-02-08 16:00:00	QQQ	ETF	153.51	156.1033	153.45	154.32	3452825.0
2018-02-08 17:00:00	QQQ	ETF	154.4	154.45	154.24	154.38	103681.0
2018-02-08 18:00:00	QQQ	ETF	154.23	154.45	153.43	153.75	464884.0
2018-02-08 19:00:00	QQQ	ETF	153.75	154.82	153.7	154.59	86948.0
2018-02-08 04:00:00	IWM	ETF	149.02	149.37	149.02	149.29	4499.0
2018-02-08 05:00:00	IWM	ETF	149.01	149.01	148.54	148.54	6400.0
2018-02-08 06:00:00	IWM	ETF	148.45	148.75	148.45	148.5	6549.0
2018-02-08 07:00:00	IWM	ETF	148.69	149.41	148.56	149.37	56234.0
2018-02-08 08:00:00	IWM	ETF	149.34	150.07	149.21	149.91	176336.0
2018-02-08 09:00:00	IWM	ETF	149.99	150.25	148.78	149.5	3358465.0
2018-02-08 10:00:00	IWM	ETF	149.48	149.81	148.18	148.41	5933084.0
2018-02-08 11:00:00	IWM	ETF	148.41	148.77	147.73	148.24	4913462.0
2018-02-08 12:00:00	IWM	ETF	148.24	148.395	146.55	147.09	3549269.0
2018-02-08 13:00:00	IWM	ETF	147.0697	148.51	146.72	148.11	3970439.0
2018-02-08 14:00:00	IWM	ETF	148.1	148.1426	147.019	147.34	3811447.0
2018-02-08 15:00:00	IWM	ETF	147.36	147.57	145.44	145.45	10145235.0
2018-02-08 16:00:00	IWM	ETF	145.45	146.11	145.29	145.75	2018116.0
2018-02-08 17:00:00	IWM	ETF	145.7	145.88	145.44	145.88	74717.0
2018-02-08 18:00:00	IWM	ETF	145.66	145.99	145.25	145.39	660105.0
2018-02-08 19:00:00	IWM	ETF	145.61	146.52	145.61	146.06	57531.0
2018-02-08 06:00:00	DIA	ETF	247.0	247.24	247.0	247.2	300.0
2018-02-08 07:00:00	DIA	ETF	247.8	248.3	247.72	248.03	6900.0

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

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