PREVIEW / etf_1hour / 2021-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-26.parquet
  size:    428 KB
  rows:    15,198

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-02-26 04:00:00	SPY	ETF	384.1	384.1	382.94	383.25	55481.0
2021-02-26 05:00:00	SPY	ETF	383.37	383.69	382.39	382.46	51639.0
2021-02-26 06:00:00	SPY	ETF	382.2	382.81	380.52	381.42	95411.0
2021-02-26 07:00:00	SPY	ETF	381.48	383.52	381.45	382.12	608893.0
2021-02-26 08:00:00	SPY	ETF	382.15	384.5	380.4	384.19	917062.0
2021-02-26 09:00:00	SPY	ETF	384.15	384.88	381.91	382.07	14731908.0
2021-02-26 10:00:00	SPY	ETF	382.06	382.95	378.23	382.37	30855528.0
2021-02-26 11:00:00	SPY	ETF	382.37	384.23	381.41	383.51	11223439.0
2021-02-26 12:00:00	SPY	ETF	383.505	385.58	382.95	383.58	7383261.0
2021-02-26 13:00:00	SPY	ETF	383.58	384.71	381.9	382.19	9475805.0
2021-02-26 14:00:00	SPY	ETF	382.1905	383.27	381.02	382.95	12063320.0
2021-02-26 15:00:00	SPY	ETF	382.94	384.81	380.2	380.32	26230453.0
2021-02-26 16:00:00	SPY	ETF	380.32	380.9	378.83	380.54	9048387.0
2021-02-26 17:00:00	SPY	ETF	380.59	380.59	379.97	380.27	290453.0
2021-02-26 18:00:00	SPY	ETF	380.27	380.34	379.67	380.1	108306.0
2021-02-26 19:00:00	SPY	ETF	380.1	380.1	379.67	379.71	51770.0
2021-02-26 04:00:00	QQQ	ETF	314.27	314.33	312.93	313.8	330421.0
2021-02-26 05:00:00	QQQ	ETF	313.6	313.6	311.81	311.84	302710.0
2021-02-26 06:00:00	QQQ	ETF	311.77	312.71	310.14	311.2	214234.0
2021-02-26 07:00:00	QQQ	ETF	311.23	314.4	311.19	313.04	1095093.0
2021-02-26 08:00:00	QQQ	ETF	313.08	316.19	308.91	315.93	2300949.0
2021-02-26 09:00:00	QQQ	ETF	315.9	317.75	313.54	313.94	11825949.0
2021-02-26 10:00:00	QQQ	ETF	313.97	316.4	310.88	315.9599	19248005.0
2021-02-26 11:00:00	QQQ	ETF	315.94	317.605	314.43	317.3	8908221.0
2021-02-26 12:00:00	QQQ	ETF	317.29	319.11	316.33	316.86	7646219.0
2021-02-26 13:00:00	QQQ	ETF	316.88	318.37	315.48	315.89	6898051.0
2021-02-26 14:00:00	QQQ	ETF	315.9	317.27	314.83	316.73	7430883.0
2021-02-26 15:00:00	QQQ	ETF	316.71	318.52	314.3	314.36	11847760.0
2021-02-26 16:00:00	QQQ	ETF	314.36	317.67	313.46	314.68	2896221.0
2021-02-26 17:00:00	QQQ	ETF	314.69	314.9	313.99	314.25	349399.0
2021-02-26 18:00:00	QQQ	ETF	314.21	314.39	314.03	314.3	54508.0
2021-02-26 19:00:00	QQQ	ETF	314.2	314.39	314.0	314.0	19947.0
2021-02-26 04:00:00	IWM	ETF	218.02	219.0	218.02	218.61	37650.0
2021-02-26 05:00:00	IWM	ETF	218.28	218.83	217.64	217.74	46838.0
2021-02-26 06:00:00	IWM	ETF	217.91	218.08	216.27	216.91	21756.0
2021-02-26 07:00:00	IWM	ETF	217.11	219.21	217.08	217.88	197560.0
2021-02-26 08:00:00	IWM	ETF	217.3001	219.27	214.9	219.06	358847.0
2021-02-26 09:00:00	IWM	ETF	218.95	221.66	218.5	218.77	4667287.0
2021-02-26 10:00:00	IWM	ETF	218.79	218.87	214.81	217.62	7130194.0
2021-02-26 11:00:00	IWM	ETF	217.68	220.46	217.4	219.85	3438522.0
2021-02-26 12:00:00	IWM	ETF	219.85	222.23	219.74	221.03	3430100.0
2021-02-26 13:00:00	IWM	ETF	221.05	221.98	219.37	219.96	3998099.0
2021-02-26 14:00:00	IWM	ETF	220.0	220.51	218.19	219.865	2867741.0
2021-02-26 15:00:00	IWM	ETF	219.92	221.08	218.28	218.31	6634817.0
2021-02-26 16:00:00	IWM	ETF	218.31	220.2	217.26	218.25	2299627.0
2021-02-26 17:00:00	IWM	ETF	218.25	218.62	217.63	217.83	867311.0
2021-02-26 18:00:00	IWM	ETF	218.16	218.24	218.05	218.05	31432.0
2021-02-26 19:00:00	IWM	ETF	217.98	218.17	217.84	218.1	13037.0
2021-02-26 04:00:00	DIA	ETF	314.13	314.34	314.05	314.12	2100.0
2021-02-26 05:00:00	DIA	ETF	314.14	314.45	313.68	313.68	1590.0

> showing 50 of 15,198 rows — these rows as CSV

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