PREVIEW / etf_1hour / 2019-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-23.parquet
  size:    331 KB
  rows:    10,852

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-04-23 04:00:00	SPY	ETF	290.22	290.42	290.21	290.36	6644.0
2019-04-23 05:00:00	SPY	ETF	290.28	290.28	290.14	290.15	6100.0
2019-04-23 06:00:00	SPY	ETF	290.19	290.21	290.17	290.2	7825.0
2019-04-23 07:00:00	SPY	ETF	290.22	290.64	290.21	290.57	69098.0
2019-04-23 08:00:00	SPY	ETF	290.25	290.86	290.21	290.55	345878.0
2019-04-23 09:00:00	SPY	ETF	290.56	291.08	290.42	291.03	4891361.0
2019-04-23 10:00:00	SPY	ETF	291.035	291.63	291.03	291.57	7691882.0
2019-04-23 11:00:00	SPY	ETF	291.565	292.66	291.56	292.63	10902099.0
2019-04-23 12:00:00	SPY	ETF	292.62	293.14	292.61	292.83	5302389.0
2019-04-23 13:00:00	SPY	ETF	292.83	292.9685	292.73	292.76	3905271.0
2019-04-23 14:00:00	SPY	ETF	292.76	293.0	292.62	292.92	3450876.0
2019-04-23 15:00:00	SPY	ETF	292.91	292.98	292.56	292.85	10824066.0
2019-04-23 16:00:00	SPY	ETF	292.86	293.16	292.8465	292.98	3368814.0
2019-04-23 17:00:00	SPY	ETF	293.08	293.08	292.88	292.97	81949.0
2019-04-23 18:00:00	SPY	ETF	292.97	293.03	292.91	293.02	52579.0
2019-04-23 19:00:00	SPY	ETF	293.02	293.13	293.0	293.13	28492.0
2019-04-23 04:00:00	QQQ	ETF	187.85	188.05	187.85	187.91	10149.0
2019-04-23 05:00:00	QQQ	ETF	187.89	187.92	187.82	187.87	16294.0
2019-04-23 06:00:00	QQQ	ETF	187.83	187.92	187.76	187.81	18513.0
2019-04-23 07:00:00	QQQ	ETF	187.82	188.13	187.77	188.13	93128.0
2019-04-23 08:00:00	QQQ	ETF	187.85	188.34	187.8	188.18	153412.0
2019-04-23 09:00:00	QQQ	ETF	188.17	189.16	188.09	189.045	3268390.0
2019-04-23 10:00:00	QQQ	ETF	189.05	189.44	189.02	189.215	5529322.0
2019-04-23 11:00:00	QQQ	ETF	189.22	190.02	189.07	189.99	3635942.0
2019-04-23 12:00:00	QQQ	ETF	190.0	190.29	189.93	190.185	3367306.0
2019-04-23 13:00:00	QQQ	ETF	190.19	190.3001	190.1179	190.18	1433533.0
2019-04-23 14:00:00	QQQ	ETF	190.18	190.44	190.129	190.4	1740158.0
2019-04-23 15:00:00	QQQ	ETF	190.4	190.54	189.98	190.29	5627821.0
2019-04-23 16:00:00	QQQ	ETF	190.29	190.63	190.28	190.37	1364552.0
2019-04-23 17:00:00	QQQ	ETF	190.35	190.49	190.27	190.38	140683.0
2019-04-23 18:00:00	QQQ	ETF	190.35	190.4199	190.31	190.36	22089.0
2019-04-23 19:00:00	QQQ	ETF	190.39	190.47	190.39	190.45	14629.0
2019-04-23 04:00:00	IWM	ETF	155.19	155.25	155.19	155.25	500.0
2019-04-23 06:00:00	IWM	ETF	155.13	155.17	155.13	155.17	4000.0
2019-04-23 07:00:00	IWM	ETF	155.16	155.35	155.11	155.35	18760.0
2019-04-23 08:00:00	IWM	ETF	155.45	155.51	155.14	155.31	18736.0
2019-04-23 09:00:00	IWM	ETF	155.26	155.9	155.26	155.71	2003078.0
2019-04-23 10:00:00	IWM	ETF	155.72	156.61	155.52	156.6	2718044.0
2019-04-23 11:00:00	IWM	ETF	156.6	157.75	156.57	157.65	4005403.0
2019-04-23 12:00:00	IWM	ETF	157.65	158.02	157.63	157.85	2955040.0
2019-04-23 13:00:00	IWM	ETF	157.86	157.975	157.54	157.64	1341155.0
2019-04-23 14:00:00	IWM	ETF	157.63	158.05	157.5233	157.67	1980680.0
2019-04-23 15:00:00	IWM	ETF	157.668	157.89	157.38	157.59	3658957.0
2019-04-23 16:00:00	IWM	ETF	157.59	157.91	157.57	157.79	2459490.0
2019-04-23 17:00:00	IWM	ETF	157.81	157.81	157.57	157.75	42200.0
2019-04-23 18:00:00	IWM	ETF	157.75	157.84	157.57	157.79	14149.0
2019-04-23 19:00:00	IWM	ETF	157.83	157.89	157.83	157.87	3900.0
2019-04-23 06:00:00	DIA	ETF	264.88	264.88	264.88	264.88	100.0
2019-04-23 07:00:00	DIA	ETF	265.2	265.68	265.2	265.68	4837.0
2019-04-23 08:00:00	DIA	ETF	265.73	265.92	265.53	265.55	9874.0

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

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