PREVIEW / etf_1hour / 2020-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-05.parquet
  size:    363 KB
  rows:    12,144

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-05 04:00:00	SPY	ETF	330.98	332.6	330.81	332.4	110531.0
2020-02-05 05:00:00	SPY	ETF	332.34	332.5	331.83	332.06	33807.0
2020-02-05 06:00:00	SPY	ETF	331.96	332.32	331.49	331.61	132561.0
2020-02-05 07:00:00	SPY	ETF	331.55	332.0	331.47	331.63	192704.0
2020-02-05 08:00:00	SPY	ETF	331.94	332.34	328.48	332.27	601020.0
2020-02-05 09:00:00	SPY	ETF	332.28	332.43	331.26	331.99	8359245.0
2020-02-05 10:00:00	SPY	ETF	332.0	332.36	330.67	331.56	10384457.0
2020-02-05 11:00:00	SPY	ETF	331.57	332.0	331.13	331.98	5486527.0
2020-02-05 12:00:00	SPY	ETF	331.98	332.26	331.86	331.92	4339936.0
2020-02-05 13:00:00	SPY	ETF	331.91	332.27	331.62	332.11	4433002.0
2020-02-05 14:00:00	SPY	ETF	332.1	332.75	331.76	332.6699	4942489.0
2020-02-05 15:00:00	SPY	ETF	332.67	333.09	332.2	332.82	15103243.0
2020-02-05 16:00:00	SPY	ETF	332.82	333.26	332.48	333.01	9189631.0
2020-02-05 17:00:00	SPY	ETF	333.0	333.2	332.9	333.14	337582.0
2020-02-05 18:00:00	SPY	ETF	333.13	333.35	332.88	332.94	994689.0
2020-02-05 19:00:00	SPY	ETF	332.9	333.16	332.75	333.03	76134.0
2020-02-05 04:00:00	QQQ	ETF	228.85	230.33	228.71	230.2	81151.0
2020-02-05 05:00:00	QQQ	ETF	230.17	230.24	229.69	229.86	66484.0
2020-02-05 06:00:00	QQQ	ETF	229.86	230.16	229.41	229.55	66753.0
2020-02-05 07:00:00	QQQ	ETF	229.5	229.95	229.41	229.64	196857.0
2020-02-05 08:00:00	QQQ	ETF	229.88	230.37	227.06	230.28	456500.0
2020-02-05 09:00:00	QQQ	ETF	230.24	230.3	228.18	228.77	5999844.0
2020-02-05 10:00:00	QQQ	ETF	228.76	229.03	226.85	227.6	8364492.0
2020-02-05 11:00:00	QQQ	ETF	227.6	228.005	227.09	227.94	2582257.0
2020-02-05 12:00:00	QQQ	ETF	227.93	228.195	227.68	227.73	1688095.0
2020-02-05 13:00:00	QQQ	ETF	227.75	227.91	227.26	227.77	1798758.0
2020-02-05 14:00:00	QQQ	ETF	227.77	228.54	227.45	228.475	2162364.0
2020-02-05 15:00:00	QQQ	ETF	228.475	228.885	227.8	228.25	4786453.0
2020-02-05 16:00:00	QQQ	ETF	228.25	228.73	228.05	228.58	1708396.0
2020-02-05 17:00:00	QQQ	ETF	228.51	228.67	228.4	228.67	31058.0
2020-02-05 18:00:00	QQQ	ETF	228.68	228.77	228.37	228.39	40001.0
2020-02-05 19:00:00	QQQ	ETF	228.31	228.63	228.26	228.55	37836.0
2020-02-05 04:00:00	IWM	ETF	165.93	166.64	165.92	166.64	12079.0
2020-02-05 05:00:00	IWM	ETF	166.63	166.7	166.37	166.48	7905.0
2020-02-05 06:00:00	IWM	ETF	166.49	166.49	166.26	166.37	7250.0
2020-02-05 07:00:00	IWM	ETF	166.21	166.43	166.17	166.31	29999.0
2020-02-05 08:00:00	IWM	ETF	166.26	166.77	166.26	166.6	124442.0
2020-02-05 09:00:00	IWM	ETF	166.56	166.66	165.94	166.56	2140242.0
2020-02-05 10:00:00	IWM	ETF	166.56	166.93	165.685	166.06	2454526.0
2020-02-05 11:00:00	IWM	ETF	166.06	166.75	165.96	166.75	1226631.0
2020-02-05 12:00:00	IWM	ETF	166.74	167.1	166.66	167.03	779082.0
2020-02-05 13:00:00	IWM	ETF	167.03	167.405	166.91	167.23	1529540.0
2020-02-05 14:00:00	IWM	ETF	167.21	167.32	166.89	167.27	1153182.0
2020-02-05 15:00:00	IWM	ETF	167.28	167.53	167.055	167.26	4269293.0
2020-02-05 16:00:00	IWM	ETF	167.26	167.59	167.16	167.44	1006652.0
2020-02-05 17:00:00	IWM	ETF	167.43	167.51	167.31	167.5	99741.0
2020-02-05 18:00:00	IWM	ETF	167.55	167.63	167.4	167.4	8990.0
2020-02-05 19:00:00	IWM	ETF	167.36	167.49	167.32	167.48	10550.0
2020-02-05 04:00:00	DIA	ETF	291.01	291.43	291.01	291.43	1000.0
2020-02-05 05:00:00	DIA	ETF	291.07	291.16	290.86	290.86	800.0

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

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