PREVIEW / etf_1hour / 2019-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-12.parquet
  size:    315 KB
  rows:    10,514

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-03-12 04:00:00	SPY	ETF	279.35	279.35	278.93	279.0	7422.0
2019-03-12 05:00:00	SPY	ETF	279.1	279.31	278.92	278.92	14159.0
2019-03-12 06:00:00	SPY	ETF	278.93	278.94	278.71	278.74	24052.0
2019-03-12 07:00:00	SPY	ETF	278.78	278.83	278.29	278.5	352310.0
2019-03-12 08:00:00	SPY	ETF	279.13	279.37	278.36	279.17	667058.0
2019-03-12 09:00:00	SPY	ETF	279.16	279.58	278.81	279.3199	7161554.0
2019-03-12 10:00:00	SPY	ETF	279.32	280.0	279.06	279.76	9206928.0
2019-03-12 11:00:00	SPY	ETF	279.75	279.97	279.19	279.95	8012235.0
2019-03-12 12:00:00	SPY	ETF	279.95	279.985	279.43	279.63	5924662.0
2019-03-12 13:00:00	SPY	ETF	279.64	280.0	279.47	279.9	8190029.0
2019-03-12 14:00:00	SPY	ETF	279.89	280.07	279.6	279.775	8462359.0
2019-03-12 15:00:00	SPY	ETF	279.77	279.78	278.985	279.44	19332364.0
2019-03-12 16:00:00	SPY	ETF	279.45	279.6943	279.25	279.62	10939185.0
2019-03-12 17:00:00	SPY	ETF	279.62	279.64	279.45	279.54	169294.0
2019-03-12 18:00:00	SPY	ETF	279.53	279.56	279.2	279.34	142280.0
2019-03-12 19:00:00	SPY	ETF	279.35	279.39	279.0	279.27	69656.0
2019-03-12 04:00:00	QQQ	ETF	175.45	175.45	175.11	175.21	24127.0
2019-03-12 05:00:00	QQQ	ETF	175.27	175.4	175.12	175.14	34207.0
2019-03-12 06:00:00	QQQ	ETF	175.06	175.1	174.96	175.0	24860.0
2019-03-12 07:00:00	QQQ	ETF	175.04	175.07	174.72	174.93	61032.0
2019-03-12 08:00:00	QQQ	ETF	175.0	175.53	174.76	175.32	391880.0
2019-03-12 09:00:00	QQQ	ETF	175.31	175.41	174.7715	175.2689	4100479.0
2019-03-12 10:00:00	QQQ	ETF	175.27	175.96	174.99	175.78	4510717.0
2019-03-12 11:00:00	QQQ	ETF	175.76	176.08	175.3201	176.06	4115468.0
2019-03-12 12:00:00	QQQ	ETF	176.055	176.14	175.75	175.995	3316683.0
2019-03-12 13:00:00	QQQ	ETF	176.0	176.08	175.76	176.02	1668456.0
2019-03-12 14:00:00	QQQ	ETF	176.03	176.11	175.75	175.93	1774661.0
2019-03-12 15:00:00	QQQ	ETF	175.92	175.929	175.35	175.7	5846070.0
2019-03-12 16:00:00	QQQ	ETF	175.7	175.93	175.2625	175.85	1044643.0
2019-03-12 17:00:00	QQQ	ETF	175.9	175.92	175.82	175.87	13392.0
2019-03-12 18:00:00	QQQ	ETF	175.83	175.87	175.61	175.73	28023.0
2019-03-12 19:00:00	QQQ	ETF	175.79	175.79	175.49	175.68	44750.0
2019-03-12 05:00:00	IWM	ETF	154.66	154.66	154.66	154.66	100.0
2019-03-12 06:00:00	IWM	ETF	154.39	154.39	154.34	154.34	1000.0
2019-03-12 07:00:00	IWM	ETF	154.29	154.29	154.08	154.08	4600.0
2019-03-12 08:00:00	IWM	ETF	154.14	154.52	154.1	154.45	20234.0
2019-03-12 09:00:00	IWM	ETF	154.4	154.58	154.02	154.22	2113515.0
2019-03-12 10:00:00	IWM	ETF	154.24	154.32	153.8	154.03	2508071.0
2019-03-12 11:00:00	IWM	ETF	154.03	154.78	153.88	154.76	2396751.0
2019-03-12 12:00:00	IWM	ETF	154.76	154.98	154.5345	154.655	1328975.0
2019-03-12 13:00:00	IWM	ETF	154.655	154.86	154.46	154.74	905411.0
2019-03-12 14:00:00	IWM	ETF	154.74	154.78	154.41	154.525	994987.0
2019-03-12 15:00:00	IWM	ETF	154.53	154.53	154.13	154.35	2655191.0
2019-03-12 16:00:00	IWM	ETF	154.35	154.37	154.21	154.35	862875.0
2019-03-12 17:00:00	IWM	ETF	154.4	154.4	154.37	154.37	4162.0
2019-03-12 18:00:00	IWM	ETF	154.3	154.3	154.15	154.19	9300.0
2019-03-12 19:00:00	IWM	ETF	154.22	154.22	154.02	154.19	11500.0
2019-03-12 05:00:00	DIA	ETF	257.13	257.13	256.73	256.73	650.0
2019-03-12 06:00:00	DIA	ETF	256.58	256.69	256.4	256.48	17590.0
2019-03-12 07:00:00	DIA	ETF	256.5	256.5	255.98	256.08	7730.0

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

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