PREVIEW / etf_1hour / 2021-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-12.parquet
  size:    424 KB
  rows:    14,663

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-12 04:00:00	SPY	ETF	394.5	394.5	390.92	391.25	41298.0
2021-03-12 05:00:00	SPY	ETF	391.23	391.7	390.88	391.36	61472.0
2021-03-12 06:00:00	SPY	ETF	391.3	391.72	390.99	391.3	46077.0
2021-03-12 07:00:00	SPY	ETF	391.35	392.6	391.29	392.54	281202.0
2021-03-12 08:00:00	SPY	ETF	392.54	394.05	391.2296	391.99	359101.0
2021-03-12 09:00:00	SPY	ETF	391.92	392.91	391.28	392.86	8938216.0
2021-03-12 10:00:00	SPY	ETF	392.85	393.0901	391.28	391.87	9618279.0
2021-03-12 11:00:00	SPY	ETF	391.84	392.72	391.2	392.445	4909078.0
2021-03-12 12:00:00	SPY	ETF	392.45	393.27	392.07	392.55	3704410.0
2021-03-12 13:00:00	SPY	ETF	392.54	393.18	392.2599	392.7499	2952885.0
2021-03-12 14:00:00	SPY	ETF	392.75	393.5001	392.63	393.371	4361655.0
2021-03-12 15:00:00	SPY	ETF	393.39	394.21	392.81	394.09	8773982.0
2021-03-12 16:00:00	SPY	ETF	394.09	394.54	393.93	394.08	5106577.0
2021-03-12 17:00:00	SPY	ETF	394.04	394.18	393.68	394.05	64633.0
2021-03-12 18:00:00	SPY	ETF	394.06	394.19	393.96	394.14	10692.0
2021-03-12 19:00:00	SPY	ETF	394.18	394.18	393.99	394.05	25113.0
2021-03-12 04:00:00	QQQ	ETF	315.9	316.04	312.32	312.51	161579.0
2021-03-12 05:00:00	QQQ	ETF	312.51	313.27	311.86	312.89	150625.0
2021-03-12 06:00:00	QQQ	ETF	312.86	313.45	312.42	312.74	116656.0
2021-03-12 07:00:00	QQQ	ETF	312.86	314.53	312.86	314.4	712292.0
2021-03-12 08:00:00	QQQ	ETF	314.4	318.51	312.6696	313.25	1101711.0
2021-03-12 09:00:00	QQQ	ETF	313.26	314.46	312.09	314.34	7748828.0
2021-03-12 10:00:00	QQQ	ETF	314.32	314.71	311.44	311.99	10085540.0
2021-03-12 11:00:00	QQQ	ETF	311.97	314.05	311.391	313.6	5940482.0
2021-03-12 12:00:00	QQQ	ETF	313.6218	315.21	313.2	313.93	5116247.0
2021-03-12 13:00:00	QQQ	ETF	313.94	314.79	313.47	314.15	3206860.0
2021-03-12 14:00:00	QQQ	ETF	314.18	315.14	313.84	314.8	3567174.0
2021-03-12 15:00:00	QQQ	ETF	314.8	315.6199	314.04	315.48	6750515.0
2021-03-12 16:00:00	QQQ	ETF	315.46	315.75	315.31	315.46	2107009.0
2021-03-12 17:00:00	QQQ	ETF	315.36	315.7	315.34	315.52	92165.0
2021-03-12 18:00:00	QQQ	ETF	315.5	315.7	315.46	315.61	14553.0
2021-03-12 19:00:00	QQQ	ETF	315.61	315.7499	315.58	315.7499	18716.0
2021-03-12 04:00:00	IWM	ETF	232.0	232.0	231.44	231.65	26793.0
2021-03-12 05:00:00	IWM	ETF	231.61	232.0	231.46	231.83	8227.0
2021-03-12 06:00:00	IWM	ETF	231.7	232.35	231.5	232.09	5885.0
2021-03-12 07:00:00	IWM	ETF	232.15	232.5	231.8	232.5	197048.0
2021-03-12 08:00:00	IWM	ETF	232.21	232.98	231.7901	232.06	196257.0
2021-03-12 09:00:00	IWM	ETF	231.97	232.96	231.52	232.69	3270012.0
2021-03-12 10:00:00	IWM	ETF	232.68	233.15	231.37	232.32	3064130.0
2021-03-12 11:00:00	IWM	ETF	232.31	233.56	231.98	232.56	2189071.0
2021-03-12 12:00:00	IWM	ETF	232.56	233.125	232.18	232.61	1787141.0
2021-03-12 13:00:00	IWM	ETF	232.63	233.14	232.25	232.33	1000377.0
2021-03-12 14:00:00	IWM	ETF	232.34	233.25	232.184	233.17	1446778.0
2021-03-12 15:00:00	IWM	ETF	233.18	234.15	232.94	233.78	3965812.0
2021-03-12 16:00:00	IWM	ETF	233.59	234.21	233.59	234.0	1698077.0
2021-03-12 17:00:00	IWM	ETF	233.87	234.3	233.82	234.15	110638.0
2021-03-12 18:00:00	IWM	ETF	234.15	234.33	234.11	234.33	6496.0
2021-03-12 19:00:00	IWM	ETF	234.17	234.49	234.02	234.15	4841.0
2021-03-12 04:00:00	DIA	ETF	324.65	325.09	324.47	325.09	5350.0
2021-03-12 05:00:00	DIA	ETF	325.21	325.36	325.01	325.17	7691.0

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

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