PREVIEW / etf_1hour / 2021-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-05.parquet
  size:    418 KB
  rows:    14,458

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-05 04:00:00	SPY	ETF	387.06	387.66	386.88	387.47	40230.0
2021-02-05 05:00:00	SPY	ETF	387.46	387.98	387.46	387.78	17248.0
2021-02-05 06:00:00	SPY	ETF	387.97	388.24	387.89	388.14	40472.0
2021-02-05 07:00:00	SPY	ETF	388.11	388.12	387.72	387.8	141139.0
2021-02-05 08:00:00	SPY	ETF	387.8	388.09	386.81	387.55	332606.0
2021-02-05 09:00:00	SPY	ETF	387.7	388.29	386.19	387.14	4757134.0
2021-02-05 10:00:00	SPY	ETF	387.15	387.98	386.485	387.695	5630844.0
2021-02-05 11:00:00	SPY	ETF	387.69	387.855	387.11	387.32	3082015.0
2021-02-05 12:00:00	SPY	ETF	387.315	388.46	387.18	388.4378	2477579.0
2021-02-05 13:00:00	SPY	ETF	388.4396	388.47	387.563	387.5854	2498246.0
2021-02-05 14:00:00	SPY	ETF	387.5978	388.03	387.32	387.51	2570376.0
2021-02-05 15:00:00	SPY	ETF	387.52	387.81	387.18	387.68	7800357.0
2021-02-05 16:00:00	SPY	ETF	387.67	388.15	387.58	388.07	3667712.0
2021-02-05 17:00:00	SPY	ETF	388.04	388.2	387.7	388.0	183037.0
2021-02-05 18:00:00	SPY	ETF	388.03	388.17	388.0	388.0	19034.0
2021-02-05 19:00:00	SPY	ETF	388.08	388.3	388.01	388.19	22959.0
2021-02-05 04:00:00	QQQ	ETF	331.16	331.39	330.76	331.18	40686.0
2021-02-05 05:00:00	QQQ	ETF	331.15	331.49	331.06	331.29	48196.0
2021-02-05 06:00:00	QQQ	ETF	331.33	331.6	331.03	331.38	47094.0
2021-02-05 07:00:00	QQQ	ETF	331.44	331.6	331.27	331.3	91904.0
2021-02-05 08:00:00	QQQ	ETF	331.33	332.05	330.24	331.09	475156.0
2021-02-05 09:00:00	QQQ	ETF	331.03	331.42	329.93	330.03	2815071.0
2021-02-05 10:00:00	QQQ	ETF	329.98	330.78	329.53	330.64	2665700.0
2021-02-05 11:00:00	QQQ	ETF	330.64	330.939	329.99	330.635	1738194.0
2021-02-05 12:00:00	QQQ	ETF	330.638	332.25	330.51	332.24	1981434.0
2021-02-05 13:00:00	QQQ	ETF	332.22	332.4025	331.1	331.1701	1779486.0
2021-02-05 14:00:00	QQQ	ETF	331.175	331.8399	330.96	331.36	1713637.0
2021-02-05 15:00:00	QQQ	ETF	331.35	331.55	330.73	331.4	3010094.0
2021-02-05 16:00:00	QQQ	ETF	331.4	331.75	331.22	331.6	692219.0
2021-02-05 17:00:00	QQQ	ETF	331.58	331.62	331.25	331.3	294508.0
2021-02-05 18:00:00	QQQ	ETF	331.44	331.5	331.31	331.5	6943.0
2021-02-05 19:00:00	QQQ	ETF	331.51	331.7	331.43	331.56	13252.0
2021-02-05 04:00:00	IWM	ETF	219.44	220.49	219.26	220.12	29029.0
2021-02-05 05:00:00	IWM	ETF	220.13	220.65	220.11	220.58	5204.0
2021-02-05 06:00:00	IWM	ETF	220.69	220.95	220.56	220.67	13600.0
2021-02-05 07:00:00	IWM	ETF	220.62	220.69	220.24	220.44	61034.0
2021-02-05 08:00:00	IWM	ETF	220.62	220.9196	219.19	220.37	222458.0
2021-02-05 09:00:00	IWM	ETF	220.42	221.16	220.04	220.11	2537034.0
2021-02-05 10:00:00	IWM	ETF	220.09	221.05	218.77	220.835	2828867.0
2021-02-05 11:00:00	IWM	ETF	220.84	221.47	220.5649	220.69	1614939.0
2021-02-05 12:00:00	IWM	ETF	220.69	221.2	220.369	220.775	1199010.0
2021-02-05 13:00:00	IWM	ETF	220.76	220.79	220.205	220.27	1252753.0
2021-02-05 14:00:00	IWM	ETF	220.28	221.27	220.06	221.26	1511024.0
2021-02-05 15:00:00	IWM	ETF	221.25	221.84	220.8301	221.65	3514346.0
2021-02-05 16:00:00	IWM	ETF	221.64	222.08	221.4253	221.98	2513764.0
2021-02-05 17:00:00	IWM	ETF	221.97	222.45	221.65	222.2	472639.0
2021-02-05 18:00:00	IWM	ETF	222.16	222.38	222.13	222.22	8079.0
2021-02-05 19:00:00	IWM	ETF	222.22	222.26	222.06	222.26	4275.0
2021-02-05 04:00:00	DIA	ETF	311.35	311.79	311.35	311.69	1990.0
2021-02-05 05:00:00	DIA	ETF	312.0	312.1	311.9	311.97	1900.0

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

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