PREVIEW / etf_1hour / 2019-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-19.parquet
  size:    334 KB
  rows:    10,808

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-09-19 04:00:00	SPY	ETF	300.53	300.7	300.35	300.7	69273.0
2019-09-19 05:00:00	SPY	ETF	300.7	300.74	300.28	300.31	11776.0
2019-09-19 06:00:00	SPY	ETF	300.33	300.52	300.26	300.26	38171.0
2019-09-19 07:00:00	SPY	ETF	300.28	300.81	300.24	300.7	192208.0
2019-09-19 08:00:00	SPY	ETF	300.41	301.71	299.55	301.64	783976.0
2019-09-19 09:00:00	SPY	ETF	301.59	302.2	301.47	301.87	7302283.0
2019-09-19 10:00:00	SPY	ETF	301.875	302.52	301.86	302.18	14520624.0
2019-09-19 11:00:00	SPY	ETF	302.18	302.63	302.04	302.285	7766600.0
2019-09-19 12:00:00	SPY	ETF	302.29	302.41	301.55	301.903	8222335.0
2019-09-19 13:00:00	SPY	ETF	301.905	302.12	301.17	301.78	9070480.0
2019-09-19 14:00:00	SPY	ETF	301.77	301.88	301.36	301.54	6602099.0
2019-09-19 15:00:00	SPY	ETF	301.545	301.66	300.7103	301.06	13322172.0
2019-09-19 16:00:00	SPY	ETF	301.05	301.25	300.89	301.05	7801421.0
2019-09-19 17:00:00	SPY	ETF	301.04	301.06	300.76	300.92	299426.0
2019-09-19 18:00:00	SPY	ETF	300.92	301.3	300.75	301.25	93680.0
2019-09-19 19:00:00	SPY	ETF	301.27	301.36	301.23	301.23	25713.0
2019-09-19 04:00:00	QQQ	ETF	192.16	192.36	192.04	192.28	17754.0
2019-09-19 05:00:00	QQQ	ETF	192.25	192.3	191.9	191.94	13770.0
2019-09-19 06:00:00	QQQ	ETF	192.08	192.11	191.85	191.86	35113.0
2019-09-19 07:00:00	QQQ	ETF	191.87	192.4	191.83	192.29	46285.0
2019-09-19 08:00:00	QQQ	ETF	192.2501	193.14	191.24	193.04	261862.0
2019-09-19 09:00:00	QQQ	ETF	193.05	193.8	192.85	193.57	3635307.0
2019-09-19 10:00:00	QQQ	ETF	193.6	194.035	193.58	193.75	3283555.0
2019-09-19 11:00:00	QQQ	ETF	193.75	193.9	193.4	193.4841	2297939.0
2019-09-19 12:00:00	QQQ	ETF	193.49	193.63	192.78	193.06	2541702.0
2019-09-19 13:00:00	QQQ	ETF	193.06	193.17	192.47	193.02	3233199.0
2019-09-19 14:00:00	QQQ	ETF	193.01	193.1916	192.83	193.01	1727189.0
2019-09-19 15:00:00	QQQ	ETF	193.01	193.18	192.6	192.83	4002297.0
2019-09-19 16:00:00	QQQ	ETF	192.84	192.88	192.63	192.75	644359.0
2019-09-19 17:00:00	QQQ	ETF	192.74	192.74	192.57	192.67	66852.0
2019-09-19 18:00:00	QQQ	ETF	192.7	192.95	192.63	192.93	42056.0
2019-09-19 19:00:00	QQQ	ETF	192.92	193.04	192.9	192.95	26490.0
2019-09-19 05:00:00	IWM	ETF	156.24	156.24	156.17	156.17	381.0
2019-09-19 06:00:00	IWM	ETF	156.24	156.29	156.2	156.29	2262.0
2019-09-19 07:00:00	IWM	ETF	156.25	156.49	156.25	156.49	12900.0
2019-09-19 08:00:00	IWM	ETF	156.36	156.88	156.36	156.84	58491.0
2019-09-19 09:00:00	IWM	ETF	156.85	157.25	156.48	156.88	1823534.0
2019-09-19 10:00:00	IWM	ETF	156.8875	157.61	156.865	157.47	2784060.0
2019-09-19 11:00:00	IWM	ETF	157.46	157.82	157.02	157.12	2865694.0
2019-09-19 12:00:00	IWM	ETF	157.13	157.4128	156.665	157.0325	1710844.0
2019-09-19 13:00:00	IWM	ETF	157.03	157.2	156.39	156.61	2019903.0
2019-09-19 14:00:00	IWM	ETF	156.59	156.81	156.12	156.17	1461841.0
2019-09-19 15:00:00	IWM	ETF	156.17	156.26	155.525	155.72	3442579.0
2019-09-19 16:00:00	IWM	ETF	155.72	155.83	155.53	155.76	614785.0
2019-09-19 17:00:00	IWM	ETF	155.65	156.3276	155.5	155.76	203022.0
2019-09-19 18:00:00	IWM	ETF	155.61	155.83	155.6	155.82	25101.0
2019-09-19 19:00:00	IWM	ETF	155.83	155.84	155.78	155.79	5225.0
2019-09-19 04:00:00	DIA	ETF	271.66	271.68	271.54	271.54	1800.0
2019-09-19 05:00:00	DIA	ETF	271.48	271.64	271.48	271.54	1800.0
2019-09-19 07:00:00	DIA	ETF	271.28	271.68	271.25	271.68	3500.0

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

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