PREVIEW / etf_1hour / 2019-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-06.parquet
  size:    352 KB
  rows:    11,459

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-06 04:00:00	SPY	ETF	283.68	285.19	283.17	285.07	132007.0
2019-08-06 05:00:00	SPY	ETF	284.94	285.78	284.94	285.4	145059.0
2019-08-06 06:00:00	SPY	ETF	285.24	285.42	284.9	285.09	287516.0
2019-08-06 07:00:00	SPY	ETF	285.11	286.15	284.87	285.43	779517.0
2019-08-06 08:00:00	SPY	ETF	281.09	286.06	279.3075	285.05	2080521.0
2019-08-06 09:00:00	SPY	ETF	285.05	286.93	283.75	286.14	15247040.0
2019-08-06 10:00:00	SPY	ETF	286.145	286.75	284.7	285.68	16074932.0
2019-08-06 11:00:00	SPY	ETF	285.7	285.76	284.28	285.53	15257247.0
2019-08-06 12:00:00	SPY	ETF	285.54	285.98	284.82	285.1	9908958.0
2019-08-06 13:00:00	SPY	ETF	285.12	286.72	285.12	286.6	9783456.0
2019-08-06 14:00:00	SPY	ETF	286.58	288.0	286.0	287.0	12761509.0
2019-08-06 15:00:00	SPY	ETF	287.0	288.04	286.75	287.77	20772829.0
2019-08-06 16:00:00	SPY	ETF	287.78	287.99	287.18	287.23	13064020.0
2019-08-06 17:00:00	SPY	ETF	287.25	287.7526	284.0594	286.96	990795.0
2019-08-06 18:00:00	SPY	ETF	287.02	287.29	286.97	286.97	83868.0
2019-08-06 19:00:00	SPY	ETF	287.0	287.0	286.26	286.64	169455.0
2019-08-06 04:00:00	QQQ	ETF	180.64	182.5	180.31	181.95	101035.0
2019-08-06 05:00:00	QQQ	ETF	181.8	182.24	181.73	181.79	48765.0
2019-08-06 06:00:00	QQQ	ETF	181.83	181.95	181.44	181.63	84245.0
2019-08-06 07:00:00	QQQ	ETF	181.63	182.44	181.4	181.96	476423.0
2019-08-06 08:00:00	QQQ	ETF	181.43	182.41	180.02	181.75	655804.0
2019-08-06 09:00:00	QQQ	ETF	181.75	183.29	181.66	182.99	7112198.0
2019-08-06 10:00:00	QQQ	ETF	182.96	183.46	181.71	182.4	5441341.0
2019-08-06 11:00:00	QQQ	ETF	182.41	182.465	181.07	182.06	4952213.0
2019-08-06 12:00:00	QQQ	ETF	182.06	182.41	181.46	181.66	2781058.0
2019-08-06 13:00:00	QQQ	ETF	181.67	182.94	181.67	182.81	2656217.0
2019-08-06 14:00:00	QQQ	ETF	182.79	183.8	182.36	183.13	4396142.0
2019-08-06 15:00:00	QQQ	ETF	183.14	183.575	182.85	183.26	6340055.0
2019-08-06 16:00:00	QQQ	ETF	183.26	183.49	182.93	183.06	1362189.0
2019-08-06 17:00:00	QQQ	ETF	183.13	183.16	182.96	182.96	23488.0
2019-08-06 18:00:00	QQQ	ETF	182.95	183.18	182.91	182.91	43871.0
2019-08-06 19:00:00	QQQ	ETF	182.91	182.92	182.32	182.61	104425.0
2019-08-06 04:00:00	IWM	ETF	148.08	148.76	147.77	148.72	7734.0
2019-08-06 05:00:00	IWM	ETF	148.78	149.0	148.7	148.91	8894.0
2019-08-06 06:00:00	IWM	ETF	148.61	148.83	148.52	148.7	20793.0
2019-08-06 07:00:00	IWM	ETF	148.5	149.03	148.4	148.66	47707.0
2019-08-06 08:00:00	IWM	ETF	148.6099	148.78	147.96	148.32	51423.0
2019-08-06 09:00:00	IWM	ETF	148.41	149.7	148.32	148.94	2749450.0
2019-08-06 10:00:00	IWM	ETF	148.92	149.295	147.86	148.36	3837912.0
2019-08-06 11:00:00	IWM	ETF	148.37	148.37	147.38	148.09	4978468.0
2019-08-06 12:00:00	IWM	ETF	148.09	148.28	147.64	147.9	1771552.0
2019-08-06 13:00:00	IWM	ETF	147.91	148.49	147.9062	148.38	1176287.0
2019-08-06 14:00:00	IWM	ETF	148.36	149.0973	148.15	148.75	1762538.0
2019-08-06 15:00:00	IWM	ETF	148.76	149.5121	148.74	149.36	4210571.0
2019-08-06 16:00:00	IWM	ETF	149.37	149.5	149.02	149.1	560317.0
2019-08-06 17:00:00	IWM	ETF	149.2	149.27	149.07	149.18	11054.0
2019-08-06 18:00:00	IWM	ETF	149.05	149.11	148.91	148.91	9462.0
2019-08-06 19:00:00	IWM	ETF	148.88	148.88	148.5	148.65	8193.0
2019-08-06 04:00:00	DIA	ETF	256.8	258.0	256.56	258.0	12950.0
2019-08-06 05:00:00	DIA	ETF	257.82	258.44	257.82	258.36	13300.0

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

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