PREVIEW / etf_1hour / 2019-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-06.parquet
  size:    325 KB
  rows:    10,692

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-06 04:00:00	SPY	ETF	283.71	283.86	283.68	283.81	32326.0
2019-06-06 05:00:00	SPY	ETF	283.84	284.01	283.67	283.73	44128.0
2019-06-06 06:00:00	SPY	ETF	283.74	283.96	283.68	283.78	24801.0
2019-06-06 07:00:00	SPY	ETF	283.78	283.97	283.54	283.95	280113.0
2019-06-06 08:00:00	SPY	ETF	283.91	283.94	282.53	283.1	512959.0
2019-06-06 09:00:00	SPY	ETF	283.09	283.69	282.76	282.86	6059851.0
2019-06-06 10:00:00	SPY	ETF	282.855	283.57	282.57	283.28	6876775.0
2019-06-06 11:00:00	SPY	ETF	283.2711	283.89	282.98	283.19	7249265.0
2019-06-06 12:00:00	SPY	ETF	283.1901	283.71	283.105	283.59	4195636.0
2019-06-06 13:00:00	SPY	ETF	283.6	283.78	283.45	283.7338	2870999.0
2019-06-06 14:00:00	SPY	ETF	283.73	284.64	283.52	284.19	9254783.0
2019-06-06 15:00:00	SPY	ETF	284.2	285.55	284.11	284.74	18813890.0
2019-06-06 16:00:00	SPY	ETF	284.74	284.94	283.25	284.28	8807667.0
2019-06-06 17:00:00	SPY	ETF	284.3	284.8	284.11	284.19	104834.0
2019-06-06 18:00:00	SPY	ETF	284.17	284.8	284.08	284.19	62117.0
2019-06-06 19:00:00	SPY	ETF	284.21	284.8	284.2	284.71	51144.0
2019-06-06 04:00:00	QQQ	ETF	176.86	176.98	176.79	176.95	64212.0
2019-06-06 05:00:00	QQQ	ETF	176.9	177.17	176.82	176.92	52180.0
2019-06-06 06:00:00	QQQ	ETF	176.89	177.08	176.88	176.98	39493.0
2019-06-06 07:00:00	QQQ	ETF	176.93	177.07	176.68	176.99	189976.0
2019-06-06 08:00:00	QQQ	ETF	176.93	177.0699	176.02	176.26	357209.0
2019-06-06 09:00:00	QQQ	ETF	176.31	176.78	175.88	175.91	3151967.0
2019-06-06 10:00:00	QQQ	ETF	175.91	176.56	175.73	176.28	3586684.0
2019-06-06 11:00:00	QQQ	ETF	176.28	176.93	176.15	176.4	3150912.0
2019-06-06 12:00:00	QQQ	ETF	176.4	176.775	176.28	176.6	1515189.0
2019-06-06 13:00:00	QQQ	ETF	176.6	176.71	176.34	176.65	844272.0
2019-06-06 14:00:00	QQQ	ETF	176.66	177.42	176.48	177.05	3179056.0
2019-06-06 15:00:00	QQQ	ETF	177.0516	178.04	177.0099	177.6	5764636.0
2019-06-06 16:00:00	QQQ	ETF	177.62	177.69	176.98	177.21	1620633.0
2019-06-06 17:00:00	QQQ	ETF	177.28	177.62	177.08	177.3	302684.0
2019-06-06 18:00:00	QQQ	ETF	177.25	177.29	177.04	177.14	42969.0
2019-06-06 19:00:00	QQQ	ETF	177.1	177.54	177.1	177.46	27059.0
2019-06-06 04:00:00	IWM	ETF	150.38	150.5	150.38	150.5	6500.0
2019-06-06 05:00:00	IWM	ETF	150.5	150.6	150.5	150.5	1800.0
2019-06-06 07:00:00	IWM	ETF	150.44	150.69	150.42	150.69	8896.0
2019-06-06 08:00:00	IWM	ETF	150.54	150.68	149.8	150.09	83221.0
2019-06-06 09:00:00	IWM	ETF	150.16	150.52	149.39	149.4	1520376.0
2019-06-06 10:00:00	IWM	ETF	149.4	149.6	148.73	148.91	2872107.0
2019-06-06 11:00:00	IWM	ETF	148.89	149.24	148.31	148.5	3263243.0
2019-06-06 12:00:00	IWM	ETF	148.48	148.945	148.36	148.93	1994619.0
2019-06-06 13:00:00	IWM	ETF	148.94	149.07	148.605	148.84	1404732.0
2019-06-06 14:00:00	IWM	ETF	148.84	149.64	148.73	149.3	2371101.0
2019-06-06 15:00:00	IWM	ETF	149.3	150.27	149.23	149.82	3184498.0
2019-06-06 16:00:00	IWM	ETF	149.83	149.98	149.23	149.38	678738.0
2019-06-06 17:00:00	IWM	ETF	149.26	149.5	149.26	149.3	27151.0
2019-06-06 18:00:00	IWM	ETF	149.3	149.4	149.22	149.3	14298.0
2019-06-06 19:00:00	IWM	ETF	149.3	149.62	149.3	149.58	8100.0
2019-06-06 05:00:00	DIA	ETF	256.5	256.5	256.5	256.5	100.0
2019-06-06 07:00:00	DIA	ETF	256.56	256.61	256.5	256.5	2050.0
2019-06-06 08:00:00	DIA	ETF	256.66	256.66	255.91	256.05	8100.0

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

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