PREVIEW / etf_1hour / 2020-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-15.parquet
  size:    353 KB
  rows:    11,615

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-15 04:00:00	SPY	ETF	327.46	327.56	327.37	327.41	4354.0
2020-01-15 05:00:00	SPY	ETF	327.51	327.68	327.47	327.66	14337.0
2020-01-15 06:00:00	SPY	ETF	327.66	327.89	327.64	327.77	23128.0
2020-01-15 07:00:00	SPY	ETF	327.77	327.9	327.58	327.86	98430.0
2020-01-15 08:00:00	SPY	ETF	327.78	327.94	327.05	327.12	323345.0
2020-01-15 09:00:00	SPY	ETF	327.08	328.66	327.04	328.59	4831656.0
2020-01-15 10:00:00	SPY	ETF	328.61	328.9	328.295	328.89	5370042.0
2020-01-15 11:00:00	SPY	ETF	328.89	329.02	328.33	328.64	7075718.0
2020-01-15 12:00:00	SPY	ETF	328.65	328.87	328.1	328.16	8954218.0
2020-01-15 13:00:00	SPY	ETF	328.16	328.27	327.73	327.93	8593293.0
2020-01-15 14:00:00	SPY	ETF	327.93	328.66	327.88	328.255	8264943.0
2020-01-15 15:00:00	SPY	ETF	328.26	328.285	327.26	328.17	15607403.0
2020-01-15 16:00:00	SPY	ETF	328.17	328.5	327.4858	328.5	8201867.0
2020-01-15 17:00:00	SPY	ETF	328.49	328.55	328.19	328.48	1724295.0
2020-01-15 18:00:00	SPY	ETF	328.54	329.04	328.54	328.78	130711.0
2020-01-15 19:00:00	SPY	ETF	328.78	328.85	328.62	328.66	46201.0
2020-01-15 04:00:00	QQQ	ETF	220.04	220.1	219.98	220.06	9242.0
2020-01-15 05:00:00	QQQ	ETF	220.1	220.26	220.1	220.21	16436.0
2020-01-15 06:00:00	QQQ	ETF	220.33	220.38	220.19	220.35	11664.0
2020-01-15 07:00:00	QQQ	ETF	220.31	220.68	220.29	220.6	87909.0
2020-01-15 08:00:00	QQQ	ETF	220.37	220.64	219.94	220.1	188596.0
2020-01-15 09:00:00	QQQ	ETF	219.98	220.9625	219.98	220.91	3117154.0
2020-01-15 10:00:00	QQQ	ETF	220.94	221.2	220.64	221.17	1922679.0
2020-01-15 11:00:00	QQQ	ETF	221.17	221.18	220.6	220.75	1903912.0
2020-01-15 12:00:00	QQQ	ETF	220.76	221.03	220.43	220.48	1787294.0
2020-01-15 13:00:00	QQQ	ETF	220.48	220.58	219.95	220.14	2196649.0
2020-01-15 14:00:00	QQQ	ETF	220.15	220.69	220.085	220.375	2791748.0
2020-01-15 15:00:00	QQQ	ETF	220.395	220.395	219.45	220.17	5018907.0
2020-01-15 16:00:00	QQQ	ETF	220.16	220.39	220.1158	220.39	1130033.0
2020-01-15 17:00:00	QQQ	ETF	220.17	220.44	220.17	220.36	83366.0
2020-01-15 18:00:00	QQQ	ETF	220.4	220.85	220.39	220.69	53272.0
2020-01-15 19:00:00	QQQ	ETF	220.66	220.7	220.51	220.53	27741.0
2020-01-15 04:00:00	IWM	ETF	166.22	166.22	166.17	166.17	559.0
2020-01-15 06:00:00	IWM	ETF	166.39	166.48	166.36	166.48	8500.0
2020-01-15 07:00:00	IWM	ETF	166.51	166.55	166.35	166.55	21650.0
2020-01-15 08:00:00	IWM	ETF	166.4601	166.57	165.99	166.05	764601.0
2020-01-15 09:00:00	IWM	ETF	166.15	167.547	166.14	167.547	1644240.0
2020-01-15 10:00:00	IWM	ETF	167.53	167.7	166.88	167.7	1722605.0
2020-01-15 11:00:00	IWM	ETF	167.69	167.95	167.1	167.57	1745634.0
2020-01-15 12:00:00	IWM	ETF	167.59	167.66	167.03	167.0799	982113.0
2020-01-15 13:00:00	IWM	ETF	167.08	167.39	166.98	167.2	919015.0
2020-01-15 14:00:00	IWM	ETF	167.2	167.695	167.17	167.395	912552.0
2020-01-15 15:00:00	IWM	ETF	167.395	167.41	166.5	167.35	3208531.0
2020-01-15 16:00:00	IWM	ETF	167.36	167.45	167.2726	167.37	742875.0
2020-01-15 17:00:00	IWM	ETF	167.4	167.41	167.37	167.41	7960.0
2020-01-15 18:00:00	IWM	ETF	167.49	167.79	167.49	167.78	21500.0
2020-01-15 19:00:00	IWM	ETF	167.74	167.78	167.61	167.61	7011.0
2020-01-15 05:00:00	DIA	ETF	289.26	289.26	289.18	289.18	200.0
2020-01-15 07:00:00	DIA	ETF	289.49	289.49	289.29	289.47	850.0
2020-01-15 08:00:00	DIA	ETF	289.15	289.15	288.85	288.92	8000.0

> showing 50 of 11,615 rows — these rows as CSV

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