PREVIEW / etf_1hour / 2019-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-28.parquet
  size:    326 KB
  rows:    10,867

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-28 04:00:00	SPY	ETF	292.37	292.68	292.35	292.53	12083.0
2019-06-28 05:00:00	SPY	ETF	292.58	292.73	292.5	292.63	24960.0
2019-06-28 06:00:00	SPY	ETF	292.63	292.63	292.4	292.4	19069.0
2019-06-28 07:00:00	SPY	ETF	292.49	292.49	292.32	292.45	76369.0
2019-06-28 08:00:00	SPY	ETF	292.5	292.67	292.05	292.62	269078.0
2019-06-28 09:00:00	SPY	ETF	292.62	292.83	292.01	292.215	4807060.0
2019-06-28 10:00:00	SPY	ETF	292.215	292.46	292.04	292.32	5521469.0
2019-06-28 11:00:00	SPY	ETF	292.31	292.7	292.07	292.5426	3917675.0
2019-06-28 12:00:00	SPY	ETF	292.54	293.19	292.54	293.0	5661412.0
2019-06-28 13:00:00	SPY	ETF	292.995	293.0	292.46	292.555	3015242.0
2019-06-28 14:00:00	SPY	ETF	292.55	292.69	292.28	292.33	5288208.0
2019-06-28 15:00:00	SPY	ETF	292.33	293.55	292.23	293.08	17896566.0
2019-06-28 16:00:00	SPY	ETF	293.07	294.25	292.95	294.02	8737418.0
2019-06-28 17:00:00	SPY	ETF	294.0	294.35	293.0	294.35	1160638.0
2019-06-28 18:00:00	SPY	ETF	294.3	294.7	294.25	294.31	499087.0
2019-06-28 19:00:00	SPY	ETF	294.33	294.5	294.3	294.47	75128.0
2019-06-28 04:00:00	QQQ	ETF	187.0	187.0	186.96	186.96	3100.0
2019-06-28 05:00:00	QQQ	ETF	186.96	187.02	186.89	187.02	10070.0
2019-06-28 06:00:00	QQQ	ETF	186.95	186.95	186.76	186.76	3945.0
2019-06-28 07:00:00	QQQ	ETF	186.78	186.83	186.67	186.81	25600.0
2019-06-28 08:00:00	QQQ	ETF	186.79	187.0	186.46	186.94	56553.0
2019-06-28 09:00:00	QQQ	ETF	186.918	187.15	186.07	186.2333	2484379.0
2019-06-28 10:00:00	QQQ	ETF	186.23	186.55	186.07	186.48	2150770.0
2019-06-28 11:00:00	QQQ	ETF	186.47	186.72	186.26	186.6599	1478399.0
2019-06-28 12:00:00	QQQ	ETF	186.65	187.12	186.64	186.99	2049798.0
2019-06-28 13:00:00	QQQ	ETF	186.995	187.0	186.25	186.34	1577864.0
2019-06-28 14:00:00	QQQ	ETF	186.32	186.52	186.21	186.32	1259518.0
2019-06-28 15:00:00	QQQ	ETF	186.33	186.96	186.18	186.76	5964587.0
2019-06-28 16:00:00	QQQ	ETF	186.76	187.53	186.71	187.47	1309316.0
2019-06-28 17:00:00	QQQ	ETF	187.41	187.53	186.74	187.5	336133.0
2019-06-28 18:00:00	QQQ	ETF	187.51	187.54	187.45	187.5	26904.0
2019-06-28 19:00:00	QQQ	ETF	187.5	187.64	187.45	187.45	22097.0
2019-06-28 04:00:00	IWM	ETF	153.98	153.98	153.98	153.98	500.0
2019-06-28 05:00:00	IWM	ETF	153.99	154.0	153.99	154.0	400.0
2019-06-28 06:00:00	IWM	ETF	154.0	154.0	154.0	154.0	500.0
2019-06-28 07:00:00	IWM	ETF	153.93	153.93	153.93	153.93	1700.0
2019-06-28 08:00:00	IWM	ETF	153.86	154.04	153.85	154.03	27156.0
2019-06-28 09:00:00	IWM	ETF	154.02	154.98	153.94	154.45	2913622.0
2019-06-28 10:00:00	IWM	ETF	154.45	155.2	154.32	155.105	3399793.0
2019-06-28 11:00:00	IWM	ETF	155.1	155.56	154.87	155.38	3074869.0
2019-06-28 12:00:00	IWM	ETF	155.39	155.85	155.26	155.7825	2391046.0
2019-06-28 13:00:00	IWM	ETF	155.78	155.78	155.44	155.6	1832367.0
2019-06-28 14:00:00	IWM	ETF	155.58	155.96	155.54	155.81	2246146.0
2019-06-28 15:00:00	IWM	ETF	155.82	156.02	155.155	155.5	12549225.0
2019-06-28 16:00:00	IWM	ETF	155.51	156.19	155.42	156.11	2502720.0
2019-06-28 17:00:00	IWM	ETF	156.02	156.2	155.5	156.2	336508.0
2019-06-28 18:00:00	IWM	ETF	156.1	156.34	156.1	156.34	11845.0
2019-06-28 19:00:00	IWM	ETF	156.34	156.34	156.1	156.14	8265.0
2019-06-28 04:00:00	DIA	ETF	265.8	265.8	265.8	265.8	100.0
2019-06-28 07:00:00	DIA	ETF	265.98	266.0	265.85	266.0	2700.0

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

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