PREVIEW / etf_1hour / 2021-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-14.parquet
  size:    409 KB
  rows:    14,291

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
2021-07-14 04:00:00	SPY	ETF	435.12	435.51	434.8	435.26	14035.0
2021-07-14 05:00:00	SPY	ETF	435.56	436.0	435.51	435.69	44294.0
2021-07-14 06:00:00	SPY	ETF	435.69	436.01	435.69	435.87	12444.0
2021-07-14 07:00:00	SPY	ETF	435.8	436.38	435.8	436.33	123375.0
2021-07-14 08:00:00	SPY	ETF	435.9201	437.5	435.07	437.31	649449.0
2021-07-14 09:00:00	SPY	ETF	437.34	437.92	436.93	437.01	5352478.0
2021-07-14 10:00:00	SPY	ETF	437.02	437.45	436.51	437.01	4909487.0
2021-07-14 11:00:00	SPY	ETF	436.9989	437.0281	434.91	434.99	7134586.0
2021-07-14 12:00:00	SPY	ETF	434.99	436.7699	434.96	436.5	5181111.0
2021-07-14 13:00:00	SPY	ETF	436.5082	436.635	435.82	436.48	3547392.0
2021-07-14 14:00:00	SPY	ETF	436.49	436.97	436.38	436.62	3565781.0
2021-07-14 15:00:00	SPY	ETF	436.62	437.08	436.005	436.22	13909266.0
2021-07-14 16:00:00	SPY	ETF	436.21	436.54	436.04	436.08	2593204.0
2021-07-14 17:00:00	SPY	ETF	436.13	436.19	436.1	436.13	56686.0
2021-07-14 18:00:00	SPY	ETF	436.12	436.28	435.99	436.19	88295.0
2021-07-14 19:00:00	SPY	ETF	436.17	436.3	436.04	436.23	55447.0
2021-07-14 04:00:00	QQQ	ETF	362.47	362.9	362.17	362.8	24273.0
2021-07-14 05:00:00	QQQ	ETF	362.89	363.9	362.89	363.53	175778.0
2021-07-14 06:00:00	QQQ	ETF	363.5	363.64	363.42	363.52	22776.0
2021-07-14 07:00:00	QQQ	ETF	363.51	364.06	363.25	364.03	150127.0
2021-07-14 08:00:00	QQQ	ETF	363.4304	364.92	362.63	364.79	457793.0
2021-07-14 09:00:00	QQQ	ETF	364.77	365.375	364.02	364.2506	4456151.0
2021-07-14 10:00:00	QQQ	ETF	364.27	365.49	364.06	365.14	4682296.0
2021-07-14 11:00:00	QQQ	ETF	365.1499	365.27	362.22	362.2939	4984574.0
2021-07-14 12:00:00	QQQ	ETF	362.2902	364.27	362.24	363.93	3251589.0
2021-07-14 13:00:00	QQQ	ETF	363.94	364.1	362.97	363.35	1906848.0
2021-07-14 14:00:00	QQQ	ETF	363.38	364.17	363.27	363.9151	1663761.0
2021-07-14 15:00:00	QQQ	ETF	363.915	364.29	362.67	362.98	5680092.0
2021-07-14 16:00:00	QQQ	ETF	362.98	363.33	362.98	363.0	631995.0
2021-07-14 17:00:00	QQQ	ETF	363.06	363.13	363.0	363.07	65450.0
2021-07-14 18:00:00	QQQ	ETF	363.06	363.22	362.97	363.12	62061.0
2021-07-14 19:00:00	QQQ	ETF	363.17	363.25	363.07	363.19	58570.0
2021-07-14 04:00:00	IWM	ETF	222.49	222.72	222.3	222.34	6425.0
2021-07-14 05:00:00	IWM	ETF	222.53	222.75	222.53	222.58	9980.0
2021-07-14 06:00:00	IWM	ETF	222.64	223.06	222.64	222.93	37787.0
2021-07-14 07:00:00	IWM	ETF	222.86	223.14	222.81	223.03	51994.0
2021-07-14 08:00:00	IWM	ETF	222.93	224.0	222.3	223.9	212986.0
2021-07-14 09:00:00	IWM	ETF	223.87	224.355	222.155	222.6019	3712004.0
2021-07-14 10:00:00	IWM	ETF	222.62	223.19	221.221	221.52	4015159.0
2021-07-14 11:00:00	IWM	ETF	221.5	221.525	219.2	219.39	5048747.0
2021-07-14 12:00:00	IWM	ETF	219.39	220.85	219.33	220.83	2810574.0
2021-07-14 13:00:00	IWM	ETF	220.805	220.87	219.76	219.94	1922278.0
2021-07-14 14:00:00	IWM	ETF	219.95	220.15	219.03	219.57	2319921.0
2021-07-14 15:00:00	IWM	ETF	219.56	220.05	218.55	218.87	5154724.0
2021-07-14 16:00:00	IWM	ETF	218.87	218.97	218.6	218.71	1030829.0
2021-07-14 17:00:00	IWM	ETF	218.87	218.87	218.61	218.73	79574.0
2021-07-14 18:00:00	IWM	ETF	218.7	218.88	218.65	218.73	20924.0
2021-07-14 19:00:00	IWM	ETF	218.74	218.8	218.57	218.69	51287.0
2021-07-14 04:00:00	DIA	ETF	348.87	348.9	348.52	348.52	13900.0
2021-07-14 05:00:00	DIA	ETF	348.82	349.02	348.82	349.02	4400.0

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

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