PREVIEW / etf_1hour / 2020-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-19.parquet
  size:    374 KB
  rows:    12,690

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-10-19 04:00:00	SPY	ETF	348.6	349.23	348.56	349.01	53743.0
2020-10-19 05:00:00	SPY	ETF	349.18	349.43	348.93	349.09	43589.0
2020-10-19 06:00:00	SPY	ETF	349.13	349.19	348.65	349.17	147464.0
2020-10-19 07:00:00	SPY	ETF	349.15	349.24	348.83	348.85	126403.0
2020-10-19 08:00:00	SPY	ETF	348.84	349.35	348.3	348.49	319343.0
2020-10-19 09:00:00	SPY	ETF	348.5	349.33	347.29	348.49	4060280.0
2020-10-19 10:00:00	SPY	ETF	348.4722	348.49	346.3563	347.13	7945870.0
2020-10-19 11:00:00	SPY	ETF	347.12	347.37	345.6	346.255	5167996.0
2020-10-19 12:00:00	SPY	ETF	346.24	346.65	345.63	346.16	3728531.0
2020-10-19 13:00:00	SPY	ETF	346.164	346.3664	344.55	344.84	4160894.0
2020-10-19 14:00:00	SPY	ETF	344.82	345.17	342.19	342.25	10186807.0
2020-10-19 15:00:00	SPY	ETF	342.26	342.71	341.04	342.02	23362843.0
2020-10-19 16:00:00	SPY	ETF	342.02	343.44	341.8151	343.33	7878525.0
2020-10-19 17:00:00	SPY	ETF	343.35	343.4	342.01	343.4	157570.0
2020-10-19 18:00:00	SPY	ETF	343.42	344.06	343.39	343.78	166586.0
2020-10-19 19:00:00	SPY	ETF	343.83	343.96	343.75	343.88	154598.0
2020-10-19 04:00:00	QQQ	ETF	290.57	291.18	290.11	290.97	57660.0
2020-10-19 05:00:00	QQQ	ETF	291.03	291.41	290.77	290.99	45915.0
2020-10-19 06:00:00	QQQ	ETF	290.9	291.06	290.5	291.04	37714.0
2020-10-19 07:00:00	QQQ	ETF	290.96	291.03	290.5	290.74	131661.0
2020-10-19 08:00:00	QQQ	ETF	290.9	291.0	289.9	290.22	205851.0
2020-10-19 09:00:00	QQQ	ETF	290.26	291.48	289.57	289.63	3050557.0
2020-10-19 10:00:00	QQQ	ETF	289.62	289.9	286.76	287.82	5439812.0
2020-10-19 11:00:00	QQQ	ETF	287.8	288.79	287.03	287.43	2518332.0
2020-10-19 12:00:00	QQQ	ETF	287.39	287.99	286.51	287.6	2871318.0
2020-10-19 13:00:00	QQQ	ETF	287.58	287.92	285.84	286.49	2457184.0
2020-10-19 14:00:00	QQQ	ETF	286.43	286.93	284.21	284.24	4250805.0
2020-10-19 15:00:00	QQQ	ETF	284.27	284.39	282.79	283.69	7970239.0
2020-10-19 16:00:00	QQQ	ETF	283.69	285.35	283.4937	285.24	1266704.0
2020-10-19 17:00:00	QQQ	ETF	285.2	285.44	285.03	285.44	173517.0
2020-10-19 18:00:00	QQQ	ETF	285.42	285.87	285.3	285.6	180340.0
2020-10-19 19:00:00	QQQ	ETF	285.64	285.9	285.5	285.79	79910.0
2020-10-19 04:00:00	IWM	ETF	163.08	163.26	162.95	163.14	35323.0
2020-10-19 05:00:00	IWM	ETF	163.18	163.34	162.98	163.1	4934.0
2020-10-19 06:00:00	IWM	ETF	163.1	163.1	162.62	163.1	148232.0
2020-10-19 07:00:00	IWM	ETF	163.1	163.21	162.88	162.88	60664.0
2020-10-19 08:00:00	IWM	ETF	162.88	163.33	162.78	162.9	62360.0
2020-10-19 09:00:00	IWM	ETF	162.93	164.03	162.56	163.46	1983895.0
2020-10-19 10:00:00	IWM	ETF	163.46	163.46	162.59	163.35	1981210.0
2020-10-19 11:00:00	IWM	ETF	163.35	163.59	162.74	162.95	1510161.0
2020-10-19 12:00:00	IWM	ETF	162.95	163.03	162.5	162.63	864444.0
2020-10-19 13:00:00	IWM	ETF	162.62	162.8	162.01	162.075	1055090.0
2020-10-19 14:00:00	IWM	ETF	162.07	162.16	160.76	160.78	1863022.0
2020-10-19 15:00:00	IWM	ETF	160.79	161.03	160.03	160.42	4961645.0
2020-10-19 16:00:00	IWM	ETF	160.41	161.12	160.33	161.07	1007634.0
2020-10-19 17:00:00	IWM	ETF	160.99	161.16	160.41	161.16	14894.0
2020-10-19 18:00:00	IWM	ETF	161.2	161.44	161.11	161.38	20322.0
2020-10-19 19:00:00	IWM	ETF	161.35	161.4	161.28	161.4	7201.0
2020-10-19 04:00:00	DIA	ETF	286.36	287.29	286.36	287.23	3080.0
2020-10-19 05:00:00	DIA	ETF	287.5	287.5	287.29	287.33	900.0

> showing 50 of 12,690 rows — these rows as CSV

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