PREVIEW / etf_1hour / 2020-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-18.parquet
  size:    402 KB
  rows:    13,584

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-18 04:00:00	SPY	ETF	371.2	371.52	370.68	370.76	27554.0
2020-12-18 05:00:00	SPY	ETF	370.78	370.96	370.51	370.9	31887.0
2020-12-18 06:00:00	SPY	ETF	370.85	371.02	370.74	370.9	26698.0
2020-12-18 07:00:00	SPY	ETF	370.95	371.23	370.78	370.79	135428.0
2020-12-18 08:00:00	SPY	ETF	370.79	371.2298	369.39	370.88	319334.0
2020-12-18 09:00:00	SPY	ETF	370.86	372.34	369.04	369.62	11264219.0
2020-12-18 10:00:00	SPY	ETF	369.64	371.0815	368.43	369.0498	24627300.0
2020-12-18 11:00:00	SPY	ETF	369.04	369.2	367.7	368.59	7643081.0
2020-12-18 12:00:00	SPY	ETF	368.581	369.59	368.48	368.93	5145799.0
2020-12-18 13:00:00	SPY	ETF	368.93	368.96	367.98	368.35	5234035.0
2020-12-18 14:00:00	SPY	ETF	368.35	368.36	367.3	367.59	9303335.0
2020-12-18 15:00:00	SPY	ETF	367.6	370.6892	367.02	369.13	25711539.0
2020-12-18 16:00:00	SPY	ETF	369.09	371.14	369.06	370.8	24731316.0
2020-12-18 17:00:00	SPY	ETF	370.83	371.27	369.18	370.4	11983052.0
2020-12-18 18:00:00	SPY	ETF	370.3	370.35	369.18	370.0	1633938.0
2020-12-18 19:00:00	SPY	ETF	370.1	370.39	370.05	370.28	45318.0
2020-12-18 04:00:00	QQQ	ETF	311.49	311.7	310.93	311.0	86443.0
2020-12-18 05:00:00	QQQ	ETF	311.12	311.15	310.72	310.93	27599.0
2020-12-18 06:00:00	QQQ	ETF	310.96	311.17	310.95	311.04	25983.0
2020-12-18 07:00:00	QQQ	ETF	311.04	311.46	311.01	311.09	99405.0
2020-12-18 08:00:00	QQQ	ETF	311.3098	311.77	310.15	311.69	141946.0
2020-12-18 09:00:00	QQQ	ETF	311.68	312.01	310.17	310.45	3572470.0
2020-12-18 10:00:00	QQQ	ETF	310.43	310.55	309.41	310.25	3456991.0
2020-12-18 11:00:00	QQQ	ETF	310.25	310.48	308.84	309.66	1824154.0
2020-12-18 12:00:00	QQQ	ETF	309.64	310.43	309.47	310.108	1290362.0
2020-12-18 13:00:00	QQQ	ETF	310.1	310.28	309.24	309.6301	1255844.0
2020-12-18 14:00:00	QQQ	ETF	309.6	309.67	308.64	308.91	1811343.0
2020-12-18 15:00:00	QQQ	ETF	308.91	310.35	307.61	309.85	9224239.0
2020-12-18 16:00:00	QQQ	ETF	309.87	311.3	309.368	311.04	1606504.0
2020-12-18 17:00:00	QQQ	ETF	311.0	311.14	310.06	310.8	941149.0
2020-12-18 18:00:00	QQQ	ETF	310.8	311.0	310.75	310.85	39286.0
2020-12-18 19:00:00	QQQ	ETF	310.86	311.25	310.86	311.03	31240.0
2020-12-18 04:00:00	IWM	ETF	196.27	197.15	196.27	196.7	16270.0
2020-12-18 05:00:00	IWM	ETF	196.82	196.83	196.57	196.82	22659.0
2020-12-18 06:00:00	IWM	ETF	196.89	196.95	196.6	196.91	25400.0
2020-12-18 07:00:00	IWM	ETF	196.91	196.96	196.68	196.71	54864.0
2020-12-18 08:00:00	IWM	ETF	196.76	196.87	195.93	196.5	124040.0
2020-12-18 09:00:00	IWM	ETF	196.48	197.259	196.37	196.95	3224583.0
2020-12-18 10:00:00	IWM	ETF	196.965	197.53	196.77	197.4	3123035.0
2020-12-18 11:00:00	IWM	ETF	197.39	197.47	196.76	197.03	2132849.0
2020-12-18 12:00:00	IWM	ETF	197.03	197.83	196.93	197.539	1632914.0
2020-12-18 13:00:00	IWM	ETF	197.54	197.785	197.3	197.42	1352559.0
2020-12-18 14:00:00	IWM	ETF	197.41	197.41	196.165	196.36	4001173.0
2020-12-18 15:00:00	IWM	ETF	196.35	196.4	194.8	195.35	9165390.0
2020-12-18 16:00:00	IWM	ETF	195.4	197.3	195.15	197.3	3125389.0
2020-12-18 17:00:00	IWM	ETF	197.2	197.39	195.34	196.91	540164.0
2020-12-18 18:00:00	IWM	ETF	196.8	196.92	196.61	196.64	12026.0
2020-12-18 19:00:00	IWM	ETF	196.69	196.8	196.61	196.62	6329.0
2020-12-18 04:00:00	DIA	ETF	302.75	303.46	302.75	302.78	10295.0
2020-12-18 05:00:00	DIA	ETF	302.92	302.92	302.73	302.73	1400.0

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

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