PREVIEW / etf_1hour / 2020-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-31.parquet
  size:    400 KB
  rows:    13,749

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-12-31 04:00:00	SPY	ETF	371.36	371.53	371.0	371.26	13480.0
2020-12-31 05:00:00	SPY	ETF	371.26	371.95	371.2	371.88	16348.0
2020-12-31 06:00:00	SPY	ETF	371.89	372.33	371.79	372.18	20440.0
2020-12-31 07:00:00	SPY	ETF	372.1	372.26	371.7	371.78	109401.0
2020-12-31 08:00:00	SPY	ETF	371.76	372.2996	371.39	371.72	127514.0
2020-12-31 09:00:00	SPY	ETF	371.7	371.85	371.232	371.6467	3370585.0
2020-12-31 10:00:00	SPY	ETF	371.66	372.23	371.66	371.8055	5020841.0
2020-12-31 11:00:00	SPY	ETF	371.79	371.995	371.285	371.37	3686960.0
2020-12-31 12:00:00	SPY	ETF	371.365	372.09	371.32	371.905	3658271.0
2020-12-31 13:00:00	SPY	ETF	371.91	371.98	371.59	371.75	2566695.0
2020-12-31 14:00:00	SPY	ETF	371.75	373.04	371.46	372.7889	8357334.0
2020-12-31 15:00:00	SPY	ETF	372.785	374.66	372.78	373.85	25880893.0
2020-12-31 16:00:00	SPY	ETF	373.85	374.69	373.84	374.3	21487567.0
2020-12-31 17:00:00	SPY	ETF	374.25	374.42	374.13	374.39	1660849.0
2020-12-31 18:00:00	SPY	ETF	374.39	374.41	374.39	374.4	18666.0
2020-12-31 19:00:00	SPY	ETF	374.39	374.41	374.26	374.39	39799.0
2020-12-31 04:00:00	QQQ	ETF	312.97	313.04	312.79	312.96	11950.0
2020-12-31 05:00:00	QQQ	ETF	312.9	313.2	312.9	313.16	9571.0
2020-12-31 06:00:00	QQQ	ETF	313.16	313.39	313.14	313.33	12056.0
2020-12-31 07:00:00	QQQ	ETF	313.29	313.43	313.14	313.21	54700.0
2020-12-31 08:00:00	QQQ	ETF	313.33	313.4002	312.92	313.02	35981.0
2020-12-31 09:00:00	QQQ	ETF	313.0	313.28	312.425	312.68	2111834.0
2020-12-31 10:00:00	QQQ	ETF	312.69	313.25	312.69	313.01	2268899.0
2020-12-31 11:00:00	QQQ	ETF	313.005	313.15	311.76	311.89	1871640.0
2020-12-31 12:00:00	QQQ	ETF	311.92	312.65	311.825	312.45	1182997.0
2020-12-31 13:00:00	QQQ	ETF	312.47	312.52	312.21	312.23	1083871.0
2020-12-31 14:00:00	QQQ	ETF	312.23	313.04	311.98	312.87	1796368.0
2020-12-31 15:00:00	QQQ	ETF	312.88	314.24	312.75	313.59	5183231.0
2020-12-31 16:00:00	QQQ	ETF	313.59	314.15	313.56	313.99	882628.0
2020-12-31 17:00:00	QQQ	ETF	313.89	313.99	313.89	313.89	443137.0
2020-12-31 18:00:00	QQQ	ETF	313.94	313.94	313.83	313.83	4920.0
2020-12-31 19:00:00	QQQ	ETF	313.93	313.93	313.78	313.85	13954.0
2020-12-31 04:00:00	IWM	ETF	195.8	195.9	195.5	195.72	20159.0
2020-12-31 05:00:00	IWM	ETF	195.72	196.12	195.72	196.12	5200.0
2020-12-31 06:00:00	IWM	ETF	196.21	196.62	196.2	196.5	8200.0
2020-12-31 07:00:00	IWM	ETF	196.57	196.57	196.2	196.27	27350.0
2020-12-31 08:00:00	IWM	ETF	196.2899	196.53	195.59	196.18	53627.0
2020-12-31 09:00:00	IWM	ETF	196.1	196.72	194.62	194.92	2187606.0
2020-12-31 10:00:00	IWM	ETF	194.93	196.45	194.86	196.29	1823651.0
2020-12-31 11:00:00	IWM	ETF	196.29	196.54	195.93	196.22	1291799.0
2020-12-31 12:00:00	IWM	ETF	196.24	196.47	195.98	196.28	1220263.0
2020-12-31 13:00:00	IWM	ETF	196.29	196.405	196.05	196.13	1353387.0
2020-12-31 14:00:00	IWM	ETF	196.125	196.8399	196.05	196.45	1626711.0
2020-12-31 15:00:00	IWM	ETF	196.44	196.8	196.04	196.13	6086822.0
2020-12-31 16:00:00	IWM	ETF	196.14	196.53	195.7	196.5	2989127.0
2020-12-31 17:00:00	IWM	ETF	196.5	196.5864	196.27	196.31	123004.0
2020-12-31 18:00:00	IWM	ETF	196.33	196.5	196.33	196.35	9366.0
2020-12-31 19:00:00	IWM	ETF	196.35	196.35	196.32	196.33	11018.0
2020-12-31 04:00:00	DIA	ETF	303.7	303.7	303.52	303.63	1232.0
2020-12-31 05:00:00	DIA	ETF	303.53	304.03	303.53	304.03	3200.0

> showing 50 of 13,749 rows — these rows as CSV

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