PREVIEW / etf_1hour / 2021-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-19.parquet
  size:    433 KB
  rows:    14,995

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-19 04:00:00	SPY	ETF	377.7	378.46	377.7	378.28	59185.0
2021-01-19 05:00:00	SPY	ETF	378.36	378.53	378.05	378.32	65103.0
2021-01-19 06:00:00	SPY	ETF	378.36	378.72	378.36	378.64	43568.0
2021-01-19 07:00:00	SPY	ETF	378.65	378.67	378.1	378.45	248485.0
2021-01-19 08:00:00	SPY	ETF	378.46	378.68	375.7	378.15	890157.0
2021-01-19 09:00:00	SPY	ETF	378.18	378.77	377.08	377.71	5520538.0
2021-01-19 10:00:00	SPY	ETF	377.7199	378.15	377.04	377.7	5235762.0
2021-01-19 11:00:00	SPY	ETF	377.7	377.99	376.75	377.6514	4701164.0
2021-01-19 12:00:00	SPY	ETF	377.6586	378.81	377.58	378.73	4771020.0
2021-01-19 13:00:00	SPY	ETF	378.72	379.23	378.64	379.1086	3497059.0
2021-01-19 14:00:00	SPY	ETF	379.11	379.16	378.53	378.84	6545807.0
2021-01-19 15:00:00	SPY	ETF	378.835	379.19	378.59	378.63	12167265.0
2021-01-19 16:00:00	SPY	ETF	378.63	378.9899	378.39	378.9	6143230.0
2021-01-19 17:00:00	SPY	ETF	378.9	379.05	378.72	379.05	68327.0
2021-01-19 18:00:00	SPY	ETF	379.1	379.85	379.02	379.84	125820.0
2021-01-19 19:00:00	SPY	ETF	379.81	379.81	379.28	379.31	158959.0
2021-01-19 04:00:00	QQQ	ETF	314.29	315.04	314.29	314.95	74494.0
2021-01-19 05:00:00	QQQ	ETF	315.08	315.15	314.88	315.01	21118.0
2021-01-19 06:00:00	QQQ	ETF	315.03	315.23	315.02	315.14	43740.0
2021-01-19 07:00:00	QQQ	ETF	315.14	315.14	314.2	314.46	213650.0
2021-01-19 08:00:00	QQQ	ETF	314.41	315.1296	314.14	314.23	527009.0
2021-01-19 09:00:00	QQQ	ETF	314.2	315.09	313.4	313.97	4074517.0
2021-01-19 10:00:00	QQQ	ETF	313.98	314.69	313.32	313.86	2798297.0
2021-01-19 11:00:00	QQQ	ETF	313.85	314.53	313.12	314.355	1964644.0
2021-01-19 12:00:00	QQQ	ETF	314.36	315.75	314.27	315.7	1703021.0
2021-01-19 13:00:00	QQQ	ETF	315.709	316.58	315.68	316.53	1593949.0
2021-01-19 14:00:00	QQQ	ETF	316.52	316.67	316.11	316.45	1953283.0
2021-01-19 15:00:00	QQQ	ETF	316.445	316.93	316.37	316.43	3279706.0
2021-01-19 16:00:00	QQQ	ETF	316.43	317.6	315.99	317.56	1070594.0
2021-01-19 17:00:00	QQQ	ETF	317.55	317.6	317.28	317.51	79071.0
2021-01-19 18:00:00	QQQ	ETF	317.55	318.05	317.51	317.94	101176.0
2021-01-19 19:00:00	QQQ	ETF	317.94	317.94	317.67	317.72	35658.0
2021-01-19 04:00:00	IWM	ETF	213.11	213.44	211.35	213.36	28714.0
2021-01-19 05:00:00	IWM	ETF	213.36	213.55	213.25	213.46	15465.0
2021-01-19 06:00:00	IWM	ETF	213.42	213.71	213.42	213.59	26975.0
2021-01-19 07:00:00	IWM	ETF	213.55	213.6	212.94	213.22	61190.0
2021-01-19 08:00:00	IWM	ETF	213.6796	213.6796	212.9899	213.0	41846.0
2021-01-19 09:00:00	IWM	ETF	213.1	213.5	212.3	212.3	2526793.0
2021-01-19 10:00:00	IWM	ETF	212.3	213.26	211.72	212.88	2285588.0
2021-01-19 11:00:00	IWM	ETF	212.86	213.29	212.04	212.35	1764884.0
2021-01-19 12:00:00	IWM	ETF	212.3499	213.27	212.25	213.26	990685.0
2021-01-19 13:00:00	IWM	ETF	213.26	213.56	213.04	213.285	1257404.0
2021-01-19 14:00:00	IWM	ETF	213.29	213.49	212.9	213.05	1275620.0
2021-01-19 15:00:00	IWM	ETF	213.06	213.61	212.9	213.43	2538694.0
2021-01-19 16:00:00	IWM	ETF	213.44	213.5	212.77	213.36	1669948.0
2021-01-19 17:00:00	IWM	ETF	212.9	213.07	212.9	213.0	1987.0
2021-01-19 18:00:00	IWM	ETF	213.09	213.76	213.09	213.68	71473.0
2021-01-19 19:00:00	IWM	ETF	213.5	213.5	213.12	213.26	49327.0
2021-01-19 04:00:00	DIA	ETF	309.7	309.88	309.33	309.88	8640.0
2021-01-19 05:00:00	DIA	ETF	309.87	309.95	309.74	309.77	2789.0

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

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