PREVIEW / etf_1hour / 2021-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-13.parquet
  size:    415 KB
  rows:    14,183

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-01-13 04:00:00	SPY	ETF	379.26	379.7	379.22	379.51	12385.0
2021-01-13 05:00:00	SPY	ETF	379.48	379.5	378.23	378.73	30450.0
2021-01-13 06:00:00	SPY	ETF	378.75	378.83	377.9	378.4	28746.0
2021-01-13 07:00:00	SPY	ETF	378.46	378.59	377.25	377.53	442810.0
2021-01-13 08:00:00	SPY	ETF	377.56	379.45	377.38	378.32	450671.0
2021-01-13 09:00:00	SPY	ETF	378.3	379.29	378.24	378.848	4293144.0
2021-01-13 10:00:00	SPY	ETF	378.8401	379.79	377.85	379.75	7365422.0
2021-01-13 11:00:00	SPY	ETF	379.745	379.94	379.22	379.59	3425339.0
2021-01-13 12:00:00	SPY	ETF	379.62	380.35	379.09	380.1102	4458354.0
2021-01-13 13:00:00	SPY	ETF	380.11	380.37	379.94	380.243	2483951.0
2021-01-13 14:00:00	SPY	ETF	380.24	380.86	379.87	380.385	5562350.0
2021-01-13 15:00:00	SPY	ETF	380.3844	380.53	379.61	379.76	10853006.0
2021-01-13 16:00:00	SPY	ETF	379.76	380.23	379.66	380.07	4587449.0
2021-01-13 17:00:00	SPY	ETF	380.15	380.7	380.05	380.54	310724.0
2021-01-13 18:00:00	SPY	ETF	380.53	380.65	380.19	380.19	239778.0
2021-01-13 19:00:00	SPY	ETF	380.18	380.82	380.09	380.7	64822.0
2021-01-13 04:00:00	QQQ	ETF	314.69	315.08	314.69	314.94	40817.0
2021-01-13 05:00:00	QQQ	ETF	314.93	315.11	313.77	314.2	34827.0
2021-01-13 06:00:00	QQQ	ETF	314.31	314.33	313.4	313.71	27306.0
2021-01-13 07:00:00	QQQ	ETF	313.86	314.18	312.83	313.07	169530.0
2021-01-13 08:00:00	QQQ	ETF	312.99	315.18	312.53	313.69	247461.0
2021-01-13 09:00:00	QQQ	ETF	313.73	315.49	313.54	314.705	2891851.0
2021-01-13 10:00:00	QQQ	ETF	314.7499	316.18	313.7099	316.16	3097414.0
2021-01-13 11:00:00	QQQ	ETF	316.1501	316.64	315.52	316.05	2169044.0
2021-01-13 12:00:00	QQQ	ETF	316.0674	316.25	315.32	316.15	1754449.0
2021-01-13 13:00:00	QQQ	ETF	316.13	316.495	315.94	316.25	1132235.0
2021-01-13 14:00:00	QQQ	ETF	316.25	316.86	315.94	316.54	1910244.0
2021-01-13 15:00:00	QQQ	ETF	316.56	316.67	315.76	316.0	2914357.0
2021-01-13 16:00:00	QQQ	ETF	315.97	316.28	315.9	316.16	1667611.0
2021-01-13 17:00:00	QQQ	ETF	316.1	316.2699	316.0	316.25	57631.0
2021-01-13 18:00:00	QQQ	ETF	316.25	316.39	316.03	316.05	86544.0
2021-01-13 19:00:00	QQQ	ETF	316.07	316.78	316.0	316.72	60919.0
2021-01-13 04:00:00	IWM	ETF	211.09	211.51	211.09	211.49	7685.0
2021-01-13 05:00:00	IWM	ETF	211.41	211.41	210.69	211.01	5697.0
2021-01-13 06:00:00	IWM	ETF	211.0	211.0	210.55	210.82	12248.0
2021-01-13 07:00:00	IWM	ETF	210.89	210.98	210.05	210.24	89233.0
2021-01-13 08:00:00	IWM	ETF	210.62	211.7	210.2	210.79	67078.0
2021-01-13 09:00:00	IWM	ETF	210.84	211.73	209.95	210.11	2440871.0
2021-01-13 10:00:00	IWM	ETF	210.105	210.98	209.26	210.9	2480992.0
2021-01-13 11:00:00	IWM	ETF	210.91	211.16	209.8	210.04	1909645.0
2021-01-13 12:00:00	IWM	ETF	210.05	211.36	209.835	211.13	2246954.0
2021-01-13 13:00:00	IWM	ETF	211.13	211.18	210.39	210.41	1613099.0
2021-01-13 14:00:00	IWM	ETF	210.425	210.81	210.01	210.0795	1959342.0
2021-01-13 15:00:00	IWM	ETF	210.08	210.12	209.19	209.72	3824682.0
2021-01-13 16:00:00	IWM	ETF	209.71	210.06	209.5	209.98	1899550.0
2021-01-13 17:00:00	IWM	ETF	209.96	210.33	209.55	210.15	19349.0
2021-01-13 18:00:00	IWM	ETF	210.15	210.43	209.95	210.17	63372.0
2021-01-13 19:00:00	IWM	ETF	210.03	210.54	210.0	210.49	19501.0
2021-01-13 04:00:00	DIA	ETF	311.3	311.35	311.27	311.29	4100.0
2021-01-13 05:00:00	DIA	ETF	311.1	311.1	310.44	310.46	1447.0

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

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