PREVIEW / etf_1hour / 2021-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-04.parquet
  size:    423 KB
  rows:    14,455

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-02-04 04:00:00	SPY	ETF	382.7	382.75	382.35	382.35	146116.0
2021-02-04 05:00:00	SPY	ETF	382.33	382.67	382.31	382.62	12480.0
2021-02-04 06:00:00	SPY	ETF	382.63	382.78	381.83	381.88	85927.0
2021-02-04 07:00:00	SPY	ETF	381.88	382.77	381.88	382.77	252918.0
2021-02-04 08:00:00	SPY	ETF	382.15	383.12	381.4	382.92	288576.0
2021-02-04 09:00:00	SPY	ETF	382.89	383.92	382.7	383.9011	4434697.0
2021-02-04 10:00:00	SPY	ETF	383.9	384.43	383.55	384.275	6225322.0
2021-02-04 11:00:00	SPY	ETF	384.27	384.78	384.18	384.5819	2804649.0
2021-02-04 12:00:00	SPY	ETF	384.58	385.01	384.57	384.75	2246151.0
2021-02-04 13:00:00	SPY	ETF	384.76	385.35	384.71	385.19	2179346.0
2021-02-04 14:00:00	SPY	ETF	385.2	385.46	385.07	385.335	3674202.0
2021-02-04 15:00:00	SPY	ETF	385.325	386.24	384.97	386.17	8394727.0
2021-02-04 16:00:00	SPY	ETF	386.16	386.58	386.0	386.31	3988153.0
2021-02-04 17:00:00	SPY	ETF	386.3	386.43	386.0	386.09	216944.0
2021-02-04 18:00:00	SPY	ETF	386.1	386.34	385.91	386.27	146437.0
2021-02-04 19:00:00	SPY	ETF	386.21	386.36	385.8	385.97	73073.0
2021-02-04 04:00:00	QQQ	ETF	327.72	327.77	327.5	327.6	52699.0
2021-02-04 05:00:00	QQQ	ETF	327.57	327.92	327.46	327.8	16917.0
2021-02-04 06:00:00	QQQ	ETF	327.74	327.86	327.12	327.23	101369.0
2021-02-04 07:00:00	QQQ	ETF	327.38	327.93	327.35	327.83	166930.0
2021-02-04 08:00:00	QQQ	ETF	327.4899	328.17	325.89	327.89	190694.0
2021-02-04 09:00:00	QQQ	ETF	327.89	328.605	326.98	327.53	3575496.0
2021-02-04 10:00:00	QQQ	ETF	327.53	327.94	326.46	327.49	4008657.0
2021-02-04 11:00:00	QQQ	ETF	327.49	328.205	327.2	328.02	1807065.0
2021-02-04 12:00:00	QQQ	ETF	328.04	328.71	328.02	328.59	1450938.0
2021-02-04 13:00:00	QQQ	ETF	328.58	329.18	328.49	328.96	1413284.0
2021-02-04 14:00:00	QQQ	ETF	328.97	329.34	328.79	329.23	1318862.0
2021-02-04 15:00:00	QQQ	ETF	329.23	330.33	329.09	330.3	3111779.0
2021-02-04 16:00:00	QQQ	ETF	330.28	330.69	330.0	330.6	1027484.0
2021-02-04 17:00:00	QQQ	ETF	330.61	330.67	330.4	330.47	52310.0
2021-02-04 18:00:00	QQQ	ETF	330.6	330.6	330.1	330.38	84976.0
2021-02-04 19:00:00	QQQ	ETF	330.35	330.35	329.93	330.1	47261.0
2021-02-04 04:00:00	IWM	ETF	214.35	214.42	214.02	214.05	11475.0
2021-02-04 05:00:00	IWM	ETF	214.0	214.35	213.94	214.16	9986.0
2021-02-04 06:00:00	IWM	ETF	214.16	214.28	213.56	213.65	50130.0
2021-02-04 07:00:00	IWM	ETF	213.6	214.43	213.6	214.39	104247.0
2021-02-04 08:00:00	IWM	ETF	214.0608	214.87	214.0608	214.83	128375.0
2021-02-04 09:00:00	IWM	ETF	214.87	216.48	214.87	216.47	1931559.0
2021-02-04 10:00:00	IWM	ETF	216.47	217.82	216.16	217.478	3054503.0
2021-02-04 11:00:00	IWM	ETF	217.48	218.49	217.48	218.41	2753163.0
2021-02-04 12:00:00	IWM	ETF	218.39	218.76	217.99	218.03	2647240.0
2021-02-04 13:00:00	IWM	ETF	218.025	218.65	217.88	218.61	2367687.0
2021-02-04 14:00:00	IWM	ETF	218.59	218.83	218.43	218.53	1480996.0
2021-02-04 15:00:00	IWM	ETF	218.53	218.775	218.15	218.65	3274031.0
2021-02-04 16:00:00	IWM	ETF	218.62	219.29	218.59	219.24	1840969.0
2021-02-04 17:00:00	IWM	ETF	219.1	219.3	218.5	218.86	187937.0
2021-02-04 18:00:00	IWM	ETF	218.86	219.14	218.72	218.81	77944.0
2021-02-04 19:00:00	IWM	ETF	218.89	219.0	218.64	218.75	18985.0
2021-02-04 04:00:00	DIA	ETF	307.53	307.53	307.43	307.43	1150.0
2021-02-04 06:00:00	DIA	ETF	307.36	307.36	307.15	307.15	1200.0

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

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