PREVIEW / etf_1hour / 2019-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-02.parquet
  size:    342 KB
  rows:    11,282

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-08-02 04:00:00	SPY	ETF	293.26	293.63	293.1	293.34	9642.0
2019-08-02 05:00:00	SPY	ETF	293.39	293.6	292.99	293.49	15627.0
2019-08-02 06:00:00	SPY	ETF	293.52	294.19	293.52	293.96	64131.0
2019-08-02 07:00:00	SPY	ETF	294.0	294.0	293.54	293.68	382554.0
2019-08-02 08:00:00	SPY	ETF	294.525	294.84	292.9	293.91	1616715.0
2019-08-02 09:00:00	SPY	ETF	293.92	295.6	292.7	292.95	13363376.0
2019-08-02 10:00:00	SPY	ETF	292.93	293.32	290.97	291.02	17489269.0
2019-08-02 11:00:00	SPY	ETF	291.02	292.46	290.9	292.02	12961298.0
2019-08-02 12:00:00	SPY	ETF	292.02	292.89	291.8	291.83	8822881.0
2019-08-02 13:00:00	SPY	ETF	291.82	291.89	291.2	291.52	7622046.0
2019-08-02 14:00:00	SPY	ETF	291.52	292.67	291.34	292.275	11041505.0
2019-08-02 15:00:00	SPY	ETF	292.275	294.01	291.68	292.76	26649678.0
2019-08-02 16:00:00	SPY	ETF	292.73	293.05	292.43	292.99	14552448.0
2019-08-02 17:00:00	SPY	ETF	292.95	293.02	292.67	292.85	168799.0
2019-08-02 18:00:00	SPY	ETF	292.85	292.88	292.76	292.85	60507.0
2019-08-02 19:00:00	SPY	ETF	292.88	292.95	292.81	292.95	22297.0
2019-08-02 04:00:00	QQQ	ETF	188.8	188.92	188.39	188.65	45624.0
2019-08-02 05:00:00	QQQ	ETF	188.54	188.8	188.25	188.65	50850.0
2019-08-02 06:00:00	QQQ	ETF	188.64	189.24	188.64	189.04	81590.0
2019-08-02 07:00:00	QQQ	ETF	189.06	189.06	188.65	188.75	115336.0
2019-08-02 08:00:00	QQQ	ETF	188.72	189.61	188.02	188.79	682274.0
2019-08-02 09:00:00	QQQ	ETF	188.79	189.89	187.86	188.08	7468462.0
2019-08-02 10:00:00	QQQ	ETF	188.1	188.48	186.26	186.32	9752482.0
2019-08-02 11:00:00	QQQ	ETF	186.32	187.4	186.3	186.95	5633907.0
2019-08-02 12:00:00	QQQ	ETF	186.94	187.6253	186.7	186.76	5503444.0
2019-08-02 13:00:00	QQQ	ETF	186.75	186.84	186.21	186.48	3455848.0
2019-08-02 14:00:00	QQQ	ETF	186.48	187.28	186.28	186.96	4165200.0
2019-08-02 15:00:00	QQQ	ETF	186.97	188.05	186.59	187.43	9782395.0
2019-08-02 16:00:00	QQQ	ETF	187.43	187.63	187.2	187.56	2710033.0
2019-08-02 17:00:00	QQQ	ETF	187.72	187.72	187.42	187.5	439414.0
2019-08-02 18:00:00	QQQ	ETF	187.5	187.52	187.49	187.52	3648.0
2019-08-02 19:00:00	QQQ	ETF	187.57	187.57	187.51	187.52	11850.0
2019-08-02 04:00:00	IWM	ETF	153.26	153.27	153.0	153.13	6186.0
2019-08-02 05:00:00	IWM	ETF	152.99	153.08	152.94	153.0	2693.0
2019-08-02 06:00:00	IWM	ETF	153.19	153.33	153.18	153.18	4200.0
2019-08-02 07:00:00	IWM	ETF	153.27	153.31	153.12	153.2	60200.0
2019-08-02 08:00:00	IWM	ETF	153.2	153.44	152.92	153.39	140574.0
2019-08-02 09:00:00	IWM	ETF	153.4	154.19	152.6675	152.72	3979938.0
2019-08-02 10:00:00	IWM	ETF	152.73	152.92	151.28	151.4	5739210.0
2019-08-02 11:00:00	IWM	ETF	151.4	152.6	151.28	152.48	3514564.0
2019-08-02 12:00:00	IWM	ETF	152.47	152.79	151.99	152.09	1939468.0
2019-08-02 13:00:00	IWM	ETF	152.08	152.46	151.92	152.1	1538713.0
2019-08-02 14:00:00	IWM	ETF	152.09	152.52	151.94	152.34	1586201.0
2019-08-02 15:00:00	IWM	ETF	152.33	152.78	151.79	152.54	5469610.0
2019-08-02 16:00:00	IWM	ETF	152.53	152.81	152.39	152.72	1618637.0
2019-08-02 17:00:00	IWM	ETF	152.64	152.82	152.58	152.65	690963.0
2019-08-02 18:00:00	IWM	ETF	152.65	152.65	152.65	152.65	500.0
2019-08-02 19:00:00	IWM	ETF	152.62	152.65	152.62	152.65	438.0
2019-08-02 05:00:00	DIA	ETF	264.7	264.7	264.7	264.7	100.0
2019-08-02 07:00:00	DIA	ETF	265.1	265.25	265.02	265.12	4300.0

> showing 50 of 11,282 rows — these rows as CSV

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