PREVIEW / etf_1hour / 2020-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-20.parquet
  size:    383 KB
  rows:    12,974

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-11-20 04:00:00	SPY	ETF	356.68	357.57	356.47	357.22	59916.0
2020-11-20 05:00:00	SPY	ETF	357.2	357.92	357.11	357.54	47394.0
2020-11-20 06:00:00	SPY	ETF	357.5	358.0	357.38	357.97	30304.0
2020-11-20 07:00:00	SPY	ETF	358.08	358.19	357.49	357.63	267763.0
2020-11-20 08:00:00	SPY	ETF	357.64	358.1601	356.1	357.05	266656.0
2020-11-20 09:00:00	SPY	ETF	357.05	357.8	356.54	357.04	5996302.0
2020-11-20 10:00:00	SPY	ETF	357.039	357.2	356.18	356.86	10978702.0
2020-11-20 11:00:00	SPY	ETF	356.87	357.56	356.44	356.88	6348614.0
2020-11-20 12:00:00	SPY	ETF	356.87	357.02	356.55	356.91	2915206.0
2020-11-20 13:00:00	SPY	ETF	356.9	357.33	356.6	357.16	4800594.0
2020-11-20 14:00:00	SPY	ETF	357.17	357.44	356.67	356.84	3751646.0
2020-11-20 15:00:00	SPY	ETF	356.86	357.065	355.25	355.35	15232473.0
2020-11-20 16:00:00	SPY	ETF	355.34	357.8193	354.25	355.17	18268147.0
2020-11-20 17:00:00	SPY	ETF	355.22	355.45	354.75	354.85	527129.0
2020-11-20 18:00:00	SPY	ETF	354.8	355.33	354.76	354.9	32296.0
2020-11-20 19:00:00	SPY	ETF	354.92	355.26	354.8	355.0	39497.0
2020-11-20 04:00:00	QQQ	ETF	292.35	292.62	291.98	292.48	31855.0
2020-11-20 05:00:00	QQQ	ETF	292.43	292.8	292.25	292.8	30458.0
2020-11-20 06:00:00	QQQ	ETF	292.73	292.9	292.64	292.85	16397.0
2020-11-20 07:00:00	QQQ	ETF	292.9	293.16	292.79	292.82	107239.0
2020-11-20 08:00:00	QQQ	ETF	293.0599	293.08	291.92	292.43	135898.0
2020-11-20 09:00:00	QQQ	ETF	292.39	292.56	291.37	291.8401	2206917.0
2020-11-20 10:00:00	QQQ	ETF	291.859	292.9	291.65	292.57	2331452.0
2020-11-20 11:00:00	QQQ	ETF	292.59	293.065	291.89	292.119	2220324.0
2020-11-20 12:00:00	QQQ	ETF	292.1	292.65	291.93	292.4741	953772.0
2020-11-20 13:00:00	QQQ	ETF	292.47	292.69	291.99	292.41	1294031.0
2020-11-20 14:00:00	QQQ	ETF	292.415	292.65	292.0404	292.1828	1192340.0
2020-11-20 15:00:00	QQQ	ETF	292.24	292.31	290.29	290.36	4896653.0
2020-11-20 16:00:00	QQQ	ETF	290.38	291.1486	289.65	290.46	1829236.0
2020-11-20 17:00:00	QQQ	ETF	290.42	290.47	290.23	290.33	604614.0
2020-11-20 18:00:00	QQQ	ETF	290.44	290.5	290.21	290.29	261285.0
2020-11-20 19:00:00	QQQ	ETF	290.38	290.45	290.08	290.26	8984.0
2020-11-20 04:00:00	IWM	ETF	176.32	177.02	176.26	176.77	9982.0
2020-11-20 05:00:00	IWM	ETF	176.78	177.25	176.69	177.07	18140.0
2020-11-20 06:00:00	IWM	ETF	177.05	177.24	177.05	177.17	10841.0
2020-11-20 07:00:00	IWM	ETF	177.24	177.34	176.92	176.92	140368.0
2020-11-20 08:00:00	IWM	ETF	177.26	177.26	176.12	176.81	226672.0
2020-11-20 09:00:00	IWM	ETF	176.8	177.13	175.83	176.355	1864208.0
2020-11-20 10:00:00	IWM	ETF	176.365	176.95	176.275	176.6099	1710967.0
2020-11-20 11:00:00	IWM	ETF	176.6	177.44	176.42	177.43	2102462.0
2020-11-20 12:00:00	IWM	ETF	177.41	177.52	176.99	177.24	1352910.0
2020-11-20 13:00:00	IWM	ETF	177.24	177.57	177.11	177.4617	1194665.0
2020-11-20 14:00:00	IWM	ETF	177.475	177.78	177.12	177.41	1407001.0
2020-11-20 15:00:00	IWM	ETF	177.4	177.94	176.82	177.44	3881799.0
2020-11-20 16:00:00	IWM	ETF	177.5	177.63	176.87	177.38	2313790.0
2020-11-20 17:00:00	IWM	ETF	177.36	177.5	177.14	177.22	283036.0
2020-11-20 18:00:00	IWM	ETF	177.14	177.5	177.14	177.5	394572.0
2020-11-20 19:00:00	IWM	ETF	177.12	177.17	177.12	177.15	2335.0
2020-11-20 04:00:00	DIA	ETF	294.14	294.37	294.02	294.02	1300.0
2020-11-20 05:00:00	DIA	ETF	293.98	294.73	293.98	294.66	2977.0

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

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