PREVIEW / etf_1hour / 2019-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-18.parquet
  size:    331 KB
  rows:    10,906

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
2019-09-18 04:00:00	SPY	ETF	300.74	300.8	300.64	300.64	5690.0
2019-09-18 05:00:00	SPY	ETF	300.55	300.56	300.48	300.52	11965.0
2019-09-18 06:00:00	SPY	ETF	300.52	300.6	300.43	300.53	26646.0
2019-09-18 07:00:00	SPY	ETF	300.63	300.63	300.18	300.36	341853.0
2019-09-18 08:00:00	SPY	ETF	300.36	300.66	300.36	300.63	223720.0
2019-09-18 09:00:00	SPY	ETF	300.62	300.66	299.89	300.16	4982354.0
2019-09-18 10:00:00	SPY	ETF	300.15	300.57	300.11	300.28	4821587.0
2019-09-18 11:00:00	SPY	ETF	300.27	300.3	300.02	300.19	3244551.0
2019-09-18 12:00:00	SPY	ETF	300.18	300.245	300.01	300.0116	2904727.0
2019-09-18 13:00:00	SPY	ETF	300.01	300.21	299.62	300.15	5674434.0
2019-09-18 14:00:00	SPY	ETF	300.1699	300.59	298.24	299.07	25376855.0
2019-09-18 15:00:00	SPY	ETF	299.06	301.22	298.82	301.1	20525552.0
2019-09-18 16:00:00	SPY	ETF	301.1	301.46	300.98	301.11	4343278.0
2019-09-18 17:00:00	SPY	ETF	301.14	301.25	300.96	301.19	221701.0
2019-09-18 18:00:00	SPY	ETF	301.13	301.21	301.02	301.05	140958.0
2019-09-18 19:00:00	SPY	ETF	301.01	301.06	300.8	300.82	171762.0
2019-09-18 04:00:00	QQQ	ETF	192.32	192.4	192.25	192.25	5170.0
2019-09-18 05:00:00	QQQ	ETF	192.26	192.3	192.21	192.25	12687.0
2019-09-18 06:00:00	QQQ	ETF	192.28	192.28	192.17	192.22	9282.0
2019-09-18 07:00:00	QQQ	ETF	192.33	192.34	191.88	192.04	97556.0
2019-09-18 08:00:00	QQQ	ETF	192.3001	192.36	191.9	192.29	58689.0
2019-09-18 09:00:00	QQQ	ETF	192.32	192.33	191.76	191.97	2164771.0
2019-09-18 10:00:00	QQQ	ETF	191.97	192.15	191.9199	192.07	1539518.0
2019-09-18 11:00:00	QQQ	ETF	192.06	192.1053	191.92	191.97	1042247.0
2019-09-18 12:00:00	QQQ	ETF	191.97	192.03	191.6749	191.68	1334135.0
2019-09-18 13:00:00	QQQ	ETF	191.69	191.72	191.28	191.72	2349514.0
2019-09-18 14:00:00	QQQ	ETF	191.7	191.99	190.11	190.83	6306897.0
2019-09-18 15:00:00	QQQ	ETF	190.82	192.6	190.63	192.52	5526475.0
2019-09-18 16:00:00	QQQ	ETF	192.53	192.91	192.5	192.75	1106803.0
2019-09-18 17:00:00	QQQ	ETF	192.73	192.94	192.52	192.85	758755.0
2019-09-18 18:00:00	QQQ	ETF	192.81	192.81	192.62	192.62	28800.0
2019-09-18 19:00:00	QQQ	ETF	192.62	192.63	192.36	192.4	56683.0
2019-09-18 05:00:00	IWM	ETF	157.53	157.53	157.53	157.53	300.0
2019-09-18 06:00:00	IWM	ETF	157.62	157.63	157.61	157.61	6722.0
2019-09-18 07:00:00	IWM	ETF	157.61	157.61	157.4	157.42	125248.0
2019-09-18 08:00:00	IWM	ETF	157.42	157.55	157.42	157.52	116907.0
2019-09-18 09:00:00	IWM	ETF	157.55	157.56	156.78	156.9	1713505.0
2019-09-18 10:00:00	IWM	ETF	156.89	157.01	156.34	156.39	2202855.0
2019-09-18 11:00:00	IWM	ETF	156.39	156.49	155.88	156.04	1859294.0
2019-09-18 12:00:00	IWM	ETF	156.03	156.23	155.78	155.795	1029937.0
2019-09-18 13:00:00	IWM	ETF	155.79	156.38	155.58	156.23	1829041.0
2019-09-18 14:00:00	IWM	ETF	156.29	156.39	155.065	155.39	3011496.0
2019-09-18 15:00:00	IWM	ETF	155.41	156.51	155.24	156.45	3429657.0
2019-09-18 16:00:00	IWM	ETF	156.46	156.67	156.3192	156.45	662806.0
2019-09-18 17:00:00	IWM	ETF	156.54	156.54	156.5	156.52	2947.0
2019-09-18 18:00:00	IWM	ETF	156.49	156.5	156.4	156.46	20915.0
2019-09-18 19:00:00	IWM	ETF	156.4	156.4	156.3	156.31	11049.0
2019-09-18 07:00:00	DIA	ETF	271.32	271.32	271.04	271.14	1103.0
2019-09-18 08:00:00	DIA	ETF	271.1701	271.33	271.1701	271.33	1696.0
2019-09-18 09:00:00	DIA	ETF	271.4	271.41	270.73	271.06	173914.0

> showing 50 of 10,906 rows — these rows as CSV

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