PREVIEW / etf_1hour / 2019-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-16.parquet
  size:    328 KB
  rows:    10,787

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-16 04:00:00	SPY	ETF	298.54	298.54	298.11	298.38	8301.0
2019-10-16 05:00:00	SPY	ETF	298.23	298.25	297.91	298.19	13581.0
2019-10-16 06:00:00	SPY	ETF	298.29	298.61	298.24	298.48	44339.0
2019-10-16 07:00:00	SPY	ETF	298.49	298.76	298.29	298.6	166995.0
2019-10-16 08:00:00	SPY	ETF	298.6	299.12	297.93	298.6	461678.0
2019-10-16 09:00:00	SPY	ETF	298.59	298.65	298.03	298.16	4840474.0
2019-10-16 10:00:00	SPY	ETF	298.155	299.03	297.92	299.02	8136674.0
2019-10-16 11:00:00	SPY	ETF	299.0	299.16	298.43	298.665	4578180.0
2019-10-16 12:00:00	SPY	ETF	298.67	298.87	298.18	298.21	2714802.0
2019-10-16 13:00:00	SPY	ETF	298.21	298.38	297.99	298.1	3995817.0
2019-10-16 14:00:00	SPY	ETF	298.1	298.72	298.02	298.56	5016666.0
2019-10-16 15:00:00	SPY	ETF	298.56	298.589	298.12	298.41	11613460.0
2019-10-16 16:00:00	SPY	ETF	298.44	298.66	298.4	298.6	5669113.0
2019-10-16 17:00:00	SPY	ETF	298.59	298.67	298.4	298.54	1173154.0
2019-10-16 18:00:00	SPY	ETF	298.6	298.64	298.27	298.31	171213.0
2019-10-16 19:00:00	SPY	ETF	298.32	298.42	298.18	298.25	98177.0
2019-10-16 04:00:00	QQQ	ETF	193.28	193.3	193.07	193.12	14649.0
2019-10-16 05:00:00	QQQ	ETF	193.19	193.2	192.81	193.09	12540.0
2019-10-16 06:00:00	QQQ	ETF	193.24	193.38	193.11	193.19	25484.0
2019-10-16 07:00:00	QQQ	ETF	193.2	193.34	193.06	193.19	53074.0
2019-10-16 08:00:00	QQQ	ETF	193.1801	193.53	193.02	193.17	186026.0
2019-10-16 09:00:00	QQQ	ETF	193.17	193.2	192.64	192.74	2542965.0
2019-10-16 10:00:00	QQQ	ETF	192.74	193.41	192.43	193.34	2917070.0
2019-10-16 11:00:00	QQQ	ETF	193.345	193.53	192.78	193.0	2531461.0
2019-10-16 12:00:00	QQQ	ETF	193.0	193.15	192.67	192.6939	1093360.0
2019-10-16 13:00:00	QQQ	ETF	192.69	192.89	192.56	192.64	1847992.0
2019-10-16 14:00:00	QQQ	ETF	192.65	193.09	192.61	193.01	1286001.0
2019-10-16 15:00:00	QQQ	ETF	193.01	193.15	192.71	193.03	3421396.0
2019-10-16 16:00:00	QQQ	ETF	193.04	193.51	192.87	193.51	1092146.0
2019-10-16 17:00:00	QQQ	ETF	193.38	193.55	193.38	193.42	5267.0
2019-10-16 18:00:00	QQQ	ETF	193.49	193.53	193.23	193.23	25466.0
2019-10-16 19:00:00	QQQ	ETF	193.26	193.35	193.16	193.21	34780.0
2019-10-16 04:00:00	IWM	ETF	151.01	151.01	151.0	151.0	900.0
2019-10-16 05:00:00	IWM	ETF	150.87	150.87	150.85	150.85	1000.0
2019-10-16 06:00:00	IWM	ETF	151.03	151.08	151.01	151.03	5425.0
2019-10-16 07:00:00	IWM	ETF	151.11	151.34	151.08	151.29	20885.0
2019-10-16 08:00:00	IWM	ETF	151.0701	151.48	151.01	151.18	53900.0
2019-10-16 09:00:00	IWM	ETF	151.19	151.88	151.1	151.51	1474042.0
2019-10-16 10:00:00	IWM	ETF	151.5	152.11	151.44	152.07	1450310.0
2019-10-16 11:00:00	IWM	ETF	152.07	152.27	151.63	151.75	2313655.0
2019-10-16 12:00:00	IWM	ETF	151.75	152.07	151.71	151.7661	637560.0
2019-10-16 13:00:00	IWM	ETF	151.76	151.794	151.27	151.3	1513196.0
2019-10-16 14:00:00	IWM	ETF	151.28	151.76	151.265	151.67	1151200.0
2019-10-16 15:00:00	IWM	ETF	151.67	151.72	151.43	151.56	2400020.0
2019-10-16 16:00:00	IWM	ETF	151.55	151.69	151.43	151.52	615104.0
2019-10-16 17:00:00	IWM	ETF	151.59	151.59	151.59	151.59	992.0
2019-10-16 18:00:00	IWM	ETF	151.58	151.58	151.35	151.35	9000.0
2019-10-16 19:00:00	IWM	ETF	151.39	151.41	151.25	151.3	9300.0
2019-10-16 04:00:00	DIA	ETF	269.76	269.76	269.46	269.64	17648.0
2019-10-16 06:00:00	DIA	ETF	269.78	269.82	269.78	269.82	200.0

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

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