PREVIEW / etf_1hour / 2019-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-22.parquet
  size:    326 KB
  rows:    10,833

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-04-22 04:00:00	SPY	ETF	289.53	289.53	289.33	289.33	2548.0
2019-04-22 05:00:00	SPY	ETF	289.34	289.35	289.29	289.35	3650.0
2019-04-22 06:00:00	SPY	ETF	289.37	289.54	289.37	289.42	17196.0
2019-04-22 07:00:00	SPY	ETF	289.45	289.49	289.36	289.43	116810.0
2019-04-22 08:00:00	SPY	ETF	289.45	289.71	289.06	289.12	354259.0
2019-04-22 09:00:00	SPY	ETF	289.11	289.9	289.07	289.87	4670224.0
2019-04-22 10:00:00	SPY	ETF	289.875	290.07	289.53	289.975	7604203.0
2019-04-22 11:00:00	SPY	ETF	289.98	290.23	289.69	290.08	3501101.0
2019-04-22 12:00:00	SPY	ETF	290.07	290.14	289.91	290.0899	1977087.0
2019-04-22 13:00:00	SPY	ETF	290.085	290.19	289.92	290.12	2524761.0
2019-04-22 14:00:00	SPY	ETF	290.13	290.18	289.96	290.05	2183641.0
2019-04-22 15:00:00	SPY	ETF	290.05	290.435	289.92	290.31	10733931.0
2019-04-22 16:00:00	SPY	ETF	290.3	290.63	290.15	290.47	4996200.0
2019-04-22 17:00:00	SPY	ETF	290.47	290.48	290.32	290.38	113042.0
2019-04-22 18:00:00	SPY	ETF	290.37	290.49	290.27	290.49	145344.0
2019-04-22 19:00:00	SPY	ETF	290.47	290.55	290.38	290.41	16046.0
2019-04-22 04:00:00	QQQ	ETF	186.9	186.9	186.79	186.8	33959.0
2019-04-22 05:00:00	QQQ	ETF	186.7	186.86	186.7	186.83	1694.0
2019-04-22 06:00:00	QQQ	ETF	186.94	186.99	186.92	186.95	11385.0
2019-04-22 07:00:00	QQQ	ETF	186.97	186.98	186.77	186.77	48219.0
2019-04-22 08:00:00	QQQ	ETF	186.93	187.3	186.41	186.48	182258.0
2019-04-22 09:00:00	QQQ	ETF	186.45	187.09	186.43	187.08	2475745.0
2019-04-22 10:00:00	QQQ	ETF	187.08	187.54	187.01	187.52	2502270.0
2019-04-22 11:00:00	QQQ	ETF	187.52	187.73	187.3	187.58	1323359.0
2019-04-22 12:00:00	QQQ	ETF	187.579	187.7	187.5001	187.57	645996.0
2019-04-22 13:00:00	QQQ	ETF	187.57	187.799	187.47	187.745	1296733.0
2019-04-22 14:00:00	QQQ	ETF	187.75	187.86	187.67	187.7717	1326570.0
2019-04-22 15:00:00	QQQ	ETF	187.7733	188.86	187.69	187.97	2732100.0
2019-04-22 16:00:00	QQQ	ETF	187.95	188.23	187.88	188.12	936790.0
2019-04-22 17:00:00	QQQ	ETF	188.18	188.18	187.92	188.12	25825.0
2019-04-22 18:00:00	QQQ	ETF	188.06	188.12	187.92	188.12	504453.0
2019-04-22 19:00:00	QQQ	ETF	188.13	188.19	187.92	188.1	487907.0
2019-04-22 06:00:00	IWM	ETF	155.42	155.42	155.42	155.42	1500.0
2019-04-22 07:00:00	IWM	ETF	155.32	155.35	155.28	155.35	5530.0
2019-04-22 08:00:00	IWM	ETF	155.36	155.36	155.2	155.25	15479.0
2019-04-22 09:00:00	IWM	ETF	155.25	155.81	155.25	155.7	1292342.0
2019-04-22 10:00:00	IWM	ETF	155.7	155.76	154.87	155.17	1688599.0
2019-04-22 11:00:00	IWM	ETF	155.15	155.26	154.73	154.9	1303686.0
2019-04-22 12:00:00	IWM	ETF	154.9	155.29	154.7623	155.14	865507.0
2019-04-22 13:00:00	IWM	ETF	155.14	155.33	154.95	155.025	649421.0
2019-04-22 14:00:00	IWM	ETF	155.025	155.04	154.68	154.75	1092645.0
2019-04-22 15:00:00	IWM	ETF	154.74	155.285	154.52	155.21	2819136.0
2019-04-22 16:00:00	IWM	ETF	155.21	155.741	155.18	155.28	4746266.0
2019-04-22 17:00:00	IWM	ETF	155.28	155.28	155.23	155.26	4459.0
2019-04-22 18:00:00	IWM	ETF	155.25	155.28	155.22	155.28	9600.0
2019-04-22 19:00:00	IWM	ETF	155.3	155.3	155.23	155.25	10650.0
2019-04-22 04:00:00	DIA	ETF	265.02	265.02	265.02	265.02	100.0
2019-04-22 07:00:00	DIA	ETF	265.0	265.04	264.9	264.94	1900.0
2019-04-22 08:00:00	DIA	ETF	265.03	265.03	264.62	264.62	16212.0
2019-04-22 09:00:00	DIA	ETF	264.72	265.18	264.44	264.943	372160.0

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

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