PREVIEW / etf_1hour / 2019-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-17.parquet
  size:    330 KB
  rows:    10,850

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-10-17 04:00:00	SPY	ETF	298.75	299.22	298.67	299.22	10596.0
2019-10-17 05:00:00	SPY	ETF	298.84	300.05	298.84	299.82	36078.0
2019-10-17 06:00:00	SPY	ETF	299.85	300.1	299.58	299.68	37509.0
2019-10-17 07:00:00	SPY	ETF	299.68	299.86	299.33	299.5	170177.0
2019-10-17 08:00:00	SPY	ETF	299.53	299.8099	298.15	299.56	317444.0
2019-10-17 09:00:00	SPY	ETF	299.6	300.2	299.38	300.09	4305444.0
2019-10-17 10:00:00	SPY	ETF	300.08	300.24	299.18	299.25	7690600.0
2019-10-17 11:00:00	SPY	ETF	299.23	299.56	298.64	298.91	9373348.0
2019-10-17 12:00:00	SPY	ETF	298.91	299.31	298.515	299.3	3668180.0
2019-10-17 13:00:00	SPY	ETF	299.2911	299.51	299.1	299.38	3481370.0
2019-10-17 14:00:00	SPY	ETF	299.39	299.68	299.01	299.58	4276719.0
2019-10-17 15:00:00	SPY	ETF	299.58	299.68	299.07	299.24	8750020.0
2019-10-17 16:00:00	SPY	ETF	299.23	299.34	299.11	299.27	2996655.0
2019-10-17 17:00:00	SPY	ETF	299.27	299.35	299.2	299.23	724770.0
2019-10-17 18:00:00	SPY	ETF	299.23	299.26	298.95	299.15	78741.0
2019-10-17 19:00:00	SPY	ETF	299.14	299.2	299.04	299.16	27604.0
2019-10-17 04:00:00	QQQ	ETF	193.51	193.87	193.45	193.68	16627.0
2019-10-17 05:00:00	QQQ	ETF	193.65	194.5	193.5	194.37	71906.0
2019-10-17 06:00:00	QQQ	ETF	194.35	194.54	194.14	194.2	30695.0
2019-10-17 07:00:00	QQQ	ETF	194.15	194.39	193.96	194.12	155432.0
2019-10-17 08:00:00	QQQ	ETF	194.16	194.3501	193.16	194.3	238815.0
2019-10-17 09:00:00	QQQ	ETF	194.31	194.5	193.88	194.32	1992045.0
2019-10-17 10:00:00	QQQ	ETF	194.33	194.34	193.19	193.36	2657678.0
2019-10-17 11:00:00	QQQ	ETF	193.36	193.61	192.89	193.1423	2408050.0
2019-10-17 12:00:00	QQQ	ETF	193.16	193.46	192.81	193.44	1171123.0
2019-10-17 13:00:00	QQQ	ETF	193.45	193.64	193.26	193.5601	1083384.0
2019-10-17 14:00:00	QQQ	ETF	193.57	193.74	193.27	193.65	1826205.0
2019-10-17 15:00:00	QQQ	ETF	193.66	193.75	193.42	193.54	3881780.0
2019-10-17 16:00:00	QQQ	ETF	193.54	193.64	193.44	193.54	632149.0
2019-10-17 17:00:00	QQQ	ETF	193.58	193.62	193.48	193.52	58175.0
2019-10-17 18:00:00	QQQ	ETF	193.52	193.52	193.35	193.45	24063.0
2019-10-17 19:00:00	QQQ	ETF	193.43	193.45	193.36	193.43	16270.0
2019-10-17 04:00:00	IWM	ETF	151.7	151.7	151.7	151.7	100.0
2019-10-17 05:00:00	IWM	ETF	151.99	152.4	151.99	152.4	13152.0
2019-10-17 06:00:00	IWM	ETF	152.4	152.41	152.17	152.18	17284.0
2019-10-17 07:00:00	IWM	ETF	152.13	152.39	151.94	152.39	23403.0
2019-10-17 08:00:00	IWM	ETF	152.18	152.28	151.48	152.17	35460.0
2019-10-17 09:00:00	IWM	ETF	152.2	153.15	152.05	152.87	1809971.0
2019-10-17 10:00:00	IWM	ETF	152.9	153.34	152.53	152.77	2032529.0
2019-10-17 11:00:00	IWM	ETF	152.76	153.05	152.48	152.83	1029488.0
2019-10-17 12:00:00	IWM	ETF	152.83	153.1	152.72	153.08	919377.0
2019-10-17 13:00:00	IWM	ETF	153.08	153.26	152.89	153.21	752070.0
2019-10-17 14:00:00	IWM	ETF	153.22	153.45	152.98	153.4	902452.0
2019-10-17 15:00:00	IWM	ETF	153.41	153.51	153.13	153.33	3030192.0
2019-10-17 16:00:00	IWM	ETF	153.33	153.38	153.22	153.3	750925.0
2019-10-17 17:00:00	IWM	ETF	153.34	153.34	153.27	153.31	15100.0
2019-10-17 18:00:00	IWM	ETF	153.22	153.25	153.15	153.23	4900.0
2019-10-17 19:00:00	IWM	ETF	153.15	153.22	153.15	153.19	7000.0
2019-10-17 05:00:00	DIA	ETF	270.42	271.16	270.42	271.16	400.0
2019-10-17 06:00:00	DIA	ETF	271.02	271.18	271.02	271.06	2284.0

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

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