PREVIEW / etf_1hour / 2019-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-31.parquet
  size:    333 KB
  rows:    10,990

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
2019-05-31 04:00:00	SPY	ETF	276.51	276.71	276.25	276.25	81098.0
2019-05-31 05:00:00	SPY	ETF	276.3	276.45	275.62	275.73	134282.0
2019-05-31 06:00:00	SPY	ETF	275.8	276.04	275.57	276.04	134528.0
2019-05-31 07:00:00	SPY	ETF	276.09	276.4	275.9	276.1	490279.0
2019-05-31 08:00:00	SPY	ETF	276.06	277.49	275.87	276.28	746537.0
2019-05-31 09:00:00	SPY	ETF	276.27	279.03	275.29	275.88	11398974.0
2019-05-31 10:00:00	SPY	ETF	275.87	276.58	275.51	276.335	10517955.0
2019-05-31 11:00:00	SPY	ETF	276.34	277.12	276.19	276.73	7045928.0
2019-05-31 12:00:00	SPY	ETF	276.7234	276.77	275.82	275.98	4997453.0
2019-05-31 13:00:00	SPY	ETF	275.99	276.66	275.88	276.52	4898538.0
2019-05-31 14:00:00	SPY	ETF	276.51	276.62	275.36	276.02	10942604.0
2019-05-31 15:00:00	SPY	ETF	276.02	276.07	275.24	275.37	20594220.0
2019-05-31 16:00:00	SPY	ETF	275.36	279.0922	275.18	275.43	11810503.0
2019-05-31 17:00:00	SPY	ETF	275.27	275.63	275.27	275.4	716000.0
2019-05-31 18:00:00	SPY	ETF	275.4	275.4	275.27	275.29	92358.0
2019-05-31 19:00:00	SPY	ETF	275.3	275.31	274.95	275.3	48158.0
2019-05-31 04:00:00	QQQ	ETF	174.7	174.82	174.5	174.57	57224.0
2019-05-31 05:00:00	QQQ	ETF	174.57	174.71	173.98	174.18	62115.0
2019-05-31 06:00:00	QQQ	ETF	174.11	174.4	174.0	174.33	70233.0
2019-05-31 07:00:00	QQQ	ETF	174.39	174.65	174.32	174.49	187807.0
2019-05-31 08:00:00	QQQ	ETF	174.46	175.35	174.27	174.63	439656.0
2019-05-31 09:00:00	QQQ	ETF	174.65	174.84	173.93	174.35	6271453.0
2019-05-31 10:00:00	QQQ	ETF	174.36	175.11	174.2	174.97	5107413.0
2019-05-31 11:00:00	QQQ	ETF	174.9899	175.29	174.79	174.97	3551499.0
2019-05-31 12:00:00	QQQ	ETF	174.93	175.01	174.335	174.5128	2961512.0
2019-05-31 13:00:00	QQQ	ETF	174.52	175.05	174.44	174.94	2270752.0
2019-05-31 14:00:00	QQQ	ETF	174.95	175.0162	174.14	174.43	4072105.0
2019-05-31 15:00:00	QQQ	ETF	174.43	174.47	173.88	173.9	9839088.0
2019-05-31 16:00:00	QQQ	ETF	173.9	174.9	173.85	174.03	3465286.0
2019-05-31 17:00:00	QQQ	ETF	174.06	174.09	173.95	174.02	546922.0
2019-05-31 18:00:00	QQQ	ETF	173.98	173.99	173.89	173.89	58690.0
2019-05-31 19:00:00	QQQ	ETF	173.94	174.0	173.89	174.0	34984.0
2019-05-31 04:00:00	IWM	ETF	146.41	146.46	146.35	146.35	5200.0
2019-05-31 05:00:00	IWM	ETF	146.14	146.14	145.96	145.96	6600.0
2019-05-31 06:00:00	IWM	ETF	146.04	146.04	145.92	145.99	15176.0
2019-05-31 07:00:00	IWM	ETF	146.15	146.32	146.15	146.2	54518.0
2019-05-31 08:00:00	IWM	ETF	146.31	146.35	145.95	146.31	265814.0
2019-05-31 09:00:00	IWM	ETF	146.26	146.34	145.32	145.77	2986688.0
2019-05-31 10:00:00	IWM	ETF	145.76	146.52	145.38	146.44	3280831.0
2019-05-31 11:00:00	IWM	ETF	146.43	146.84	146.24	146.7	1522460.0
2019-05-31 12:00:00	IWM	ETF	146.69	146.71	145.77	145.91	1418288.0
2019-05-31 13:00:00	IWM	ETF	145.92	146.53	145.895	146.37	1146773.0
2019-05-31 14:00:00	IWM	ETF	146.375	146.44	145.7	146.0067	2184012.0
2019-05-31 15:00:00	IWM	ETF	146.0	146.08	145.62	145.96	5118981.0
2019-05-31 16:00:00	IWM	ETF	145.98	146.05	145.82	145.97	3956941.0
2019-05-31 17:00:00	IWM	ETF	145.91	146.0	145.86	145.86	1105895.0
2019-05-31 18:00:00	IWM	ETF	145.91	145.95	145.91	145.93	3950.0
2019-05-31 19:00:00	IWM	ETF	145.86	145.93	145.86	145.93	76045.0
2019-05-31 04:00:00	DIA	ETF	249.0	249.0	249.0	249.0	800.0
2019-05-31 05:00:00	DIA	ETF	249.41	249.41	249.16	249.16	1900.0

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

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