PREVIEW / etf_1hour / 2018-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-02.parquet
  size:    313 KB
  rows:    10,261

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-04-02 04:00:00	SPY	ETF	262.68	263.0	262.68	262.77	9404.0
2018-04-02 05:00:00	SPY	ETF	262.74	262.92	262.73	262.92	6107.0
2018-04-02 06:00:00	SPY	ETF	262.94	263.1	262.92	263.0	12705.0
2018-04-02 07:00:00	SPY	ETF	262.8	262.83	262.19	262.4	185335.0
2018-04-02 08:00:00	SPY	ETF	262.46	263.23	262.31	262.8	524503.0
2018-04-02 09:00:00	SPY	ETF	262.78	263.13	261.49	261.77	9058253.0
2018-04-02 10:00:00	SPY	ETF	261.74	261.85	259.34	259.4	13699267.0
2018-04-02 11:00:00	SPY	ETF	259.41	259.42	256.63	257.37	26238877.0
2018-04-02 12:00:00	SPY	ETF	257.38	258.27	256.32	257.52	18122127.0
2018-04-02 13:00:00	SPY	ETF	257.52	257.84	255.4	255.4015	17235966.0
2018-04-02 14:00:00	SPY	ETF	255.4	256.33	254.67	256.16	26859395.0
2018-04-02 15:00:00	SPY	ETF	256.15	258.03	255.5	257.53	43734622.0
2018-04-02 16:00:00	SPY	ETF	257.51	257.85	256.89	257.85	26924548.0
2018-04-02 17:00:00	SPY	ETF	257.66	257.88	255.6003	257.62	447319.0
2018-04-02 18:00:00	SPY	ETF	257.62	257.89	256.99	257.46	996442.0
2018-04-02 19:00:00	SPY	ETF	257.46	257.87	257.33	257.87	108146.0
2018-04-02 04:00:00	QQQ	ETF	159.2	159.35	159.19	159.3	6090.0
2018-04-02 05:00:00	QQQ	ETF	159.16	159.36	159.13	159.33	11630.0
2018-04-02 06:00:00	QQQ	ETF	159.37	159.56	159.31	159.31	58054.0
2018-04-02 07:00:00	QQQ	ETF	159.27	159.27	158.66	158.9	107692.0
2018-04-02 08:00:00	QQQ	ETF	158.81	160.13	158.72	159.2	229788.0
2018-04-02 09:00:00	QQQ	ETF	159.21	159.74	157.93	158.2	5955761.0
2018-04-02 10:00:00	QQQ	ETF	158.19	158.2286	156.68	156.75	8887546.0
2018-04-02 11:00:00	QQQ	ETF	156.75	156.79	154.81	155.45	12373051.0
2018-04-02 12:00:00	QQQ	ETF	155.42	156.62	154.97	156.01	6929287.0
2018-04-02 13:00:00	QQQ	ETF	155.985	156.23	154.45	154.46	6577318.0
2018-04-02 14:00:00	QQQ	ETF	154.43	155.01	153.88	154.93	10440538.0
2018-04-02 15:00:00	QQQ	ETF	154.91	156.04	154.24	155.61	15392339.0
2018-04-02 16:00:00	QQQ	ETF	155.61	155.92	155.36	155.92	4656905.0
2018-04-02 17:00:00	QQQ	ETF	155.91	156.1637	155.65	155.73	76821.0
2018-04-02 18:00:00	QQQ	ETF	155.74	155.9	155.51	155.55	105759.0
2018-04-02 19:00:00	QQQ	ETF	155.61	155.93	155.45	155.85	77276.0
2018-04-02 06:00:00	IWM	ETF	151.69	151.69	151.69	151.69	241.0
2018-04-02 07:00:00	IWM	ETF	151.65	151.65	151.23	151.28	10694.0
2018-04-02 08:00:00	IWM	ETF	151.53	151.83	151.29	151.83	88310.0
2018-04-02 09:00:00	IWM	ETF	151.67	152.07	150.91	150.99	2143023.0
2018-04-02 10:00:00	IWM	ETF	150.99	151.0	149.19	149.24	3126776.0
2018-04-02 11:00:00	IWM	ETF	149.24	149.39	148.48	148.93	3878261.0
2018-04-02 12:00:00	IWM	ETF	148.93	149.5	148.11	149.2586	2719458.0
2018-04-02 13:00:00	IWM	ETF	149.25	149.44	147.7	147.7	3285299.0
2018-04-02 14:00:00	IWM	ETF	147.7	148.255	147.18	148.13	3451456.0
2018-04-02 15:00:00	IWM	ETF	148.13	148.8562	147.51	148.22	7492768.0
2018-04-02 16:00:00	IWM	ETF	148.25	148.48	147.92	148.48	3616456.0
2018-04-02 17:00:00	IWM	ETF	148.87	148.87	147.9212	148.23	3894.0
2018-04-02 18:00:00	IWM	ETF	148.25	148.5	148.2	148.28	17292.0
2018-04-02 19:00:00	IWM	ETF	148.22	148.49	148.22	148.46	4681.0
2018-04-02 04:00:00	DIA	ETF	240.66	240.74	240.66	240.74	300.0
2018-04-02 05:00:00	DIA	ETF	240.69	240.69	240.69	240.69	100.0
2018-04-02 06:00:00	DIA	ETF	240.9	240.9	240.9	240.9	145.0
2018-04-02 07:00:00	DIA	ETF	240.53	240.57	240.0	240.2	2531.0

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

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