PREVIEW / etf_1hour / 2021-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-03.parquet
  size:    430 KB
  rows:    14,947

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-03-03 04:00:00	SPY	ETF	388.78	389.46	388.63	388.91	119087.0
2021-03-03 05:00:00	SPY	ETF	388.99	389.11	388.54	388.85	81035.0
2021-03-03 06:00:00	SPY	ETF	388.87	388.92	388.5	388.81	162914.0
2021-03-03 07:00:00	SPY	ETF	388.87	388.97	388.05	388.1	189628.0
2021-03-03 08:00:00	SPY	ETF	388.84	388.99	385.12	385.77	1369355.0
2021-03-03 09:00:00	SPY	ETF	385.79	386.83	384.33	384.5101	12681776.0
2021-03-03 10:00:00	SPY	ETF	384.49	385.45	383.11	385.1411	19411903.0
2021-03-03 11:00:00	SPY	ETF	385.13	386.45	384.77	385.41	9265060.0
2021-03-03 12:00:00	SPY	ETF	385.43	385.62	384.54	384.58	5716004.0
2021-03-03 13:00:00	SPY	ETF	384.57	385.83	383.78	384.13	8418223.0
2021-03-03 14:00:00	SPY	ETF	384.13	384.32	382.23	384.035	15945509.0
2021-03-03 15:00:00	SPY	ETF	384.04	384.36	381.31	381.45	22006060.0
2021-03-03 16:00:00	SPY	ETF	381.46	382.001	381.1	381.27	7019259.0
2021-03-03 17:00:00	SPY	ETF	381.23	381.57	381.23	381.45	117298.0
2021-03-03 18:00:00	SPY	ETF	381.45	381.72	379.38	379.43	317460.0
2021-03-03 19:00:00	SPY	ETF	379.48	381.1	379.17	380.91	202473.0
2021-03-03 04:00:00	QQQ	ETF	320.66	321.4	320.41	320.72	62252.0
2021-03-03 05:00:00	QQQ	ETF	320.61	320.76	320.01	320.64	30205.0
2021-03-03 06:00:00	QQQ	ETF	320.63	320.78	320.22	320.65	74240.0
2021-03-03 07:00:00	QQQ	ETF	320.65	320.72	319.52	319.78	320153.0
2021-03-03 08:00:00	QQQ	ETF	319.81	321.5	316.27	316.99	1391628.0
2021-03-03 09:00:00	QQQ	ETF	316.9	318.24	314.38	314.69	8326149.0
2021-03-03 10:00:00	QQQ	ETF	314.69	315.1	312.62	314.75	11738575.0
2021-03-03 11:00:00	QQQ	ETF	314.75	316.26	314.33	314.38	6410621.0
2021-03-03 12:00:00	QQQ	ETF	314.39	314.7	312.48	312.51	5577679.0
2021-03-03 13:00:00	QQQ	ETF	312.5	313.79	311.03	311.4148	7298273.0
2021-03-03 14:00:00	QQQ	ETF	311.419	311.5	309.1	311.1989	13030519.0
2021-03-03 15:00:00	QQQ	ETF	311.2	311.51	309.1	309.1701	12501457.0
2021-03-03 16:00:00	QQQ	ETF	309.17	310.95	308.78	309.21	2018333.0
2021-03-03 17:00:00	QQQ	ETF	309.15	309.45	309.14	309.35	77945.0
2021-03-03 18:00:00	QQQ	ETF	309.31	309.59	306.98	306.98	379850.0
2021-03-03 19:00:00	QQQ	ETF	307.11	308.45	306.87	308.29	292565.0
2021-03-03 04:00:00	IWM	ETF	224.78	225.28	224.24	224.47	12649.0
2021-03-03 05:00:00	IWM	ETF	224.45	224.5	224.0	224.15	11300.0
2021-03-03 06:00:00	IWM	ETF	224.07	224.29	223.86	224.03	36199.0
2021-03-03 07:00:00	IWM	ETF	224.04	224.23	223.77	223.77	86169.0
2021-03-03 08:00:00	IWM	ETF	224.0796	225.0	221.34	222.17	411438.0
2021-03-03 09:00:00	IWM	ETF	221.9	224.14	221.2	221.42	2543016.0
2021-03-03 10:00:00	IWM	ETF	221.37	223.04	219.85	222.83	4534791.0
2021-03-03 11:00:00	IWM	ETF	222.83	224.26	222.62	223.185	3123433.0
2021-03-03 12:00:00	IWM	ETF	223.2	223.455	222.37	222.53	1791345.0
2021-03-03 13:00:00	IWM	ETF	222.525	223.84	221.63	221.87	2345286.0
2021-03-03 14:00:00	IWM	ETF	221.87	222.01	219.75	221.871	3707206.0
2021-03-03 15:00:00	IWM	ETF	221.87	222.24	219.21	219.26	6569269.0
2021-03-03 16:00:00	IWM	ETF	219.2599	219.59	218.9	219.07	998061.0
2021-03-03 17:00:00	IWM	ETF	218.92	219.28	218.92	219.27	9147.0
2021-03-03 18:00:00	IWM	ETF	219.2	219.62	217.28	217.28	70361.0
2021-03-03 19:00:00	IWM	ETF	217.21	218.84	217.21	218.68	39932.0
2021-03-03 04:00:00	DIA	ETF	316.05	316.26	316.05	316.15	1600.0
2021-03-03 05:00:00	DIA	ETF	316.42	316.43	316.12	316.24	600.0

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

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