PREVIEW / etf_1hour / 2019-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-15.parquet
  size:    326 KB
  rows:    10,882

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-15 04:00:00	SPY	ETF	301.16	301.25	300.95	300.95	3806.0
2019-07-15 05:00:00	SPY	ETF	300.87	301.0	300.62	300.79	9605.0
2019-07-15 06:00:00	SPY	ETF	300.83	301.05	300.82	300.94	16292.0
2019-07-15 07:00:00	SPY	ETF	300.97	301.2	300.96	301.15	112238.0
2019-07-15 08:00:00	SPY	ETF	301.08	301.26	300.65	301.1799	286504.0
2019-07-15 09:00:00	SPY	ETF	301.17	301.2101	300.42	300.59	4451928.0
2019-07-15 10:00:00	SPY	ETF	300.59	300.8465	300.37	300.69	4965355.0
2019-07-15 11:00:00	SPY	ETF	300.69	300.76	300.35	300.4	2928444.0
2019-07-15 12:00:00	SPY	ETF	300.4	300.47	300.19	300.31	2864912.0
2019-07-15 13:00:00	SPY	ETF	300.31	300.54	300.23	300.43	3916094.0
2019-07-15 14:00:00	SPY	ETF	300.435	300.78	300.43	300.62	2575241.0
2019-07-15 15:00:00	SPY	ETF	300.62	300.77	300.44	300.76	6096391.0
2019-07-15 16:00:00	SPY	ETF	300.77	300.85	300.61	300.72	4964740.0
2019-07-15 17:00:00	SPY	ETF	300.72	300.75	300.61	300.65	175647.0
2019-07-15 18:00:00	SPY	ETF	300.69	300.74	300.61	300.74	67007.0
2019-07-15 19:00:00	SPY	ETF	300.74	300.94	300.67	300.92	39658.0
2019-07-15 04:00:00	QQQ	ETF	193.58	193.85	193.45	193.67	8518.0
2019-07-15 05:00:00	QQQ	ETF	193.65	193.68	193.4	193.51	13569.0
2019-07-15 06:00:00	QQQ	ETF	193.49	193.64	193.49	193.64	6650.0
2019-07-15 07:00:00	QQQ	ETF	193.62	193.85	193.62	193.85	38196.0
2019-07-15 08:00:00	QQQ	ETF	193.64	194.01	193.46	193.97	182461.0
2019-07-15 09:00:00	QQQ	ETF	193.97	194.02	193.47	193.67	2090664.0
2019-07-15 10:00:00	QQQ	ETF	193.66	193.81	193.44	193.705	2166113.0
2019-07-15 11:00:00	QQQ	ETF	193.71	193.91	193.57	193.64	1729327.0
2019-07-15 12:00:00	QQQ	ETF	193.64	193.74	193.45	193.53	995866.0
2019-07-15 13:00:00	QQQ	ETF	193.53	193.83	193.48	193.785	912203.0
2019-07-15 14:00:00	QQQ	ETF	193.78	194.02	193.78	194.0065	1442008.0
2019-07-15 15:00:00	QQQ	ETF	194.008	194.19	193.91	194.1	3849347.0
2019-07-15 16:00:00	QQQ	ETF	194.1	194.15	193.65	193.97	1348719.0
2019-07-15 17:00:00	QQQ	ETF	193.99	194.09	193.99	194.0	22303.0
2019-07-15 18:00:00	QQQ	ETF	193.99	194.02	193.95	194.01	26033.0
2019-07-15 19:00:00	QQQ	ETF	194.03	194.28	194.0	194.24	30511.0
2019-07-15 04:00:00	IWM	ETF	156.42	156.45	156.42	156.45	900.0
2019-07-15 05:00:00	IWM	ETF	156.21	156.25	156.2	156.25	3000.0
2019-07-15 06:00:00	IWM	ETF	156.33	156.46	156.33	156.46	3843.0
2019-07-15 07:00:00	IWM	ETF	156.28	156.63	156.28	156.63	19403.0
2019-07-15 08:00:00	IWM	ETF	156.67	156.7	156.6	156.65	75531.0
2019-07-15 09:00:00	IWM	ETF	156.66	156.66	155.15	155.27	2528723.0
2019-07-15 10:00:00	IWM	ETF	155.29	155.62	155.1064	155.33	2441649.0
2019-07-15 11:00:00	IWM	ETF	155.33	155.46	154.85	155.05	1559709.0
2019-07-15 12:00:00	IWM	ETF	155.05	155.14	154.88	155.03	822564.0
2019-07-15 13:00:00	IWM	ETF	155.04	155.24	155.02	155.11	556643.0
2019-07-15 14:00:00	IWM	ETF	155.11	155.25	155.05	155.24	642103.0
2019-07-15 15:00:00	IWM	ETF	155.25	155.34	155.075	155.25	1580915.0
2019-07-15 16:00:00	IWM	ETF	155.25	155.37	155.1	155.26	835669.0
2019-07-15 17:00:00	IWM	ETF	155.32	155.32	155.32	155.32	200.0
2019-07-15 18:00:00	IWM	ETF	155.25	155.32	155.24	155.29	2450.0
2019-07-15 19:00:00	IWM	ETF	155.31	155.42	155.31	155.41	7205.0
2019-07-15 04:00:00	DIA	ETF	273.45	273.54	273.45	273.54	1100.0
2019-07-15 07:00:00	DIA	ETF	273.78	273.84	273.7	273.84	7853.0

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

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