PREVIEW / etf_1hour / 2021-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-14.parquet
  size:    418 KB
  rows:    14,512

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-09-14 04:00:00	SPY	ETF	446.84	447.35	446.35	447.12	44619.0
2021-09-14 05:00:00	SPY	ETF	447.25	447.36	446.75	446.77	8276.0
2021-09-14 06:00:00	SPY	ETF	446.69	447.16	446.65	446.76	69257.0
2021-09-14 07:00:00	SPY	ETF	446.95	446.97	445.78	446.05	338363.0
2021-09-14 08:00:00	SPY	ETF	446.94	448.59	445.78	447.85	1239190.0
2021-09-14 09:00:00	SPY	ETF	447.89	448.34	446.01	446.0875	5796129.0
2021-09-14 10:00:00	SPY	ETF	446.08	446.13	444.6	444.97	10114853.0
2021-09-14 11:00:00	SPY	ETF	444.97	446.035	444.95	446.02	5525454.0
2021-09-14 12:00:00	SPY	ETF	446.01	446.29	444.7	444.8899	4296501.0
2021-09-14 13:00:00	SPY	ETF	444.86	445.22	444.07	445.025	4678624.0
2021-09-14 14:00:00	SPY	ETF	445.03	445.1199	443.22	444.105	8140395.0
2021-09-14 15:00:00	SPY	ETF	444.11	444.29	443.2522	444.18	17358130.0
2021-09-14 16:00:00	SPY	ETF	444.18	444.5	443.875	444.36	4064426.0
2021-09-14 17:00:00	SPY	ETF	444.37	444.43	444.17	444.24	184189.0
2021-09-14 18:00:00	SPY	ETF	444.28	444.58	444.17	444.48	280726.0
2021-09-14 19:00:00	SPY	ETF	444.48	444.73	444.38	444.72	62847.0
2021-09-14 04:00:00	QQQ	ETF	376.0	376.63	375.89	376.39	41205.0
2021-09-14 05:00:00	QQQ	ETF	376.47	376.59	376.17	376.17	15023.0
2021-09-14 06:00:00	QQQ	ETF	376.11	376.5	376.01	376.33	25402.0
2021-09-14 07:00:00	QQQ	ETF	376.32	376.4	375.48	375.66	152159.0
2021-09-14 08:00:00	QQQ	ETF	376.2299	377.95	375.49	377.57	819943.0
2021-09-14 09:00:00	QQQ	ETF	377.63	378.61	376.27	376.36	4904373.0
2021-09-14 10:00:00	QQQ	ETF	376.38	376.7599	375.265	375.8301	6093235.0
2021-09-14 11:00:00	QQQ	ETF	375.83	377.47	375.83	377.45	3720230.0
2021-09-14 12:00:00	QQQ	ETF	377.45	377.75	375.98	376.155	2791378.0
2021-09-14 13:00:00	QQQ	ETF	376.155	376.4	375.28	376.13	3256626.0
2021-09-14 14:00:00	QQQ	ETF	376.14	376.3	374.36	375.24	5049222.0
2021-09-14 15:00:00	QQQ	ETF	375.25	375.38	374.28	375.18	6773800.0
2021-09-14 16:00:00	QQQ	ETF	375.18	375.63	375.11	375.35	1202770.0
2021-09-14 17:00:00	QQQ	ETF	375.33	375.4	375.26	375.26	17503.0
2021-09-14 18:00:00	QQQ	ETF	375.36	375.54	375.19	375.52	94658.0
2021-09-14 19:00:00	QQQ	ETF	375.55	375.77	375.45	375.76	92659.0
2021-09-14 04:00:00	IWM	ETF	223.04	223.61	222.91	223.38	5495.0
2021-09-14 05:00:00	IWM	ETF	223.4	223.54	223.08	223.08	7828.0
2021-09-14 06:00:00	IWM	ETF	223.01	223.35	223.01	223.23	7048.0
2021-09-14 07:00:00	IWM	ETF	223.19	223.23	222.4	222.61	73130.0
2021-09-14 08:00:00	IWM	ETF	222.8	224.6	222.45	223.87	287093.0
2021-09-14 09:00:00	IWM	ETF	223.99	224.13	222.17	222.28	3392304.0
2021-09-14 10:00:00	IWM	ETF	222.29	222.32	220.52	220.85	5048209.0
2021-09-14 11:00:00	IWM	ETF	220.88	222.04	220.86	221.88	2798132.0
2021-09-14 12:00:00	IWM	ETF	221.86	222.195	221.14	221.15	1869992.0
2021-09-14 13:00:00	IWM	ETF	221.15	221.58	220.42	221.28	2193010.0
2021-09-14 14:00:00	IWM	ETF	221.27	221.315	219.52	219.99	2679515.0
2021-09-14 15:00:00	IWM	ETF	219.99	220.08	219.07	220.05	5363764.0
2021-09-14 16:00:00	IWM	ETF	220.05	220.13	219.7	220.0	621012.0
2021-09-14 17:00:00	IWM	ETF	219.98	220.12	219.85	220.04	25728.0
2021-09-14 18:00:00	IWM	ETF	219.94	220.25	219.94	220.12	45752.0
2021-09-14 19:00:00	IWM	ETF	220.06	220.17	219.91	220.14	7102.0
2021-09-14 04:00:00	DIA	ETF	349.46	349.86	349.15	349.85	1300.0
2021-09-14 05:00:00	DIA	ETF	349.38	349.38	349.38	349.38	100.0

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

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