PREVIEW / etf_1hour / 2020-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-18.parquet
  size:    368 KB
  rows:    12,306

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
2020-02-18 04:00:00	SPY	ETF	336.5	336.5	335.83	336.16	48214.0
2020-02-18 05:00:00	SPY	ETF	336.0	336.6	335.94	336.58	51586.0
2020-02-18 06:00:00	SPY	ETF	336.45	336.54	336.07	336.09	69719.0
2020-02-18 07:00:00	SPY	ETF	336.17	336.51	336.07	336.26	192060.0
2020-02-18 08:00:00	SPY	ETF	336.2	336.83	336.07	336.46	477826.0
2020-02-18 09:00:00	SPY	ETF	336.46	337.12	336.4	336.98	6760597.0
2020-02-18 10:00:00	SPY	ETF	336.98	337.1	335.945	336.3835	8659635.0
2020-02-18 11:00:00	SPY	ETF	336.38	336.465	335.23	335.255	9567018.0
2020-02-18 12:00:00	SPY	ETF	335.26	337.6677	335.21	336.16	4638472.0
2020-02-18 13:00:00	SPY	ETF	336.165	336.5	336.06	336.22	2975415.0
2020-02-18 14:00:00	SPY	ETF	336.23	336.99	335.96	336.9	6707086.0
2020-02-18 15:00:00	SPY	ETF	336.92	337.17	336.41	336.7	9423173.0
2020-02-18 16:00:00	SPY	ETF	336.7	336.84	336.53	336.76	6625003.0
2020-02-18 17:00:00	SPY	ETF	336.7	336.88	336.7	336.88	91586.0
2020-02-18 18:00:00	SPY	ETF	336.86	337.5	336.8	337.44	82421.0
2020-02-18 19:00:00	SPY	ETF	337.47	337.6	337.22	337.25	55949.0
2020-02-18 04:00:00	QQQ	ETF	232.83	232.83	232.36	232.54	51696.0
2020-02-18 05:00:00	QQQ	ETF	232.52	233.07	232.43	233.0	34061.0
2020-02-18 06:00:00	QQQ	ETF	233.04	233.04	232.73	232.74	32870.0
2020-02-18 07:00:00	QQQ	ETF	232.77	233.23	232.77	233.14	157067.0
2020-02-18 08:00:00	QQQ	ETF	232.8999	234.64	232.26	233.39	478874.0
2020-02-18 09:00:00	QQQ	ETF	233.39	234.4	233.25	234.39	3947040.0
2020-02-18 10:00:00	QQQ	ETF	234.39	234.515	233.7	234.3	3829609.0
2020-02-18 11:00:00	QQQ	ETF	234.31	234.39	233.32	233.4	2171423.0
2020-02-18 12:00:00	QQQ	ETF	233.395	234.21	233.33	234.135	1515795.0
2020-02-18 13:00:00	QQQ	ETF	234.155	234.58	234.1266	234.23	1308852.0
2020-02-18 14:00:00	QQQ	ETF	234.235	235.02	234.052	234.9456	2069088.0
2020-02-18 15:00:00	QQQ	ETF	234.95	235.17	234.56	234.74	3114040.0
2020-02-18 16:00:00	QQQ	ETF	234.73	234.91	234.67	234.84	2210277.0
2020-02-18 17:00:00	QQQ	ETF	234.88	234.88	234.74	234.78	9945.0
2020-02-18 18:00:00	QQQ	ETF	234.85	235.39	234.85	235.37	91013.0
2020-02-18 19:00:00	QQQ	ETF	235.4	235.5	235.27	235.34	46131.0
2020-02-18 04:00:00	IWM	ETF	167.27	167.27	167.14	167.14	1357.0
2020-02-18 05:00:00	IWM	ETF	167.15	167.44	167.11	167.4	9750.0
2020-02-18 06:00:00	IWM	ETF	167.41	167.41	167.35	167.35	5100.0
2020-02-18 07:00:00	IWM	ETF	167.32	167.4	167.25	167.34	27150.0
2020-02-18 08:00:00	IWM	ETF	167.23	167.58	167.12	167.53	79369.0
2020-02-18 09:00:00	IWM	ETF	167.5	168.06	167.41	167.74	1592460.0
2020-02-18 10:00:00	IWM	ETF	167.725	168.06	167.16	167.53	1769069.0
2020-02-18 11:00:00	IWM	ETF	167.522	167.56	166.47	166.49	1627488.0
2020-02-18 12:00:00	IWM	ETF	166.49	167.19	166.43	167.11	825213.0
2020-02-18 13:00:00	IWM	ETF	167.115	167.26	166.985	167.18	726109.0
2020-02-18 14:00:00	IWM	ETF	167.18	167.64	167.07	167.53	1622206.0
2020-02-18 15:00:00	IWM	ETF	167.52	167.61	167.3	167.54	1926184.0
2020-02-18 16:00:00	IWM	ETF	167.55	167.9387	167.43	167.53	1184710.0
2020-02-18 17:00:00	IWM	ETF	167.64	167.64	167.64	167.64	2000.0
2020-02-18 18:00:00	IWM	ETF	167.64	167.92	167.64	167.92	6370.0
2020-02-18 19:00:00	IWM	ETF	168.0	168.02	167.8	167.85	4085.0
2020-02-18 04:00:00	DIA	ETF	294.02	294.02	292.99	292.99	269.0
2020-02-18 05:00:00	DIA	ETF	293.31	293.31	293.31	293.31	100.0

> showing 50 of 12,306 rows — these rows as CSV

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