PREVIEW / etf_1hour / 2022-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-17.parquet
  size:    444 KB
  rows:    15,821

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
2022-02-17 04:00:00	SPY	ETF	445.69	445.69	443.55	444.05	43199.0
2022-02-17 05:00:00	SPY	ETF	443.96	444.79	443.84	444.5	9713.0
2022-02-17 06:00:00	SPY	ETF	444.46	444.54	444.0	444.47	68083.0
2022-02-17 07:00:00	SPY	ETF	444.44	445.67	444.43	445.47	366124.0
2022-02-17 08:00:00	SPY	ETF	445.0	446.03	442.8	442.98	1054907.0
2022-02-17 09:00:00	SPY	ETF	442.92	444.51	440.54	440.7899	9880057.0
2022-02-17 10:00:00	SPY	ETF	440.77	441.6697	439.8	440.92	10857961.0
2022-02-17 11:00:00	SPY	ETF	440.9	442.12	440.63	441.2	6656808.0
2022-02-17 12:00:00	SPY	ETF	441.21	441.85	440.72	441.15	4605586.0
2022-02-17 13:00:00	SPY	ETF	441.14	441.27	439.97	440.33	4793231.0
2022-02-17 14:00:00	SPY	ETF	440.32	440.32	438.295	438.38	7202155.0
2022-02-17 15:00:00	SPY	ETF	438.36	438.69	436.42	437.11	26816217.0
2022-02-17 16:00:00	SPY	ETF	437.11	437.58	436.37	437.12	5660612.0
2022-02-17 17:00:00	SPY	ETF	437.28	437.28	436.92	437.08	112914.0
2022-02-17 18:00:00	SPY	ETF	437.08	437.67	436.52	437.44	151269.0
2022-02-17 19:00:00	SPY	ETF	437.44	437.79	436.09	437.18	120050.0
2022-02-17 04:00:00	QQQ	ETF	352.0	354.21	350.0	353.65	381140.0
2022-02-17 05:00:00	QQQ	ETF	353.54	354.11	353.54	353.94	20140.0
2022-02-17 06:00:00	QQQ	ETF	353.8	354.0	353.28	353.93	56746.0
2022-02-17 07:00:00	QQQ	ETF	353.82	354.93	353.78	354.78	122662.0
2022-02-17 08:00:00	QQQ	ETF	354.3101	355.3	352.31	352.57	955244.0
2022-02-17 09:00:00	QQQ	ETF	352.56	353.65	350.54	351.2563	7364789.0
2022-02-17 10:00:00	QQQ	ETF	351.23	351.9	349.26	350.24	7351097.0
2022-02-17 11:00:00	QQQ	ETF	350.22	351.388	349.93	350.18	5257781.0
2022-02-17 12:00:00	QQQ	ETF	350.1894	350.405	349.07	349.92	3238857.0
2022-02-17 13:00:00	QQQ	ETF	349.92	350.0	348.4	348.83	3293602.0
2022-02-17 14:00:00	QQQ	ETF	348.82	348.82	347.16	347.22	4531898.0
2022-02-17 15:00:00	QQQ	ETF	347.2	347.39	345.02	345.45	13440457.0
2022-02-17 16:00:00	QQQ	ETF	345.48	345.67	344.68	345.21	2451743.0
2022-02-17 17:00:00	QQQ	ETF	345.21	345.29	345.0	345.2	83871.0
2022-02-17 18:00:00	QQQ	ETF	345.16	345.88	344.77	345.73	209232.0
2022-02-17 19:00:00	QQQ	ETF	345.62	345.88	344.59	345.27	248475.0
2022-02-17 04:00:00	IWM	ETF	204.92	205.14	204.51	204.7	17929.0
2022-02-17 05:00:00	IWM	ETF	204.75	205.19	204.62	205.07	12062.0
2022-02-17 06:00:00	IWM	ETF	204.91	205.15	204.75	205.12	18887.0
2022-02-17 07:00:00	IWM	ETF	205.05	205.82	205.05	205.74	212399.0
2022-02-17 08:00:00	IWM	ETF	205.1096	206.14	204.29	204.5	296353.0
2022-02-17 09:00:00	IWM	ETF	204.48	205.5	203.07	203.24	4470494.0
2022-02-17 10:00:00	IWM	ETF	203.25	203.7	202.17	202.94	4369871.0
2022-02-17 11:00:00	IWM	ETF	202.93	203.57	202.68	203.12	1523783.0
2022-02-17 12:00:00	IWM	ETF	203.13	203.62	202.99	203.38	934780.0
2022-02-17 13:00:00	IWM	ETF	203.4	203.44	202.45	202.73	1205440.0
2022-02-17 14:00:00	IWM	ETF	202.73	202.73	201.37	201.515	2029282.0
2022-02-17 15:00:00	IWM	ETF	201.51	201.79	200.78	201.19	4378755.0
2022-02-17 16:00:00	IWM	ETF	201.2	201.65	201.02	201.55	728971.0
2022-02-17 17:00:00	IWM	ETF	201.46	201.64	201.2	201.27	22888.0
2022-02-17 18:00:00	IWM	ETF	201.44	201.85	201.2	201.69	54621.0
2022-02-17 19:00:00	IWM	ETF	201.75	201.8	201.05	201.39	41185.0
2022-02-17 04:00:00	DIA	ETF	347.67	347.67	347.61	347.62	1923.0
2022-02-17 05:00:00	DIA	ETF	347.73	348.32	347.73	348.23	1400.0

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

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