PREVIEW / etf_1hour / 2021-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-19.parquet
  size:    424 KB
  rows:    14,688

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-04-19 04:00:00	SPY	ETF	416.87	417.06	416.71	416.77	22851.0
2021-04-19 05:00:00	SPY	ETF	416.77	416.77	416.28	416.5	16729.0
2021-04-19 06:00:00	SPY	ETF	416.48	416.65	415.95	416.29	176295.0
2021-04-19 07:00:00	SPY	ETF	416.32	416.46	416.08	416.18	207065.0
2021-04-19 08:00:00	SPY	ETF	416.2201	416.48	416.01	416.39	249825.0
2021-04-19 09:00:00	SPY	ETF	416.43	416.74	415.99	416.62	4377237.0
2021-04-19 10:00:00	SPY	ETF	416.62	416.67	414.38	415.3518	11541315.0
2021-04-19 11:00:00	SPY	ETF	415.345	415.71	414.24	414.84	6783936.0
2021-04-19 12:00:00	SPY	ETF	414.82	415.26	413.79	414.205	7904558.0
2021-04-19 13:00:00	SPY	ETF	414.205	415.09	414.04	414.67	4827348.0
2021-04-19 14:00:00	SPY	ETF	414.67	415.12	414.37	415.077	4796263.0
2021-04-19 15:00:00	SPY	ETF	415.075	415.34	414.14	415.26	13760798.0
2021-04-19 16:00:00	SPY	ETF	415.26	415.42	415.074	415.21	3375199.0
2021-04-19 17:00:00	SPY	ETF	415.21	415.26	415.16	415.16	59007.0
2021-04-19 18:00:00	SPY	ETF	415.16	415.55	415.16	415.49	84114.0
2021-04-19 19:00:00	SPY	ETF	415.5	415.78	415.27	415.72	152653.0
2021-04-19 04:00:00	QQQ	ETF	342.31	342.34	341.79	342.03	48352.0
2021-04-19 05:00:00	QQQ	ETF	342.03	342.08	341.66	341.75	10786.0
2021-04-19 06:00:00	QQQ	ETF	341.77	341.8	340.71	340.96	55422.0
2021-04-19 07:00:00	QQQ	ETF	341.0	341.21	340.8	340.84	112163.0
2021-04-19 08:00:00	QQQ	ETF	340.7904	342.38	340.18	340.44	200163.0
2021-04-19 09:00:00	QQQ	ETF	340.43	341.58	339.96	341.12	3306250.0
2021-04-19 10:00:00	QQQ	ETF	341.12	341.41	337.87	339.43	7266639.0
2021-04-19 11:00:00	QQQ	ETF	339.41	339.985	337.725	338.32	4528712.0
2021-04-19 12:00:00	QQQ	ETF	338.29	338.7772	336.9016	337.58	4118880.0
2021-04-19 13:00:00	QQQ	ETF	337.57	338.79	337.39	338.2328	2148777.0
2021-04-19 14:00:00	QQQ	ETF	338.21	338.705	337.73	338.465	2400230.0
2021-04-19 15:00:00	QQQ	ETF	338.4673	338.93	337.6277	338.87	4243938.0
2021-04-19 16:00:00	QQQ	ETF	338.9	339.2	338.51	338.55	621125.0
2021-04-19 17:00:00	QQQ	ETF	338.63	338.88	338.63	338.88	108585.0
2021-04-19 18:00:00	QQQ	ETF	338.81	339.08	338.75	339.0	33806.0
2021-04-19 19:00:00	QQQ	ETF	339.02	339.31	338.78	339.21	52637.0
2021-04-19 04:00:00	IWM	ETF	223.69	223.94	223.6	223.6	9807.0
2021-04-19 05:00:00	IWM	ETF	223.61	223.61	223.04	223.39	24388.0
2021-04-19 06:00:00	IWM	ETF	223.35	223.47	222.62	222.89	37204.0
2021-04-19 07:00:00	IWM	ETF	222.88	223.27	222.72	222.82	70319.0
2021-04-19 08:00:00	IWM	ETF	222.78	223.83	222.61	223.59	181161.0
2021-04-19 09:00:00	IWM	ETF	223.6	224.25	222.67	222.9	2715949.0
2021-04-19 10:00:00	IWM	ETF	222.88	222.95	219.94	220.45	4765039.0
2021-04-19 11:00:00	IWM	ETF	220.47	221.35	220.01	220.76	3026455.0
2021-04-19 12:00:00	IWM	ETF	220.76	221.4	220.17	220.64	1877117.0
2021-04-19 13:00:00	IWM	ETF	220.64	221.32	220.53	221.17	1415521.0
2021-04-19 14:00:00	IWM	ETF	221.18	221.64	220.825	221.48	1446127.0
2021-04-19 15:00:00	IWM	ETF	221.48	221.81	220.83	221.75	2986194.0
2021-04-19 16:00:00	IWM	ETF	221.73	221.87	221.44	221.61	851092.0
2021-04-19 17:00:00	IWM	ETF	221.35	221.73	221.35	221.72	499471.0
2021-04-19 18:00:00	IWM	ETF	221.6	221.79	221.57	221.73	38766.0
2021-04-19 19:00:00	IWM	ETF	221.7	221.75	221.5	221.72	35980.0
2021-04-19 04:00:00	DIA	ETF	341.27	341.27	341.27	341.27	100.0
2021-04-19 05:00:00	DIA	ETF	341.23	341.23	341.01	341.01	700.0

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

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