PREVIEW / etf_1hour / 2021-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-08.parquet
  size:    428 KB
  rows:    15,222

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-07-08 04:00:00	SPY	ETF	431.09	433.02	429.75	430.4	130702.0
2021-07-08 05:00:00	SPY	ETF	430.41	430.51	429.13	429.51	222924.0
2021-07-08 06:00:00	SPY	ETF	429.29	429.29	427.6	428.97	571157.0
2021-07-08 07:00:00	SPY	ETF	428.97	429.25	428.15	428.31	892647.0
2021-07-08 08:00:00	SPY	ETF	428.31	433.69	427.49	428.58	1237360.0
2021-07-08 09:00:00	SPY	ETF	428.65	429.595	427.61	429.45	12603904.0
2021-07-08 10:00:00	SPY	ETF	429.45	429.46	427.52	428.14	13915432.0
2021-07-08 11:00:00	SPY	ETF	428.15	431.1	427.98	430.93	8975398.0
2021-07-08 12:00:00	SPY	ETF	430.91	431.73	430.645	431.55	5606110.0
2021-07-08 13:00:00	SPY	ETF	431.55	431.64	430.86	430.98	5186728.0
2021-07-08 14:00:00	SPY	ETF	430.99	431.04	429.83	430.27	6451480.0
2021-07-08 15:00:00	SPY	ETF	430.26	430.98	429.145	430.95	18897841.0
2021-07-08 16:00:00	SPY	ETF	430.94	434.4301	430.2	430.54	4258459.0
2021-07-08 17:00:00	SPY	ETF	430.38	430.57	430.38	430.56	40586.0
2021-07-08 18:00:00	SPY	ETF	430.52	430.68	430.2399	430.3	70868.0
2021-07-08 19:00:00	SPY	ETF	430.3	430.68	430.23	430.26	42958.0
2021-07-08 04:00:00	QQQ	ETF	360.5	360.5	356.89	357.23	152006.0
2021-07-08 05:00:00	QQQ	ETF	357.23	357.32	356.2	356.42	319606.0
2021-07-08 06:00:00	QQQ	ETF	356.32	356.73	355.21	356.72	440969.0
2021-07-08 07:00:00	QQQ	ETF	356.73	356.86	355.49	355.59	535694.0
2021-07-08 08:00:00	QQQ	ETF	356.0304	360.0	354.57	355.798	823282.0
2021-07-08 09:00:00	QQQ	ETF	355.83	356.88	354.42	356.78	9367988.0
2021-07-08 10:00:00	QQQ	ETF	356.77	357.24	355.32	355.36	7057283.0
2021-07-08 11:00:00	QQQ	ETF	355.41	357.97	355.04	357.81	4749349.0
2021-07-08 12:00:00	QQQ	ETF	357.81	358.87	357.38	358.54	3055480.0
2021-07-08 13:00:00	QQQ	ETF	358.535	359.65	358.2914	359.15	3310469.0
2021-07-08 14:00:00	QQQ	ETF	359.16	359.241	357.97	358.54	3746961.0
2021-07-08 15:00:00	QQQ	ETF	358.53	358.86	357.3	358.86	6435494.0
2021-07-08 16:00:00	QQQ	ETF	358.85	358.9	355.4888	358.71	2573103.0
2021-07-08 17:00:00	QQQ	ETF	358.77	358.8	358.61	358.7	51963.0
2021-07-08 18:00:00	QQQ	ETF	358.61	358.67	358.17	358.26	80640.0
2021-07-08 19:00:00	QQQ	ETF	358.25	358.47	358.03	358.04	83095.0
2021-07-08 04:00:00	IWM	ETF	220.8	221.02	220.0	220.7	35438.0
2021-07-08 05:00:00	IWM	ETF	220.3	220.86	220.0	220.32	23700.0
2021-07-08 06:00:00	IWM	ETF	220.0	220.18	219.33	220.05	56177.0
2021-07-08 07:00:00	IWM	ETF	220.17	220.29	219.43	219.72	146629.0
2021-07-08 08:00:00	IWM	ETF	220.05	223.35	218.83	219.01	375796.0
2021-07-08 09:00:00	IWM	ETF	219.06	219.86	217.85	219.615	5285619.0
2021-07-08 10:00:00	IWM	ETF	219.63	221.2	218.18	220.39	6198782.0
2021-07-08 11:00:00	IWM	ETF	220.39	223.15	220.33	223.12	5619028.0
2021-07-08 12:00:00	IWM	ETF	223.12	224.075	222.66	223.21	4699229.0
2021-07-08 13:00:00	IWM	ETF	223.21	223.29	222.015	222.2399	2923427.0
2021-07-08 14:00:00	IWM	ETF	222.24	222.37	220.81	221.29	3361678.0
2021-07-08 15:00:00	IWM	ETF	221.28	221.91	220.645	221.8	4677002.0
2021-07-08 16:00:00	IWM	ETF	221.7	221.81	221.0	221.43	2014874.0
2021-07-08 17:00:00	IWM	ETF	221.19	221.7	221.19	221.44	27092.0
2021-07-08 18:00:00	IWM	ETF	221.44	221.72	221.41	221.45	38074.0
2021-07-08 19:00:00	IWM	ETF	221.51	221.8	221.51	221.67	59151.0
2021-07-08 04:00:00	DIA	ETF	344.0	344.0	342.84	343.42	5371.0
2021-07-08 05:00:00	DIA	ETF	343.3	343.3	342.49	343.17	1200.0

> showing 50 of 15,222 rows — these rows as CSV

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