PREVIEW / etf_1hour / 2019-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-18.parquet
  size:    334 KB
  rows:    11,021

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-18 04:00:00	SPY	ETF	289.22	290.7	289.14	290.33	27247.0
2019-06-18 05:00:00	SPY	ETF	290.48	290.56	290.23	290.33	20539.0
2019-06-18 06:00:00	SPY	ETF	290.36	291.18	290.33	291.07	91708.0
2019-06-18 07:00:00	SPY	ETF	291.05	291.47	290.93	291.37	410635.0
2019-06-18 08:00:00	SPY	ETF	291.35	291.55	289.0	291.34	931064.0
2019-06-18 09:00:00	SPY	ETF	291.32	293.2	290.99	292.75	15894033.0
2019-06-18 10:00:00	SPY	ETF	292.76	293.49	292.57	293.34	12424527.0
2019-06-18 11:00:00	SPY	ETF	293.34	293.57	292.32	292.325	11850335.0
2019-06-18 12:00:00	SPY	ETF	292.32	292.72	292.195	292.52	6835476.0
2019-06-18 13:00:00	SPY	ETF	292.51	292.51	291.89	292.43	6323075.0
2019-06-18 14:00:00	SPY	ETF	292.43	292.82	292.4	292.48	7411122.0
2019-06-18 15:00:00	SPY	ETF	292.485	292.59	291.93	292.29	15112624.0
2019-06-18 16:00:00	SPY	ETF	292.3	292.7	292.2314	292.53	5428095.0
2019-06-18 17:00:00	SPY	ETF	292.59	292.61	292.4	292.52	77533.0
2019-06-18 18:00:00	SPY	ETF	292.52	292.69	292.36	292.65	156497.0
2019-06-18 19:00:00	SPY	ETF	292.65	292.9	292.63	292.82	131899.0
2019-06-18 04:00:00	QQQ	ETF	183.57	185.13	183.54	184.76	43280.0
2019-06-18 05:00:00	QQQ	ETF	184.83	184.94	184.75	184.81	38889.0
2019-06-18 06:00:00	QQQ	ETF	184.87	185.73	184.76	185.59	77917.0
2019-06-18 07:00:00	QQQ	ETF	185.56	185.79	185.33	185.74	381360.0
2019-06-18 08:00:00	QQQ	ETF	185.49	186.0	183.54	185.85	413908.0
2019-06-18 09:00:00	QQQ	ETF	185.85	187.42	185.4291	187.06	9383551.0
2019-06-18 10:00:00	QQQ	ETF	187.06	187.72	187.0	187.5415	6402030.0
2019-06-18 11:00:00	QQQ	ETF	187.545	187.69	186.64	186.67	4176948.0
2019-06-18 12:00:00	QQQ	ETF	186.66	186.95	186.55	186.72	3139052.0
2019-06-18 13:00:00	QQQ	ETF	186.715	186.715	186.22	186.67	2229851.0
2019-06-18 14:00:00	QQQ	ETF	186.68	187.09	186.63	186.69	3172282.0
2019-06-18 15:00:00	QQQ	ETF	186.7	186.79	186.18	186.4	7133188.0
2019-06-18 16:00:00	QQQ	ETF	186.41	186.7	186.31	186.62	2599384.0
2019-06-18 17:00:00	QQQ	ETF	186.55	186.64	186.374	186.53	406648.0
2019-06-18 18:00:00	QQQ	ETF	186.53	186.71	186.46	186.62	49607.0
2019-06-18 19:00:00	QQQ	ETF	186.7	186.89	186.65	186.84	36825.0
2019-06-18 04:00:00	IWM	ETF	152.74	152.74	152.65	152.65	6756.0
2019-06-18 05:00:00	IWM	ETF	152.76	152.79	152.69	152.73	1308.0
2019-06-18 06:00:00	IWM	ETF	152.61	153.04	152.61	153.04	4400.0
2019-06-18 07:00:00	IWM	ETF	153.04	153.35	153.03	153.35	8000.0
2019-06-18 08:00:00	IWM	ETF	153.32	153.39	153.23	153.26	18416.0
2019-06-18 09:00:00	IWM	ETF	153.28	154.94	153.06	154.68	3393799.0
2019-06-18 10:00:00	IWM	ETF	154.67	155.05	154.42	154.835	2819023.0
2019-06-18 11:00:00	IWM	ETF	154.84	155.15	153.92	153.95	2634400.0
2019-06-18 12:00:00	IWM	ETF	153.945	154.28	153.87	153.9	1140250.0
2019-06-18 13:00:00	IWM	ETF	153.89	154.34	153.61	154.32	1358171.0
2019-06-18 14:00:00	IWM	ETF	154.3125	154.36	153.975	154.015	1559976.0
2019-06-18 15:00:00	IWM	ETF	154.02	154.18	153.77	153.95	3259514.0
2019-06-18 16:00:00	IWM	ETF	153.95	154.15	152.258	154.02	1084060.0
2019-06-18 17:00:00	IWM	ETF	154.1	154.13	154.05	154.05	1000.0
2019-06-18 18:00:00	IWM	ETF	154.05	154.12	153.97	154.12	519875.0
2019-06-18 19:00:00	IWM	ETF	154.06	154.19	154.06	154.19	4956.0
2019-06-18 04:00:00	DIA	ETF	261.56	261.77	261.56	261.77	400.0
2019-06-18 05:00:00	DIA	ETF	261.85	261.85	261.85	261.85	100.0

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

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