PREVIEW / etf_1hour / 2021-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-26.parquet
  size:    420 KB
  rows:    14,332

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-26 04:00:00	SPY	ETF	383.65	384.31	383.4	383.56	41445.0
2021-01-26 05:00:00	SPY	ETF	383.6	383.86	383.4	383.7	17418.0
2021-01-26 06:00:00	SPY	ETF	383.73	384.83	383.68	384.44	187775.0
2021-01-26 07:00:00	SPY	ETF	384.39	385.22	384.36	384.93	372848.0
2021-01-26 08:00:00	SPY	ETF	384.5501	385.1496	382.46	385.05	355014.0
2021-01-26 09:00:00	SPY	ETF	385.1	385.85	384.4	384.7316	4214269.0
2021-01-26 10:00:00	SPY	ETF	384.74	385.31	383.8	384.43	5753831.0
2021-01-26 11:00:00	SPY	ETF	384.44	384.95	383.56	383.6391	3635563.0
2021-01-26 12:00:00	SPY	ETF	383.635	384.29	383.6	384.01	2560787.0
2021-01-26 13:00:00	SPY	ETF	384.02	384.83	383.92	384.545	3402273.0
2021-01-26 14:00:00	SPY	ETF	384.5431	384.9	384.12	384.65	3329366.0
2021-01-26 15:00:00	SPY	ETF	384.6362	384.96	383.54	383.83	8951086.0
2021-01-26 16:00:00	SPY	ETF	383.82	384.94	383.69	384.25	3636484.0
2021-01-26 17:00:00	SPY	ETF	384.21	384.4	383.95	384.09	189656.0
2021-01-26 18:00:00	SPY	ETF	384.09	384.83	383.79	384.22	313538.0
2021-01-26 19:00:00	SPY	ETF	384.29	384.39	384.0	384.21	90908.0
2021-01-26 04:00:00	QQQ	ETF	327.59	327.92	327.16	327.16	39828.0
2021-01-26 05:00:00	QQQ	ETF	327.33	327.54	327.12	327.43	15291.0
2021-01-26 06:00:00	QQQ	ETF	327.4	328.43	327.4	328.11	80769.0
2021-01-26 07:00:00	QQQ	ETF	328.07	328.75	328.07	328.2	212185.0
2021-01-26 08:00:00	QQQ	ETF	328.19	328.66	326.5	328.44	137041.0
2021-01-26 09:00:00	QQQ	ETF	328.55	329.23	327.22	328.46	2809352.0
2021-01-26 10:00:00	QQQ	ETF	328.48	329.55	327.56	329.195	3572586.0
2021-01-26 11:00:00	QQQ	ETF	329.22	329.76	327.87	327.94	3032039.0
2021-01-26 12:00:00	QQQ	ETF	327.9461	328.857	327.93	328.47	1352789.0
2021-01-26 13:00:00	QQQ	ETF	328.499	329.2995	328.23	328.982	981854.0
2021-01-26 14:00:00	QQQ	ETF	328.985	329.26	328.52	328.9	1867830.0
2021-01-26 15:00:00	QQQ	ETF	328.89	329.17	328.26	328.6	3722100.0
2021-01-26 16:00:00	QQQ	ETF	328.59	331.38	328.52	330.29	1771383.0
2021-01-26 17:00:00	QQQ	ETF	330.18	330.42	328.63	330.29	392293.0
2021-01-26 18:00:00	QQQ	ETF	330.29	331.06	330.27	330.55	156702.0
2021-01-26 19:00:00	QQQ	ETF	330.46	330.55	330.11	330.36	123934.0
2021-01-26 04:00:00	IWM	ETF	214.13	214.79	214.13	214.22	4062.0
2021-01-26 05:00:00	IWM	ETF	214.19	214.57	214.19	214.57	3300.0
2021-01-26 06:00:00	IWM	ETF	214.48	215.86	214.48	215.42	31491.0
2021-01-26 07:00:00	IWM	ETF	215.46	216.11	215.18	216.08	47722.0
2021-01-26 08:00:00	IWM	ETF	215.41	216.14	212.9	215.81	38243.0
2021-01-26 09:00:00	IWM	ETF	215.96	216.69	215.02	215.2373	2041524.0
2021-01-26 10:00:00	IWM	ETF	215.24	215.9	213.81	214.05	2473499.0
2021-01-26 11:00:00	IWM	ETF	214.05	214.36	212.77	212.8	2922539.0
2021-01-26 12:00:00	IWM	ETF	212.82	214.22	212.82	213.84	1783129.0
2021-01-26 13:00:00	IWM	ETF	213.85	214.46	213.705	213.96	1301935.0
2021-01-26 14:00:00	IWM	ETF	213.94	214.53	213.88	214.36	1826070.0
2021-01-26 15:00:00	IWM	ETF	214.37	214.74	213.04	213.27	3603500.0
2021-01-26 16:00:00	IWM	ETF	213.3	213.4194	212.0	212.23	1134727.0
2021-01-26 17:00:00	IWM	ETF	212.15	213.35	211.93	212.29	421975.0
2021-01-26 18:00:00	IWM	ETF	212.26	213.11	212.26	212.61	152554.0
2021-01-26 19:00:00	IWM	ETF	212.6	213.65	212.54	213.28	148545.0
2021-01-26 04:00:00	DIA	ETF	309.3	309.63	309.3	309.3	1200.0
2021-01-26 06:00:00	DIA	ETF	309.67	310.4	309.67	310.16	6000.0

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

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