PREVIEW / etf_1hour / 2020-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-09.parquet
  size:    420 KB
  rows:    14,780

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
2020-11-09 04:00:00	SPY	ETF	355.0	355.83	354.65	355.01	66334.0
2020-11-09 05:00:00	SPY	ETF	355.11	355.6	354.71	355.56	42356.0
2020-11-09 06:00:00	SPY	ETF	355.5	365.32	355.04	363.66	1797094.0
2020-11-09 07:00:00	SPY	ETF	363.51	364.66	361.08	364.66	4400126.0
2020-11-09 08:00:00	SPY	ETF	364.7	366.77	355.01	365.23	4146621.0
2020-11-09 09:00:00	SPY	ETF	365.3	366.1	360.39	360.54	31010853.0
2020-11-09 10:00:00	SPY	ETF	360.54	363.0	359.0	360.35	28021099.0
2020-11-09 11:00:00	SPY	ETF	360.37	360.63	358.67	359.6699	16208803.0
2020-11-09 12:00:00	SPY	ETF	359.68	361.69	359.41	361.4801	16402860.0
2020-11-09 13:00:00	SPY	ETF	361.52	362.135	360.7	361.15	10331846.0
2020-11-09 14:00:00	SPY	ETF	361.14	361.31	358.89	359.65	11940456.0
2020-11-09 15:00:00	SPY	ETF	359.66	360.37	354.06	354.54	31608947.0
2020-11-09 16:00:00	SPY	ETF	354.54	355.58	354.11	354.57	14435237.0
2020-11-09 17:00:00	SPY	ETF	354.56	354.92	354.33	354.85	260027.0
2020-11-09 18:00:00	SPY	ETF	354.81	356.11	354.6	354.71	304014.0
2020-11-09 19:00:00	SPY	ETF	354.68	355.1	353.07	353.89	342341.0
2020-11-09 04:00:00	QQQ	ETF	300.46	300.73	297.0	299.51	98505.0
2020-11-09 05:00:00	QQQ	ETF	299.68	300.38	299.49	300.24	44108.0
2020-11-09 06:00:00	QQQ	ETF	300.3	302.0	298.85	299.85	552307.0
2020-11-09 07:00:00	QQQ	ETF	299.82	299.97	283.0	295.44	4925714.0
2020-11-09 08:00:00	QQQ	ETF	295.47	302.5	291.02	296.53	3633515.0
2020-11-09 09:00:00	QQQ	ETF	296.55	297.84	293.74	295.44	11150604.0
2020-11-09 10:00:00	QQQ	ETF	295.44	299.03	295.32	296.64	11045412.0
2020-11-09 11:00:00	QQQ	ETF	296.636	299.14	294.545	295.49	7798592.0
2020-11-09 12:00:00	QQQ	ETF	295.51	296.07	294.33	295.62	5652830.0
2020-11-09 13:00:00	QQQ	ETF	295.63	296.25	294.12	294.61	2759558.0
2020-11-09 14:00:00	QQQ	ETF	294.63	294.85	292.08	292.9	4627829.0
2020-11-09 15:00:00	QQQ	ETF	292.9	293.84	288.12	288.44	8951864.0
2020-11-09 16:00:00	QQQ	ETF	288.45	294.7507	288.24	288.92	2739727.0
2020-11-09 17:00:00	QQQ	ETF	288.85	289.78	288.51	289.5	147181.0
2020-11-09 18:00:00	QQQ	ETF	289.46	290.26	288.98	289.199	165259.0
2020-11-09 19:00:00	QQQ	ETF	289.24	289.38	287.69	288.59	188492.0
2020-11-09 04:00:00	IWM	ETF	165.55	165.89	165.16	165.64	32672.0
2020-11-09 05:00:00	IWM	ETF	165.68	165.92	165.51	165.81	20946.0
2020-11-09 06:00:00	IWM	ETF	165.76	181.73	165.4	175.0	496496.0
2020-11-09 07:00:00	IWM	ETF	174.73	176.15	172.0	175.67	1176605.0
2020-11-09 08:00:00	IWM	ETF	173.7499	176.35	165.5	176.05	1052998.0
2020-11-09 09:00:00	IWM	ETF	176.05	178.1	172.725	172.81	9955854.0
2020-11-09 10:00:00	IWM	ETF	172.79	173.89	171.91	173.07	9931232.0
2020-11-09 11:00:00	IWM	ETF	173.06	173.2	171.25	171.495	5964759.0
2020-11-09 12:00:00	IWM	ETF	171.5	173.27	171.27	173.12	3890247.0
2020-11-09 13:00:00	IWM	ETF	173.14	173.71	172.75	173.05	2493332.0
2020-11-09 14:00:00	IWM	ETF	173.06	173.13	172.1	172.32	2493991.0
2020-11-09 15:00:00	IWM	ETF	172.33	172.79	169.33	169.71	6044844.0
2020-11-09 16:00:00	IWM	ETF	169.7	170.3	169.32	169.82	2400096.0
2020-11-09 17:00:00	IWM	ETF	169.91	170.36	169.76	170.2	67673.0
2020-11-09 18:00:00	IWM	ETF	170.04	170.55	169.8	169.94	64102.0
2020-11-09 19:00:00	IWM	ETF	169.89	170.22	169.0	169.43	42739.0
2020-11-09 04:00:00	DIA	ETF	286.59	287.27	286.59	287.05	1400.0
2020-11-09 05:00:00	DIA	ETF	287.06	287.49	286.8	287.49	1165.0

> showing 50 of 14,780 rows — these rows as CSV

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