PREVIEW / etf_1hour / 2021-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-25.parquet
  size:    427 KB
  rows:    14,831

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-01-25 04:00:00	SPY	ETF	384.16	384.5	383.85	383.93	47818.0
2021-01-25 05:00:00	SPY	ETF	383.94	384.28	383.79	384.28	18154.0
2021-01-25 06:00:00	SPY	ETF	384.3	384.43	383.45	383.89	157927.0
2021-01-25 07:00:00	SPY	ETF	383.91	384.14	382.74	383.04	224132.0
2021-01-25 08:00:00	SPY	ETF	383.05	384.3696	382.59	383.26	850801.0
2021-01-25 09:00:00	SPY	ETF	383.2398	384.36	383.2398	383.73	4527628.0
2021-01-25 10:00:00	SPY	ETF	383.73	384.77	381.11	381.24	7003321.0
2021-01-25 11:00:00	SPY	ETF	381.24	382.3775	378.46	382.34	14968320.0
2021-01-25 12:00:00	SPY	ETF	382.36	383.19	380.95	383.0281	5904218.0
2021-01-25 13:00:00	SPY	ETF	383.02	383.88	382.4822	383.46	4753277.0
2021-01-25 14:00:00	SPY	ETF	383.46	383.75	382.86	383.34	3758869.0
2021-01-25 15:00:00	SPY	ETF	383.33	384.49	382.43	384.4	9982882.0
2021-01-25 16:00:00	SPY	ETF	384.4	384.72	383.2022	384.25	4068830.0
2021-01-25 17:00:00	SPY	ETF	384.36	384.39	384.12	384.12	145383.0
2021-01-25 18:00:00	SPY	ETF	384.15	384.35	383.88	384.11	92106.0
2021-01-25 19:00:00	SPY	ETF	384.1	384.18	383.66	383.75	126999.0
2021-01-25 04:00:00	QQQ	ETF	328.36	328.92	328.36	328.58	105355.0
2021-01-25 05:00:00	QQQ	ETF	328.63	328.77	328.27	328.77	28035.0
2021-01-25 06:00:00	QQQ	ETF	328.73	328.8	328.39	328.5	94693.0
2021-01-25 07:00:00	QQQ	ETF	328.49	329.16	328.32	328.46	426292.0
2021-01-25 08:00:00	QQQ	ETF	328.4704	329.1304	325.42	328.65	534958.0
2021-01-25 09:00:00	QQQ	ETF	328.57	330.32	328.57	329.96	3060151.0
2021-01-25 10:00:00	QQQ	ETF	329.96	330.22	325.16	325.31	4853514.0
2021-01-25 11:00:00	QQQ	ETF	325.28	326.54	321.41	326.538	8734783.0
2021-01-25 12:00:00	QQQ	ETF	326.54	327.17	324.47	327.05	3507666.0
2021-01-25 13:00:00	QQQ	ETF	327.068	327.71	326.34	327.34	1951091.0
2021-01-25 14:00:00	QQQ	ETF	327.42	327.83	326.69	327.48	1708605.0
2021-01-25 15:00:00	QQQ	ETF	327.46	328.49	325.98	328.35	3899330.0
2021-01-25 16:00:00	QQQ	ETF	328.38	328.68	327.99	328.1	1173010.0
2021-01-25 17:00:00	QQQ	ETF	328.15	328.15	327.84	327.84	95486.0
2021-01-25 18:00:00	QQQ	ETF	327.97	328.33	327.8	328.1	73193.0
2021-01-25 19:00:00	QQQ	ETF	328.06	328.11	327.58	327.62	47910.0
2021-01-25 04:00:00	IWM	ETF	215.08	215.4	214.65	214.82	67364.0
2021-01-25 05:00:00	IWM	ETF	214.82	214.9	214.5	214.86	19566.0
2021-01-25 06:00:00	IWM	ETF	214.86	214.95	213.75	214.61	37545.0
2021-01-25 07:00:00	IWM	ETF	214.33	214.4	213.2	213.56	149574.0
2021-01-25 08:00:00	IWM	ETF	213.51	216.0	213.33	214.28	138290.0
2021-01-25 09:00:00	IWM	ETF	214.1	215.76	214.1	214.41	3443837.0
2021-01-25 10:00:00	IWM	ETF	214.41	217.91	214.25	214.43	5840867.0
2021-01-25 11:00:00	IWM	ETF	214.43	214.89	211.6	214.19	4846467.0
2021-01-25 12:00:00	IWM	ETF	214.19	214.59	212.15	213.68	2068535.0
2021-01-25 13:00:00	IWM	ETF	213.64	214.59	213.29	213.94	1877433.0
2021-01-25 14:00:00	IWM	ETF	213.95	214.16	213.25	213.5	2372704.0
2021-01-25 15:00:00	IWM	ETF	213.49	214.915	213.17	214.74	3769552.0
2021-01-25 16:00:00	IWM	ETF	214.76	215.13	214.65	214.73	2897824.0
2021-01-25 17:00:00	IWM	ETF	214.87	214.94	214.72	214.72	59423.0
2021-01-25 18:00:00	IWM	ETF	214.72	214.95	214.62	214.77	22529.0
2021-01-25 19:00:00	IWM	ETF	214.67	214.79	214.21	214.39	36854.0
2021-01-25 04:00:00	DIA	ETF	310.41	310.41	309.92	309.92	5100.0
2021-01-25 05:00:00	DIA	ETF	309.99	310.12	309.8	310.12	3383.0

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

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