PREVIEW / etf_1hour / 2019-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-14.parquet
  size:    316 KB
  rows:    10,561

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-01-14 04:00:00	SPY	ETF	257.04	257.09	256.6	256.67	36712.0
2019-01-14 05:00:00	SPY	ETF	256.59	256.67	256.11	256.39	24080.0
2019-01-14 06:00:00	SPY	ETF	256.4	256.7	256.22	256.7	61736.0
2019-01-14 07:00:00	SPY	ETF	256.72	257.05	256.58	256.71	358116.0
2019-01-14 08:00:00	SPY	ETF	256.6701	257.1	256.54	256.92	533250.0
2019-01-14 09:00:00	SPY	ETF	256.95	257.525	256.41	257.17	7182774.0
2019-01-14 10:00:00	SPY	ETF	257.185	258.11	257.0315	257.84	9267509.0
2019-01-14 11:00:00	SPY	ETF	257.85	258.0	257.17	257.59	5646139.0
2019-01-14 12:00:00	SPY	ETF	257.6	258.16	257.4401	257.85	5082149.0
2019-01-14 13:00:00	SPY	ETF	257.84	258.3	257.68	257.97	6036568.0
2019-01-14 14:00:00	SPY	ETF	257.97	258.22	257.48	258.14	5724817.0
2019-01-14 15:00:00	SPY	ETF	258.15	258.26	257.33	257.46	16187994.0
2019-01-14 16:00:00	SPY	ETF	257.46	257.64	257.05	257.51	12651237.0
2019-01-14 17:00:00	SPY	ETF	257.51	257.57	257.42	257.51	123489.0
2019-01-14 18:00:00	SPY	ETF	257.5	257.67	257.38	257.62	865728.0
2019-01-14 19:00:00	SPY	ETF	257.65	258.2	257.6426	258.09	93455.0
2019-01-14 04:00:00	QQQ	ETF	159.5	159.5	159.16	159.18	24864.0
2019-01-14 05:00:00	QQQ	ETF	159.18	159.24	158.71	158.85	30362.0
2019-01-14 06:00:00	QQQ	ETF	158.85	159.04	158.74	159.04	63814.0
2019-01-14 07:00:00	QQQ	ETF	159.08	159.28	158.96	159.11	190589.0
2019-01-14 08:00:00	QQQ	ETF	160.69	160.69	158.97	159.36	283465.0
2019-01-14 09:00:00	QQQ	ETF	159.38	159.38	158.59	158.85	4319764.0
2019-01-14 10:00:00	QQQ	ETF	158.87	159.91	158.7216	159.7664	4840439.0
2019-01-14 11:00:00	QQQ	ETF	159.77	159.93	159.35	159.645	2797320.0
2019-01-14 12:00:00	QQQ	ETF	159.6523	159.91	159.4823	159.69	1824309.0
2019-01-14 13:00:00	QQQ	ETF	159.68	159.96	159.53	159.73	1619626.0
2019-01-14 14:00:00	QQQ	ETF	159.71	159.82	159.3616	159.7616	2598888.0
2019-01-14 15:00:00	QQQ	ETF	159.77	159.88	159.12	159.3	5276868.0
2019-01-14 16:00:00	QQQ	ETF	159.3	159.31	159.03	159.25	1768191.0
2019-01-14 17:00:00	QQQ	ETF	159.15	159.23	159.11	159.1801	14115.0
2019-01-14 18:00:00	QQQ	ETF	159.16	159.29	159.09	159.29	25300.0
2019-01-14 19:00:00	QQQ	ETF	159.31	159.74	159.31	159.67	72112.0
2019-01-14 04:00:00	IWM	ETF	142.98	142.98	142.73	142.88	700.0
2019-01-14 05:00:00	IWM	ETF	142.62	142.62	142.4	142.46	3200.0
2019-01-14 06:00:00	IWM	ETF	142.45	142.62	142.44	142.62	8824.0
2019-01-14 07:00:00	IWM	ETF	142.63	142.85	142.63	142.8	24937.0
2019-01-14 08:00:00	IWM	ETF	142.65	142.91	142.65	142.8	153771.0
2019-01-14 09:00:00	IWM	ETF	142.81	143.16	142.46	142.83	2102613.0
2019-01-14 10:00:00	IWM	ETF	142.84	143.28	142.66	143.13	2434451.0
2019-01-14 11:00:00	IWM	ETF	143.12	143.23	142.09	142.45	4025915.0
2019-01-14 12:00:00	IWM	ETF	142.46	143.33	142.37	143.24	1787778.0
2019-01-14 13:00:00	IWM	ETF	143.24	143.44	143.0	143.29	1657701.0
2019-01-14 14:00:00	IWM	ETF	143.29	143.37	142.98	143.145	2129359.0
2019-01-14 15:00:00	IWM	ETF	143.14	143.225	142.28	142.28	6544175.0
2019-01-14 16:00:00	IWM	ETF	142.29	142.42	142.16	142.38	1316051.0
2019-01-14 17:00:00	IWM	ETF	142.39	142.39	142.25	142.25	1009315.0
2019-01-14 18:00:00	IWM	ETF	142.35	142.45	142.25	142.45	6800.0
2019-01-14 19:00:00	IWM	ETF	142.47	142.81	142.47	142.77	9090.0
2019-01-14 04:00:00	DIA	ETF	238.5	238.5	238.02	238.02	276.0
2019-01-14 06:00:00	DIA	ETF	237.56	237.72	237.56	237.72	600.0

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

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