PREVIEW / etf_1hour / 2021-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-09.parquet
  size:    428 KB
  rows:    14,968

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-03-09 04:00:00	SPY	ETF	385.17	386.0	385.0	385.65	88094.0
2021-03-09 05:00:00	SPY	ETF	385.65	385.95	385.15	385.49	64572.0
2021-03-09 06:00:00	SPY	ETF	385.4	386.31	385.4	386.05	147724.0
2021-03-09 07:00:00	SPY	ETF	386.0	386.01	384.85	385.03	287636.0
2021-03-09 08:00:00	SPY	ETF	385.02	386.0296	384.1	385.56	614188.0
2021-03-09 09:00:00	SPY	ETF	385.53	387.53	385.3	387.25	14164465.0
2021-03-09 10:00:00	SPY	ETF	387.2684	388.72	387.05	388.425	14223604.0
2021-03-09 11:00:00	SPY	ETF	388.415	389.0	388.095	388.919	6460630.0
2021-03-09 12:00:00	SPY	ETF	388.92	389.75	388.78	389.0481	5220695.0
2021-03-09 13:00:00	SPY	ETF	389.05	389.9	389.05	389.7605	5840448.0
2021-03-09 14:00:00	SPY	ETF	389.77	389.91	388.91	389.06	6868447.0
2021-03-09 15:00:00	SPY	ETF	389.06	389.65	386.85	387.11	23906402.0
2021-03-09 16:00:00	SPY	ETF	387.11	387.38	386.75	387.01	8535324.0
2021-03-09 17:00:00	SPY	ETF	387.02	387.47	386.9	387.4	230013.0
2021-03-09 18:00:00	SPY	ETF	387.48	387.73	387.17	387.52	118263.0
2021-03-09 19:00:00	SPY	ETF	387.37	387.4	386.74	387.01	103897.0
2021-03-09 04:00:00	QQQ	ETF	303.98	306.69	303.98	306.29	171601.0
2021-03-09 05:00:00	QQQ	ETF	306.22	306.5	305.55	306.25	403752.0
2021-03-09 06:00:00	QQQ	ETF	306.18	307.44	306.17	307.17	325200.0
2021-03-09 07:00:00	QQQ	ETF	307.1	307.1	305.72	305.78	546533.0
2021-03-09 08:00:00	QQQ	ETF	306.6604	307.4004	301.93	307.07	968701.0
2021-03-09 09:00:00	QQQ	ETF	307.07	310.03	306.7	309.77	11354951.0
2021-03-09 10:00:00	QQQ	ETF	309.7799	311.309	309.4	309.775	12097953.0
2021-03-09 11:00:00	QQQ	ETF	309.77	311.13	309.255	310.81	5835142.0
2021-03-09 12:00:00	QQQ	ETF	310.82	312.0	310.51	311.47	4581985.0
2021-03-09 13:00:00	QQQ	ETF	311.5	313.51	311.49	313.4	6504852.0
2021-03-09 14:00:00	QQQ	ETF	313.41	313.498	312.26	312.96	4810147.0
2021-03-09 15:00:00	QQQ	ETF	312.94	313.73	311.51	311.79	12153348.0
2021-03-09 16:00:00	QQQ	ETF	311.81	312.0	311.37	311.85	2605429.0
2021-03-09 17:00:00	QQQ	ETF	311.91	312.29	311.71	312.29	202065.0
2021-03-09 18:00:00	QQQ	ETF	312.3	312.77	311.97	312.38	117386.0
2021-03-09 19:00:00	QQQ	ETF	312.35	312.41	311.46	311.78	197778.0
2021-03-09 04:00:00	IWM	ETF	221.3	222.25	221.25	222.07	28467.0
2021-03-09 05:00:00	IWM	ETF	222.13	222.44	221.8	221.86	12620.0
2021-03-09 06:00:00	IWM	ETF	222.0	222.38	221.87	222.05	18002.0
2021-03-09 07:00:00	IWM	ETF	222.08	222.08	221.23	221.4	81708.0
2021-03-09 08:00:00	IWM	ETF	222.02	222.06	220.2	221.93	132545.0
2021-03-09 09:00:00	IWM	ETF	221.98	223.4	220.92	223.05	5808202.0
2021-03-09 10:00:00	IWM	ETF	223.08	223.95	222.45	223.86	4787694.0
2021-03-09 11:00:00	IWM	ETF	223.91	224.67	223.68	223.84	2842841.0
2021-03-09 12:00:00	IWM	ETF	223.85	224.99	223.69	224.01	2107930.0
2021-03-09 13:00:00	IWM	ETF	224.02	224.92	223.75	224.81	1979724.0
2021-03-09 14:00:00	IWM	ETF	224.81	224.93	223.55	224.28	1873609.0
2021-03-09 15:00:00	IWM	ETF	224.28	224.94	223.07	223.25	5305891.0
2021-03-09 16:00:00	IWM	ETF	223.23	223.7108	223.0	223.13	2320833.0
2021-03-09 17:00:00	IWM	ETF	222.92	223.28	222.92	223.23	503.0
2021-03-09 18:00:00	IWM	ETF	223.22	223.62	223.22	223.5	26136.0
2021-03-09 19:00:00	IWM	ETF	223.34	223.49	223.0	223.14	14296.0
2021-03-09 04:00:00	DIA	ETF	320.26	320.48	320.08	320.22	1612.0
2021-03-09 05:00:00	DIA	ETF	320.0	320.0	319.87	319.87	800.0

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

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