PREVIEW / etf_1hour / 2019-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-01.parquet
  size:    348 KB
  rows:    11,448

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-01 04:00:00	SPY	ETF	296.1	296.53	296.1	296.32	36611.0
2019-07-01 05:00:00	SPY	ETF	296.3	296.45	296.1	296.29	14644.0
2019-07-01 06:00:00	SPY	ETF	296.4	296.67	296.4	296.42	66565.0
2019-07-01 07:00:00	SPY	ETF	296.4	296.52	296.25	296.44	166675.0
2019-07-01 08:00:00	SPY	ETF	296.45	296.7	295.73	296.49	633212.0
2019-07-01 09:00:00	SPY	ETF	296.46	296.92	296.0001	296.1533	9716516.0
2019-07-01 10:00:00	SPY	ETF	296.16	296.51	295.47	295.73	12635954.0
2019-07-01 11:00:00	SPY	ETF	295.74	295.93	295.28	295.44	6738419.0
2019-07-01 12:00:00	SPY	ETF	295.435	295.59	294.63	294.7	5202329.0
2019-07-01 13:00:00	SPY	ETF	294.69	294.99	294.48	294.87	6358472.0
2019-07-01 14:00:00	SPY	ETF	294.88	294.91	294.33	294.39	4457217.0
2019-07-01 15:00:00	SPY	ETF	294.39	295.77	294.3636	295.61	16180600.0
2019-07-01 16:00:00	SPY	ETF	295.6	295.66	295.4	295.57	10985781.0
2019-07-01 17:00:00	SPY	ETF	295.58	295.66	295.4	295.57	3579011.0
2019-07-01 18:00:00	SPY	ETF	295.65	295.66	294.81	295.19	333613.0
2019-07-01 19:00:00	SPY	ETF	295.14	295.24	295.03	295.22	28198.0
2019-07-01 04:00:00	QQQ	ETF	189.45	190.02	188.4	189.92	46001.0
2019-07-01 05:00:00	QQQ	ETF	189.93	190.03	189.77	190.0	13500.0
2019-07-01 06:00:00	QQQ	ETF	189.99	190.17	189.93	190.05	46275.0
2019-07-01 07:00:00	QQQ	ETF	190.04	190.15	189.88	190.09	319089.0
2019-07-01 08:00:00	QQQ	ETF	189.96	190.33	189.22	190.1099	232345.0
2019-07-01 09:00:00	QQQ	ETF	190.15	190.5699	189.78	189.95	6203360.0
2019-07-01 10:00:00	QQQ	ETF	189.95	190.38	189.24	189.48	4262083.0
2019-07-01 11:00:00	QQQ	ETF	189.5	189.63	189.2	189.35	2083032.0
2019-07-01 12:00:00	QQQ	ETF	189.34	189.47	188.52	188.5796	2022025.0
2019-07-01 13:00:00	QQQ	ETF	188.59	188.91	188.53	188.87	2792931.0
2019-07-01 14:00:00	QQQ	ETF	188.8801	188.9	188.38	188.47	2275757.0
2019-07-01 15:00:00	QQQ	ETF	188.47	189.37	188.44	189.23	6053841.0
2019-07-01 16:00:00	QQQ	ETF	189.23	189.29	189.08	189.23	1619415.0
2019-07-01 17:00:00	QQQ	ETF	189.12	189.23	189.12	189.18	9763.0
2019-07-01 18:00:00	QQQ	ETF	189.22	189.22	188.6	188.88	60542.0
2019-07-01 19:00:00	QQQ	ETF	188.85	188.9	188.77	188.87	36860.0
2019-07-01 04:00:00	IWM	ETF	156.91	157.23	156.91	157.06	14200.0
2019-07-01 05:00:00	IWM	ETF	157.05	157.08	156.97	156.97	3125.0
2019-07-01 06:00:00	IWM	ETF	157.27	157.27	157.19	157.19	1500.0
2019-07-01 07:00:00	IWM	ETF	157.13	157.32	157.1	157.32	25010.0
2019-07-01 08:00:00	IWM	ETF	157.31	157.44	157.13	157.25	124977.0
2019-07-01 09:00:00	IWM	ETF	157.25	158.03	156.62	156.7	4003490.0
2019-07-01 10:00:00	IWM	ETF	156.75	157.0	156.1952	156.26	3693672.0
2019-07-01 11:00:00	IWM	ETF	156.27	156.34	155.8	156.12	1836841.0
2019-07-01 12:00:00	IWM	ETF	156.13	156.355	155.75	155.78	1321019.0
2019-07-01 13:00:00	IWM	ETF	155.78	155.93	155.61	155.76	2118210.0
2019-07-01 14:00:00	IWM	ETF	155.77	155.79	155.22	155.34	1786625.0
2019-07-01 15:00:00	IWM	ETF	155.32	156.12	155.31	156.12	4084341.0
2019-07-01 16:00:00	IWM	ETF	156.1	156.22	155.87	156.22	932573.0
2019-07-01 17:00:00	IWM	ETF	156.13	156.16	156.1	156.16	421738.0
2019-07-01 18:00:00	IWM	ETF	156.15	156.2	155.77	155.95	97023.0
2019-07-01 19:00:00	IWM	ETF	155.92	156.0333	155.91	155.99	176916.0
2019-07-01 04:00:00	DIA	ETF	268.54	268.58	268.47	268.5	5800.0
2019-07-01 05:00:00	DIA	ETF	268.6	268.6	268.58	268.58	700.0

> showing 50 of 11,448 rows — these rows as CSV

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