PREVIEW / etf_1hour / 2021-03-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	392.0	392.64	391.52	392.25	45895.0
2021-03-11 05:00:00	SPY	ETF	392.3	392.67	392.08	392.52	36548.0
2021-03-11 06:00:00	SPY	ETF	392.5	392.5	391.95	392.0	31457.0
2021-03-11 07:00:00	SPY	ETF	391.98	392.5	391.74	392.23	309124.0
2021-03-11 08:00:00	SPY	ETF	392.3804	392.46	391.58	391.86	249340.0
2021-03-11 09:00:00	SPY	ETF	391.83	392.985	391.73	392.949	8074052.0
2021-03-11 10:00:00	SPY	ETF	392.95	394.14	391.97	394.05	9271991.0
2021-03-11 11:00:00	SPY	ETF	394.05	395.25	394.05	394.82	8560365.0
2021-03-11 12:00:00	SPY	ETF	394.82	395.41	394.54	394.915	5325142.0
2021-03-11 13:00:00	SPY	ETF	394.9119	395.65	394.37	394.57	7274397.0
2021-03-11 14:00:00	SPY	ETF	394.56	395.135	394.06	394.07	5354250.0
2021-03-11 15:00:00	SPY	ETF	394.07	394.25	393.28	393.5	14827665.0
2021-03-11 16:00:00	SPY	ETF	393.48	393.6	393.15	393.37	3868153.0
2021-03-11 17:00:00	SPY	ETF	393.41	393.59	393.3	393.58	488199.0
2021-03-11 18:00:00	SPY	ETF	393.54	394.37	393.49	393.96	191224.0
2021-03-11 19:00:00	SPY	ETF	393.91	394.36	393.84	394.02	79158.0
2021-03-11 04:00:00	QQQ	ETF	315.94	316.9	315.94	316.53	112299.0
2021-03-11 05:00:00	QQQ	ETF	316.53	317.27	316.0	316.95	96749.0
2021-03-11 06:00:00	QQQ	ETF	316.89	317.04	316.12	316.3	116740.0
2021-03-11 07:00:00	QQQ	ETF	316.31	317.22	315.61	316.75	640671.0
2021-03-11 08:00:00	QQQ	ETF	316.8804	317.17	310.88	315.96	682694.0
2021-03-11 09:00:00	QQQ	ETF	315.94	317.13	315.3	316.13	7918479.0
2021-03-11 10:00:00	QQQ	ETF	316.125	317.64	314.85	317.55	7250779.0
2021-03-11 11:00:00	QQQ	ETF	317.55	319.07	317.55	318.64	5820140.0
2021-03-11 12:00:00	QQQ	ETF	318.6701	319.29	318.28	318.77	3277418.0
2021-03-11 13:00:00	QQQ	ETF	318.78	319.86	318.34	318.78	4593204.0
2021-03-11 14:00:00	QQQ	ETF	318.77	319.22	318.425	318.48	3065730.0
2021-03-11 15:00:00	QQQ	ETF	318.49	319.0999	317.96	318.13	7729419.0
2021-03-11 16:00:00	QQQ	ETF	318.13	318.64	317.93	318.04	1505808.0
2021-03-11 17:00:00	QQQ	ETF	318.07	318.2	317.93	318.18	41895.0
2021-03-11 18:00:00	QQQ	ETF	318.28	319.05	318.25	318.72	147595.0
2021-03-11 19:00:00	QQQ	ETF	318.68	319.3	318.65	319.08	135038.0
2021-03-11 04:00:00	IWM	ETF	228.54	229.08	228.54	229.01	26895.0
2021-03-11 05:00:00	IWM	ETF	228.79	228.93	228.74	228.82	18741.0
2021-03-11 06:00:00	IWM	ETF	228.77	228.77	228.27	228.43	68432.0
2021-03-11 07:00:00	IWM	ETF	228.43	229.07	228.3	228.91	151779.0
2021-03-11 08:00:00	IWM	ETF	228.47	229.27	228.45	229.16	114098.0
2021-03-11 09:00:00	IWM	ETF	229.24	230.54	228.79	230.51	3186000.0
2021-03-11 10:00:00	IWM	ETF	230.56	231.675	229.55	231.46	3111799.0
2021-03-11 11:00:00	IWM	ETF	231.49	231.92	231.14	231.14	2184290.0
2021-03-11 12:00:00	IWM	ETF	231.18	231.675	230.82	231.11	1540420.0
2021-03-11 13:00:00	IWM	ETF	231.12	231.42	230.46	230.6986	1772738.0
2021-03-11 14:00:00	IWM	ETF	230.74	231.89	230.73	231.25	1606200.0
2021-03-11 15:00:00	IWM	ETF	231.25	232.28	231.18	232.15	4455557.0
2021-03-11 16:00:00	IWM	ETF	232.22	232.4079	231.1196	232.1	1448239.0
2021-03-11 17:00:00	IWM	ETF	232.17	232.37	232.1	232.2	124865.0
2021-03-11 18:00:00	IWM	ETF	232.35	233.25	232.22	232.89	71390.0
2021-03-11 19:00:00	IWM	ETF	232.96	233.1	232.73	232.99	11813.0
2021-03-11 04:00:00	DIA	ETF	324.55	324.63	324.39	324.42	10612.0
2021-03-11 05:00:00	DIA	ETF	324.39	324.39	324.39	324.39	3622.0

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

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