PREVIEW / etf_1hour / 2019-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-11.parquet
  size:    327 KB
  rows:    10,776

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-11 04:00:00	SPY	ETF	299.26	299.36	299.24	299.24	1800.0
2019-07-11 05:00:00	SPY	ETF	299.21	299.61	299.18	299.55	29967.0
2019-07-11 06:00:00	SPY	ETF	299.55	299.56	299.12	299.48	36203.0
2019-07-11 07:00:00	SPY	ETF	299.47	299.52	299.26	299.35	106839.0
2019-07-11 08:00:00	SPY	ETF	299.37	299.54	298.91	299.22	399819.0
2019-07-11 09:00:00	SPY	ETF	299.19	299.58	299.01	299.285	5025499.0
2019-07-11 10:00:00	SPY	ETF	299.3	299.46	298.52	298.79	6632188.0
2019-07-11 11:00:00	SPY	ETF	298.78	299.4999	298.7	299.44	5666521.0
2019-07-11 12:00:00	SPY	ETF	299.445	299.52	299.19	299.34	6040187.0
2019-07-11 13:00:00	SPY	ETF	299.35	299.38	298.29	298.4965	8727718.0
2019-07-11 14:00:00	SPY	ETF	298.49	298.84	298.2	298.7947	4271986.0
2019-07-11 15:00:00	SPY	ETF	298.795	299.33	298.71	299.3	9456553.0
2019-07-11 16:00:00	SPY	ETF	299.29	299.46	299.24	299.35	3676318.0
2019-07-11 17:00:00	SPY	ETF	299.35	299.37	299.15	299.25	172826.0
2019-07-11 18:00:00	SPY	ETF	299.26	299.38	299.21	299.27	67771.0
2019-07-11 19:00:00	SPY	ETF	299.25	299.52	299.17	299.48	49477.0
2019-07-11 04:00:00	QQQ	ETF	193.06	193.15	193.04	193.09	8235.0
2019-07-11 05:00:00	QQQ	ETF	193.05	193.41	193.05	193.4	29241.0
2019-07-11 06:00:00	QQQ	ETF	193.36	193.36	192.98	193.24	27275.0
2019-07-11 07:00:00	QQQ	ETF	193.23	193.3	192.98	193.12	66488.0
2019-07-11 08:00:00	QQQ	ETF	193.24	193.38	192.56	192.91	274105.0
2019-07-11 09:00:00	QQQ	ETF	192.868	193.14	192.67	193.06	2190480.0
2019-07-11 10:00:00	QQQ	ETF	193.08	193.26	192.46	192.78	3182056.0
2019-07-11 11:00:00	QQQ	ETF	192.77	193.28	192.7	193.22	2086640.0
2019-07-11 12:00:00	QQQ	ETF	193.23	193.34	192.97	193.12	1226713.0
2019-07-11 13:00:00	QQQ	ETF	193.12	193.16	192.01	192.2239	3826918.0
2019-07-11 14:00:00	QQQ	ETF	192.22	192.34	191.81	192.276	2591351.0
2019-07-11 15:00:00	QQQ	ETF	192.28	192.58	192.08	192.4	3555100.0
2019-07-11 16:00:00	QQQ	ETF	192.41	192.75	192.32	192.38	2696502.0
2019-07-11 17:00:00	QQQ	ETF	192.42	192.42	192.35	192.35	7632.0
2019-07-11 18:00:00	QQQ	ETF	192.35	192.41	192.26	192.3	24444.0
2019-07-11 19:00:00	QQQ	ETF	192.3	192.48	192.23	192.45	34842.0
2019-07-11 06:00:00	IWM	ETF	155.71	155.88	155.71	155.88	990.0
2019-07-11 07:00:00	IWM	ETF	155.95	155.95	155.9	155.94	34500.0
2019-07-11 08:00:00	IWM	ETF	155.9299	155.99	155.65	155.86	80515.0
2019-07-11 09:00:00	IWM	ETF	155.86	156.07	155.14	155.1415	1764293.0
2019-07-11 10:00:00	IWM	ETF	155.15	155.285	154.215	154.37	2893904.0
2019-07-11 11:00:00	IWM	ETF	154.36	155.15	154.255	155.08	1840871.0
2019-07-11 12:00:00	IWM	ETF	155.1	155.36	154.95	155.05	896990.0
2019-07-11 13:00:00	IWM	ETF	155.05	155.09	154.46	154.66	1750357.0
2019-07-11 14:00:00	IWM	ETF	154.67	154.765	154.34	154.59	1125829.0
2019-07-11 15:00:00	IWM	ETF	154.59	154.89	154.46	154.88	2114408.0
2019-07-11 16:00:00	IWM	ETF	154.87	154.92	154.44	154.86	881617.0
2019-07-11 17:00:00	IWM	ETF	154.82	154.91	154.71	154.86	9508.0
2019-07-11 18:00:00	IWM	ETF	154.86	154.86	154.82	154.86	4172.0
2019-07-11 19:00:00	IWM	ETF	154.76	154.93	154.76	154.93	17000.0
2019-07-11 05:00:00	DIA	ETF	269.48	269.51	269.48	269.51	2100.0
2019-07-11 06:00:00	DIA	ETF	269.51	269.51	269.3	269.3	1114.0
2019-07-11 07:00:00	DIA	ETF	269.6	269.62	269.6	269.61	1200.0
2019-07-11 08:00:00	DIA	ETF	269.57	269.86	269.31	269.6001	13860.0

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

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