PREVIEW / etf_1hour / 2019-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-23.parquet
  size:    328 KB
  rows:    10,792

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-07-23 04:00:00	SPY	ETF	298.45	298.8	298.45	298.8	19352.0
2019-07-23 05:00:00	SPY	ETF	298.75	298.76	298.7	298.74	8055.0
2019-07-23 06:00:00	SPY	ETF	298.75	298.98	298.75	298.9	29617.0
2019-07-23 07:00:00	SPY	ETF	298.9	299.08	298.85	298.91	74248.0
2019-07-23 08:00:00	SPY	ETF	298.8999	299.24	297.9	299.17	137065.0
2019-07-23 09:00:00	SPY	ETF	299.16	299.24	298.53	298.59	4341101.0
2019-07-23 10:00:00	SPY	ETF	298.59	298.99	298.26	298.83	4924230.0
2019-07-23 11:00:00	SPY	ETF	298.84	298.9085	298.31	298.4265	5446849.0
2019-07-23 12:00:00	SPY	ETF	298.44	298.89	298.22	298.84	3406631.0
2019-07-23 13:00:00	SPY	ETF	298.85	299.855	298.73	299.75	8023089.0
2019-07-23 14:00:00	SPY	ETF	299.74	299.88	299.44	299.8	4640656.0
2019-07-23 15:00:00	SPY	ETF	299.805	300.03	299.55	299.96	8769051.0
2019-07-23 16:00:00	SPY	ETF	299.96	300.09	299.28	299.52	3268539.0
2019-07-23 17:00:00	SPY	ETF	299.52	300.03	299.46	299.57	191572.0
2019-07-23 18:00:00	SPY	ETF	299.55	300.03	299.48	299.65	92241.0
2019-07-23 19:00:00	SPY	ETF	299.6	299.8	299.59	299.77	49245.0
2019-07-23 04:00:00	QQQ	ETF	192.96	193.24	192.96	193.22	56281.0
2019-07-23 05:00:00	QQQ	ETF	193.2	193.23	193.15	193.23	14649.0
2019-07-23 06:00:00	QQQ	ETF	193.23	193.49	193.23	193.38	12430.0
2019-07-23 07:00:00	QQQ	ETF	193.4	193.5	193.29	193.3	28828.0
2019-07-23 08:00:00	QQQ	ETF	193.39	193.63	192.78	193.5	172215.0
2019-07-23 09:00:00	QQQ	ETF	193.47	193.595	192.825	192.87	1811658.0
2019-07-23 10:00:00	QQQ	ETF	192.8768	193.17	192.41	193.02	2587254.0
2019-07-23 11:00:00	QQQ	ETF	193.015	193.13	192.45	192.58	1508030.0
2019-07-23 12:00:00	QQQ	ETF	192.5701	192.9	192.29	192.86	1145402.0
2019-07-23 13:00:00	QQQ	ETF	192.86	193.58	192.78	193.5	1855983.0
2019-07-23 14:00:00	QQQ	ETF	193.51	193.58	193.245	193.5204	1369701.0
2019-07-23 15:00:00	QQQ	ETF	193.5232	193.81	193.33	193.79	3094417.0
2019-07-23 16:00:00	QQQ	ETF	193.79	194.17	192.85	193.1	4799828.0
2019-07-23 17:00:00	QQQ	ETF	193.2	194.11	193.01	193.16	496748.0
2019-07-23 18:00:00	QQQ	ETF	193.25	193.34	193.14	193.32	59669.0
2019-07-23 19:00:00	QQQ	ETF	193.29	193.39	193.26	193.37	22954.0
2019-07-23 04:00:00	IWM	ETF	154.0	154.21	154.0	154.21	5140.0
2019-07-23 06:00:00	IWM	ETF	154.28	154.28	154.2	154.28	5300.0
2019-07-23 07:00:00	IWM	ETF	154.28	154.32	154.2	154.2	3500.0
2019-07-23 08:00:00	IWM	ETF	154.28	154.41	153.68	154.4	73803.0
2019-07-23 09:00:00	IWM	ETF	154.4	154.43	153.84	154.22	2285293.0
2019-07-23 10:00:00	IWM	ETF	154.21	154.36	153.75	153.875	2902728.0
2019-07-23 11:00:00	IWM	ETF	153.87	154.135	153.54	153.9	1371768.0
2019-07-23 12:00:00	IWM	ETF	153.91	154.32	153.8353	154.3	732315.0
2019-07-23 13:00:00	IWM	ETF	154.295	154.545	154.05	154.41	1063442.0
2019-07-23 14:00:00	IWM	ETF	154.415	154.51	154.25	154.49	614185.0
2019-07-23 15:00:00	IWM	ETF	154.4838	154.72	154.4124	154.71	2880581.0
2019-07-23 16:00:00	IWM	ETF	154.72	154.73	154.44	154.53	904373.0
2019-07-23 17:00:00	IWM	ETF	154.55	154.65	154.55	154.56	263008.0
2019-07-23 18:00:00	IWM	ETF	154.55	154.7	154.53	154.6	83419.0
2019-07-23 19:00:00	IWM	ETF	154.6	154.64	154.6	154.64	3668.0
2019-07-23 05:00:00	DIA	ETF	272.4	272.4	272.4	272.4	100.0
2019-07-23 06:00:00	DIA	ETF	272.5	272.68	272.5	272.68	1330.0
2019-07-23 07:00:00	DIA	ETF	272.818	272.818	272.7	272.7	470.0

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

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