PREVIEW / etf_1hour / 2021-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-02.parquet
  size:    421 KB
  rows:    14,678

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-02 04:00:00	SPY	ETF	387.5	387.94	386.42	387.65	87707.0
2021-03-02 05:00:00	SPY	ETF	387.84	388.37	387.35	388.36	27609.0
2021-03-02 06:00:00	SPY	ETF	388.28	388.8	388.12	388.49	188457.0
2021-03-02 07:00:00	SPY	ETF	388.5	389.41	388.47	389.34	270246.0
2021-03-02 08:00:00	SPY	ETF	389.34	389.43	387.5	389.14	388059.0
2021-03-02 09:00:00	SPY	ETF	389.2	390.07	388.2	389.3	9192277.0
2021-03-02 10:00:00	SPY	ETF	389.31	389.72	387.08	388.17	10135298.0
2021-03-02 11:00:00	SPY	ETF	388.13	388.39	386.0	387.52	9501369.0
2021-03-02 12:00:00	SPY	ETF	387.52	389.09	387.21	388.639	5252588.0
2021-03-02 13:00:00	SPY	ETF	388.6399	389.74	388.6399	389.23	4490837.0
2021-03-02 14:00:00	SPY	ETF	389.2281	389.54	388.15	389.05	5778614.0
2021-03-02 15:00:00	SPY	ETF	389.03	389.36	386.3	386.55	12708191.0
2021-03-02 16:00:00	SPY	ETF	386.56	387.2	386.35	386.4	4830488.0
2021-03-02 17:00:00	SPY	ETF	386.4	386.57	386.25	386.57	154653.0
2021-03-02 18:00:00	SPY	ETF	386.57	387.6	386.54	387.4	246746.0
2021-03-02 19:00:00	SPY	ETF	387.4	387.9	387.2	387.78	76632.0
2021-03-02 04:00:00	QQQ	ETF	321.21	322.2	320.91	321.76	96720.0
2021-03-02 05:00:00	QQQ	ETF	321.81	322.63	321.5	322.52	30708.0
2021-03-02 06:00:00	QQQ	ETF	322.43	322.92	322.33	322.55	36347.0
2021-03-02 07:00:00	QQQ	ETF	322.6	323.59	322.52	323.59	183714.0
2021-03-02 08:00:00	QQQ	ETF	322.7904	323.8	321.5	323.29	438771.0
2021-03-02 09:00:00	QQQ	ETF	323.33	324.33	321.31	322.31	5819642.0
2021-03-02 10:00:00	QQQ	ETF	322.31	322.99	320.21	321.27	6469958.0
2021-03-02 11:00:00	QQQ	ETF	321.24	321.84	319.38	320.355	5640629.0
2021-03-02 12:00:00	QQQ	ETF	320.37	321.705	319.95	321.05	3845905.0
2021-03-02 13:00:00	QQQ	ETF	321.055	322.1315	320.95	321.51	3196391.0
2021-03-02 14:00:00	QQQ	ETF	321.49	321.995	320.15	321.031	4540161.0
2021-03-02 15:00:00	QQQ	ETF	321.03	321.49	318.14	318.3727	7224566.0
2021-03-02 16:00:00	QQQ	ETF	318.35	318.98	318.16	318.26	874964.0
2021-03-02 17:00:00	QQQ	ETF	318.23	318.55	318.15	318.4	689325.0
2021-03-02 18:00:00	QQQ	ETF	318.4	319.49	318.4	319.24	112700.0
2021-03-02 19:00:00	QQQ	ETF	319.16	320.04	319.13	319.77	143731.0
2021-03-02 04:00:00	IWM	ETF	225.0	225.0	223.34	224.46	32980.0
2021-03-02 05:00:00	IWM	ETF	224.37	224.41	224.08	224.41	11400.0
2021-03-02 06:00:00	IWM	ETF	224.23	225.0	224.19	224.84	21500.0
2021-03-02 07:00:00	IWM	ETF	224.83	225.53	224.77	225.3	97534.0
2021-03-02 08:00:00	IWM	ETF	225.0101	225.45	224.04	224.88	206588.0
2021-03-02 09:00:00	IWM	ETF	224.8	226.0	223.61	224.58	2537267.0
2021-03-02 10:00:00	IWM	ETF	224.58	224.89	222.86	224.14	2887893.0
2021-03-02 11:00:00	IWM	ETF	224.11	224.35	221.96	222.81	2690723.0
2021-03-02 12:00:00	IWM	ETF	222.81	223.83	222.35	223.192	1789488.0
2021-03-02 13:00:00	IWM	ETF	223.195	223.96	223.13	223.69	1798172.0
2021-03-02 14:00:00	IWM	ETF	223.68	223.91	222.225	223.47	1958456.0
2021-03-02 15:00:00	IWM	ETF	223.47	223.83	221.55	221.67	3629776.0
2021-03-02 16:00:00	IWM	ETF	221.72	223.4955	221.42	221.77	1740485.0
2021-03-02 17:00:00	IWM	ETF	221.99	221.99	221.72	221.75	108380.0
2021-03-02 18:00:00	IWM	ETF	221.99	223.07	221.99	222.81	42431.0
2021-03-02 19:00:00	IWM	ETF	222.8	223.15	222.78	223.01	21679.0
2021-03-02 04:00:00	DIA	ETF	314.86	314.86	313.52	314.46	3800.0
2021-03-02 05:00:00	DIA	ETF	315.02	315.02	315.02	315.02	100.0

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

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