PREVIEW / etf_1hour / 2019-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-27.parquet
  size:    317 KB
  rows:    10,626

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-06-27 04:00:00	SPY	ETF	291.79	291.83	291.54	291.63	14602.0
2019-06-27 05:00:00	SPY	ETF	291.61	292.26	290.98	291.02	57681.0
2019-06-27 06:00:00	SPY	ETF	291.04	291.11	290.45	291.08	47011.0
2019-06-27 07:00:00	SPY	ETF	291.03	291.12	290.7	290.92	143433.0
2019-06-27 08:00:00	SPY	ETF	291.0199	292.0	290.82	291.32	293341.0
2019-06-27 09:00:00	SPY	ETF	291.32	291.96	291.19	291.78	4842636.0
2019-06-27 10:00:00	SPY	ETF	291.79	291.86	291.26	291.54	4330584.0
2019-06-27 11:00:00	SPY	ETF	291.53	291.69	290.89	291.36	6503212.0
2019-06-27 12:00:00	SPY	ETF	291.36	291.9	291.25	291.72	3424386.0
2019-06-27 13:00:00	SPY	ETF	291.72	292.06	291.71	291.87	2698076.0
2019-06-27 14:00:00	SPY	ETF	291.87	292.05	291.63	291.68	3632073.0
2019-06-27 15:00:00	SPY	ETF	291.6733	291.93	291.47	291.54	8108677.0
2019-06-27 16:00:00	SPY	ETF	291.54	292.09	291.5	292.05	5151605.0
2019-06-27 17:00:00	SPY	ETF	292.06	292.17	291.5	292.1	157344.0
2019-06-27 18:00:00	SPY	ETF	292.06	292.42	292.06	292.31	80736.0
2019-06-27 19:00:00	SPY	ETF	292.29	292.33	292.0	292.31	83606.0
2019-06-27 04:00:00	QQQ	ETF	186.86	186.92	186.59	186.68	65476.0
2019-06-27 05:00:00	QQQ	ETF	186.67	187.2	186.24	186.39	48518.0
2019-06-27 06:00:00	QQQ	ETF	186.33	186.33	185.73	186.18	59096.0
2019-06-27 07:00:00	QQQ	ETF	186.18	186.29	185.89	186.19	268794.0
2019-06-27 08:00:00	QQQ	ETF	186.23	186.86	186.0601	186.67	206261.0
2019-06-27 09:00:00	QQQ	ETF	186.66	186.94	186.31	186.722	2489746.0
2019-06-27 10:00:00	QQQ	ETF	186.73	186.89	186.35	186.63	2424970.0
2019-06-27 11:00:00	QQQ	ETF	186.63	186.7631	185.99	186.28	2707886.0
2019-06-27 12:00:00	QQQ	ETF	186.28	186.8199	186.2	186.62	1269269.0
2019-06-27 13:00:00	QQQ	ETF	186.61	186.83	186.57	186.7	713076.0
2019-06-27 14:00:00	QQQ	ETF	186.7	186.91	186.57	186.6	1226227.0
2019-06-27 15:00:00	QQQ	ETF	186.6	186.73	186.48	186.5	2996697.0
2019-06-27 16:00:00	QQQ	ETF	186.49	186.76	186.45	186.55	1101801.0
2019-06-27 17:00:00	QQQ	ETF	186.66	186.7	186.56	186.64	17165.0
2019-06-27 18:00:00	QQQ	ETF	186.6	186.83	186.57	186.78	10553.0
2019-06-27 19:00:00	QQQ	ETF	186.77	186.77	186.6	186.77	10229.0
2019-06-27 04:00:00	IWM	ETF	151.41	151.6	151.39	151.39	2100.0
2019-06-27 05:00:00	IWM	ETF	151.44	151.64	151.12	151.12	21629.0
2019-06-27 06:00:00	IWM	ETF	151.1	151.1	150.75	150.99	16990.0
2019-06-27 07:00:00	IWM	ETF	151.09	151.1	150.95	151.01	13960.0
2019-06-27 08:00:00	IWM	ETF	151.02	151.25	150.8	151.22	243409.0
2019-06-27 09:00:00	IWM	ETF	151.25	152.35	151.24	152.2485	2300658.0
2019-06-27 10:00:00	IWM	ETF	152.25	152.62	152.01	152.4703	2270528.0
2019-06-27 11:00:00	IWM	ETF	152.47	152.56	151.87	152.305	1947433.0
2019-06-27 12:00:00	IWM	ETF	152.31	152.773	152.275	152.72	1286286.0
2019-06-27 13:00:00	IWM	ETF	152.72	153.03	152.71	152.915	986240.0
2019-06-27 14:00:00	IWM	ETF	152.91	153.3299	152.87	153.01	2150278.0
2019-06-27 15:00:00	IWM	ETF	153.01	153.77	152.97	153.7	6058679.0
2019-06-27 16:00:00	IWM	ETF	153.69	153.82	151.2924	153.74	1432305.0
2019-06-27 17:00:00	IWM	ETF	153.76	153.76	153.6	153.63	407894.0
2019-06-27 18:00:00	IWM	ETF	153.72	154.0	153.72	153.81	31669.0
2019-06-27 19:00:00	IWM	ETF	153.8199	153.8199	153.7	153.7	3400.0
2019-06-27 04:00:00	DIA	ETF	266.02	266.02	266.02	266.02	100.0
2019-06-27 05:00:00	DIA	ETF	265.88	266.3	265.42	265.42	1588.0

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

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