PREVIEW / etf_1hour / 2020-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-13.parquet
  size:    362 KB
  rows:    12,029

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-01-13 04:00:00	SPY	ETF	326.67	326.92	326.56	326.84	20922.0
2020-01-13 05:00:00	SPY	ETF	326.93	326.93	326.77	326.89	9847.0
2020-01-13 06:00:00	SPY	ETF	326.86	326.91	326.26	326.31	38238.0
2020-01-13 07:00:00	SPY	ETF	326.27	326.62	326.21	326.49	136382.0
2020-01-13 08:00:00	SPY	ETF	326.49	326.83	325.71	326.54	308486.0
2020-01-13 09:00:00	SPY	ETF	326.54	326.72	325.92	326.65	4605886.0
2020-01-13 10:00:00	SPY	ETF	326.65	326.94	326.3	326.855	5046849.0
2020-01-13 11:00:00	SPY	ETF	326.85	327.29	326.73	327.27	5438848.0
2020-01-13 12:00:00	SPY	ETF	327.27	327.545	327.25	327.31	4812409.0
2020-01-13 13:00:00	SPY	ETF	327.31	327.4599	327.19	327.23	4146729.0
2020-01-13 14:00:00	SPY	ETF	327.23	327.6	327.13	327.55	3937120.0
2020-01-13 15:00:00	SPY	ETF	327.55	327.96	327.34	327.94	8846973.0
2020-01-13 16:00:00	SPY	ETF	327.94	328.1501	327.7312	327.92	4201994.0
2020-01-13 17:00:00	SPY	ETF	327.99	328.1	327.92	328.03	158544.0
2020-01-13 18:00:00	SPY	ETF	328.04	328.46	327.97	328.39	131945.0
2020-01-13 19:00:00	SPY	ETF	328.37	328.69	328.37	328.55	94856.0
2020-01-13 04:00:00	QQQ	ETF	219.27	219.47	219.2	219.45	30512.0
2020-01-13 05:00:00	QQQ	ETF	219.5	219.53	219.39	219.39	25754.0
2020-01-13 06:00:00	QQQ	ETF	219.48	219.48	219.08	219.1	29235.0
2020-01-13 07:00:00	QQQ	ETF	219.06	219.28	219.06	219.22	44638.0
2020-01-13 08:00:00	QQQ	ETF	219.18	219.47	219.04	219.28	130127.0
2020-01-13 09:00:00	QQQ	ETF	219.25	219.79	218.98	219.68	2475366.0
2020-01-13 10:00:00	QQQ	ETF	219.68	219.805	219.3699	219.735	2073334.0
2020-01-13 11:00:00	QQQ	ETF	219.74	220.3	219.64	220.29	2774091.0
2020-01-13 12:00:00	QQQ	ETF	220.29	220.56	220.29	220.44	1454974.0
2020-01-13 13:00:00	QQQ	ETF	220.445	220.64	220.37	220.47	768657.0
2020-01-13 14:00:00	QQQ	ETF	220.47	220.75	220.37	220.62	1662582.0
2020-01-13 15:00:00	QQQ	ETF	220.625	220.98	220.46	220.95	2795887.0
2020-01-13 16:00:00	QQQ	ETF	220.94	221.18	220.87	221.04	2861029.0
2020-01-13 17:00:00	QQQ	ETF	221.01	221.09	220.95	221.04	21848.0
2020-01-13 18:00:00	QQQ	ETF	221.0	221.48	221.0	221.44	33486.0
2020-01-13 19:00:00	QQQ	ETF	221.4	221.65	221.4	221.53	63118.0
2020-01-13 04:00:00	IWM	ETF	165.33	165.48	165.29	165.47	7100.0
2020-01-13 05:00:00	IWM	ETF	165.45	165.45	165.45	165.45	1600.0
2020-01-13 06:00:00	IWM	ETF	165.45	165.45	165.22	165.22	3464.0
2020-01-13 07:00:00	IWM	ETF	165.08	165.25	165.08	165.121	16787.0
2020-01-13 08:00:00	IWM	ETF	165.1301	165.28	165.01	165.04	31323.0
2020-01-13 09:00:00	IWM	ETF	165.07	165.11	164.07	164.94	1967211.0
2020-01-13 10:00:00	IWM	ETF	164.97	165.07	164.53	165.02	1267795.0
2020-01-13 11:00:00	IWM	ETF	165.01	165.36	164.92	165.29	1058095.0
2020-01-13 12:00:00	IWM	ETF	165.3	165.75	165.3	165.62	1201578.0
2020-01-13 13:00:00	IWM	ETF	165.62	165.7	165.4772	165.62	653833.0
2020-01-13 14:00:00	IWM	ETF	165.63	165.92	165.55	165.878	1168341.0
2020-01-13 15:00:00	IWM	ETF	165.87	166.04	165.61	165.95	3224089.0
2020-01-13 16:00:00	IWM	ETF	165.94	166.02	165.83	165.83	2962202.0
2020-01-13 18:00:00	IWM	ETF	165.88	166.1	165.86	166.1	8290.0
2020-01-13 19:00:00	IWM	ETF	166.19	166.27	166.19	166.2	7920.0
2020-01-13 04:00:00	DIA	ETF	289.1	289.15	289.0	289.0	450.0
2020-01-13 05:00:00	DIA	ETF	289.28	289.35	289.28	289.35	250.0
2020-01-13 06:00:00	DIA	ETF	289.13	289.13	289.13	289.13	100.0

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

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