PREVIEW / etf_1hour / 2019-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-10.parquet
  size:    338 KB
  rows:    11,010

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-09-10 04:00:00	SPY	ETF	297.29	297.3	296.89	297.12	15610.0
2019-09-10 05:00:00	SPY	ETF	297.13	297.56	297.13	297.5	16907.0
2019-09-10 06:00:00	SPY	ETF	297.5	297.73	297.46	297.46	19535.0
2019-09-10 07:00:00	SPY	ETF	297.47	297.98	297.4	297.55	102189.0
2019-09-10 08:00:00	SPY	ETF	297.7401	298.2	297.1	297.42	175217.0
2019-09-10 09:00:00	SPY	ETF	297.39	297.5	296.05	296.33	10109088.0
2019-09-10 10:00:00	SPY	ETF	296.32	296.82	295.97	296.24	9402413.0
2019-09-10 11:00:00	SPY	ETF	296.245	297.28	296.08	296.91	8353633.0
2019-09-10 12:00:00	SPY	ETF	296.91	297.79	296.42	297.61	6439326.0
2019-09-10 13:00:00	SPY	ETF	297.6	297.66	296.94	297.165	3339364.0
2019-09-10 14:00:00	SPY	ETF	297.16	297.28	296.515	296.8	4011930.0
2019-09-10 15:00:00	SPY	ETF	296.79	298.2	296.66	298.2	9650849.0
2019-09-10 16:00:00	SPY	ETF	298.18	298.28	297.92	298.16	4721148.0
2019-09-10 17:00:00	SPY	ETF	298.16	298.2057	297.96	298.04	589199.0
2019-09-10 18:00:00	SPY	ETF	298.09	298.13	297.82	297.85	191451.0
2019-09-10 19:00:00	SPY	ETF	297.81	298.05	297.78	297.93	37182.0
2019-09-10 04:00:00	QQQ	ETF	190.22	190.29	189.85	190.16	32860.0
2019-09-10 05:00:00	QQQ	ETF	190.35	190.56	190.17	190.42	13714.0
2019-09-10 06:00:00	QQQ	ETF	190.5	190.7	190.44	190.44	18121.0
2019-09-10 07:00:00	QQQ	ETF	190.44	190.86	190.27	190.44	73071.0
2019-09-10 08:00:00	QQQ	ETF	190.78	190.8501	190.2	190.35	128601.0
2019-09-10 09:00:00	QQQ	ETF	190.3	190.4	188.91	189.335	4702398.0
2019-09-10 10:00:00	QQQ	ETF	189.33	189.95	189.05	189.35	4190036.0
2019-09-10 11:00:00	QQQ	ETF	189.34	190.09	189.09	189.83	2579142.0
2019-09-10 12:00:00	QQQ	ETF	189.82	190.55	189.5	190.36	1924671.0
2019-09-10 13:00:00	QQQ	ETF	190.35	190.39	189.72	189.82	1701223.0
2019-09-10 14:00:00	QQQ	ETF	189.82	189.945	189.3	189.59	1643671.0
2019-09-10 15:00:00	QQQ	ETF	189.59	190.74	189.455	190.73	2696223.0
2019-09-10 16:00:00	QQQ	ETF	190.73	190.76	189.6553	190.74	1078549.0
2019-09-10 17:00:00	QQQ	ETF	190.7	190.75	190.6	190.64	12466.0
2019-09-10 18:00:00	QQQ	ETF	190.69	190.7	190.41	190.42	41608.0
2019-09-10 19:00:00	QQQ	ETF	190.45	190.61	190.41	190.54	18138.0
2019-09-10 05:00:00	IWM	ETF	151.27	151.38	151.27	151.36	8600.0
2019-09-10 06:00:00	IWM	ETF	151.4	151.45	151.39	151.39	2853.0
2019-09-10 07:00:00	IWM	ETF	151.45	151.63	151.45	151.59	9800.0
2019-09-10 08:00:00	IWM	ETF	151.58	151.78	151.58	151.67	38078.0
2019-09-10 09:00:00	IWM	ETF	151.65	151.75	150.89	151.525	2952638.0
2019-09-10 10:00:00	IWM	ETF	151.51	152.53	151.35	152.35	5724562.0
2019-09-10 11:00:00	IWM	ETF	152.34	153.43	152.26	153.19	3456783.0
2019-09-10 12:00:00	IWM	ETF	153.191	153.95	152.84	153.5	3062188.0
2019-09-10 13:00:00	IWM	ETF	153.5	153.785	153.12	153.5085	1694655.0
2019-09-10 14:00:00	IWM	ETF	153.5	153.54	153.08	153.33	1523051.0
2019-09-10 15:00:00	IWM	ETF	153.33	153.83	153.25	153.82	4362659.0
2019-09-10 16:00:00	IWM	ETF	153.82	154.04	153.75	153.97	1332425.0
2019-09-10 17:00:00	IWM	ETF	153.87	154.04	153.85	153.95	48938.0
2019-09-10 18:00:00	IWM	ETF	153.93	153.93	153.79	153.81	2349.0
2019-09-10 19:00:00	IWM	ETF	153.8	153.97	153.8	153.92	6568.0
2019-09-10 04:00:00	DIA	ETF	268.08	268.08	268.08	268.08	400.0
2019-09-10 07:00:00	DIA	ETF	268.6	268.6	268.4	268.52	1100.0
2019-09-10 08:00:00	DIA	ETF	268.64	268.64	268.3	268.3	6407.0

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

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