PREVIEW / etf_1hour / 2019-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-19.parquet
  size:    342 KB
  rows:    11,275

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-08-19 04:00:00	SPY	ETF	291.34	291.52	291.0	291.06	28588.0
2019-08-19 05:00:00	SPY	ETF	291.14	291.54	291.14	291.49	10524.0
2019-08-19 06:00:00	SPY	ETF	291.55	292.19	291.49	291.81	66019.0
2019-08-19 07:00:00	SPY	ETF	291.82	292.65	291.67	292.07	693171.0
2019-08-19 08:00:00	SPY	ETF	292.08	292.6299	290.46	292.13	565333.0
2019-08-19 09:00:00	SPY	ETF	292.14	292.465	291.77	292.02	6952697.0
2019-08-19 10:00:00	SPY	ETF	292.02	292.24	291.44	292.09	7392721.0
2019-08-19 11:00:00	SPY	ETF	292.08	292.71	292.08	292.37	5016912.0
2019-08-19 12:00:00	SPY	ETF	292.36	292.7	292.16	292.66	3756552.0
2019-08-19 13:00:00	SPY	ETF	292.67	293.08	292.57	292.65	4420681.0
2019-08-19 14:00:00	SPY	ETF	292.65	292.86	292.403	292.61	3987587.0
2019-08-19 15:00:00	SPY	ETF	292.62	292.91	292.21	292.32	14212773.0
2019-08-19 16:00:00	SPY	ETF	292.32	292.33	291.98	292.07	3759692.0
2019-08-19 17:00:00	SPY	ETF	292.06	292.33	291.96	291.96	103226.0
2019-08-19 18:00:00	SPY	ETF	291.98	292.2	291.85	292.1	63302.0
2019-08-19 19:00:00	SPY	ETF	292.12	292.15	291.64	291.76	45911.0
2019-08-19 04:00:00	QQQ	ETF	187.03	187.35	186.91	186.91	37096.0
2019-08-19 05:00:00	QQQ	ETF	187.05	187.4	186.97	187.4	37136.0
2019-08-19 06:00:00	QQQ	ETF	187.34	187.84	187.2	187.71	62588.0
2019-08-19 07:00:00	QQQ	ETF	187.6	188.13	187.42	187.87	307386.0
2019-08-19 08:00:00	QQQ	ETF	187.91	188.1099	185.48	187.98	244087.0
2019-08-19 09:00:00	QQQ	ETF	187.93	188.7	187.89	188.11	3409745.0
2019-08-19 10:00:00	QQQ	ETF	188.1089	188.33	187.5	188.23	2945636.0
2019-08-19 11:00:00	QQQ	ETF	188.21	188.74	188.2043	188.49	2168712.0
2019-08-19 12:00:00	QQQ	ETF	188.45	188.61	188.28	188.6	1391503.0
2019-08-19 13:00:00	QQQ	ETF	188.6	188.83	188.52	188.595	1693405.0
2019-08-19 14:00:00	QQQ	ETF	188.59	188.61	188.28	188.39	1900658.0
2019-08-19 15:00:00	QQQ	ETF	188.39	188.63	188.18	188.3	3978957.0
2019-08-19 16:00:00	QQQ	ETF	188.29	188.43	187.99	188.12	1301549.0
2019-08-19 17:00:00	QQQ	ETF	188.12	188.22	188.06	188.13	17916.0
2019-08-19 18:00:00	QQQ	ETF	188.07	188.2	187.98	188.2	61125.0
2019-08-19 19:00:00	QQQ	ETF	188.15	188.17	187.77	187.9	30762.0
2019-08-19 04:00:00	IWM	ETF	149.79	149.9	149.71	149.89	6790.0
2019-08-19 06:00:00	IWM	ETF	149.98	150.16	149.98	150.16	3000.0
2019-08-19 07:00:00	IWM	ETF	150.03	150.69	150.03	150.28	140494.0
2019-08-19 08:00:00	IWM	ETF	150.1	150.37	149.58	150.19	54534.0
2019-08-19 09:00:00	IWM	ETF	150.15	150.55	150.0	150.16	2181788.0
2019-08-19 10:00:00	IWM	ETF	150.16	150.66	149.95	150.56	2157542.0
2019-08-19 11:00:00	IWM	ETF	150.56	150.75	150.35	150.46	1109926.0
2019-08-19 12:00:00	IWM	ETF	150.45	150.744	150.39	150.67	628567.0
2019-08-19 13:00:00	IWM	ETF	150.67	150.89	150.56	150.6	852095.0
2019-08-19 14:00:00	IWM	ETF	150.59	150.62	150.38	150.525	1296627.0
2019-08-19 15:00:00	IWM	ETF	150.53	150.62	150.05	150.16	2977825.0
2019-08-19 16:00:00	IWM	ETF	150.16	150.18	149.9	149.97	1032814.0
2019-08-19 17:00:00	IWM	ETF	150.04	150.13	149.87	149.91	39054.0
2019-08-19 18:00:00	IWM	ETF	149.95	150.0	149.9	149.99	3000.0
2019-08-19 19:00:00	IWM	ETF	149.96	149.96	149.71	149.77	6007.0
2019-08-19 04:00:00	DIA	ETF	260.87	261.36	260.87	261.36	800.0
2019-08-19 06:00:00	DIA	ETF	261.5	261.56	261.5	261.56	900.0
2019-08-19 07:00:00	DIA	ETF	261.26	262.22	261.26	261.9	24767.0

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

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