PREVIEW / etf_1hour / 2019-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-02.parquet
  size:    350 KB
  rows:    11,599

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-12-02 04:00:00	SPY	ETF	315.57	315.8	315.5	315.53	14690.0
2019-12-02 05:00:00	SPY	ETF	315.6	315.75	315.58	315.6	8918.0
2019-12-02 06:00:00	SPY	ETF	315.55	315.55	314.79	315.01	31242.0
2019-12-02 07:00:00	SPY	ETF	314.99	315.07	314.82	315.01	218333.0
2019-12-02 08:00:00	SPY	ETF	314.97	315.42	314.1872	314.77	225167.0
2019-12-02 09:00:00	SPY	ETF	314.75	314.85	313.02	313.103	6360789.0
2019-12-02 10:00:00	SPY	ETF	313.07	313.09	311.27	311.49	15585459.0
2019-12-02 11:00:00	SPY	ETF	311.495	312.06	311.17	311.97	9646651.0
2019-12-02 12:00:00	SPY	ETF	311.97	312.28	311.36	311.46	9004762.0
2019-12-02 13:00:00	SPY	ETF	311.4599	312.189	311.41	312.04	4754309.0
2019-12-02 14:00:00	SPY	ETF	312.04	312.6	311.95	312.4	5748420.0
2019-12-02 15:00:00	SPY	ETF	312.39	312.44	311.48	311.6	13619413.0
2019-12-02 16:00:00	SPY	ETF	311.59	314.1968	311.41	311.41	8098207.0
2019-12-02 17:00:00	SPY	ETF	311.5	311.64	311.36	311.52	84709.0
2019-12-02 18:00:00	SPY	ETF	311.55	311.63	310.99	311.38	143375.0
2019-12-02 19:00:00	SPY	ETF	311.39	311.86	311.16	311.76	241585.0
2019-12-02 04:00:00	QQQ	ETF	205.98	206.14	205.86	205.92	94710.0
2019-12-02 05:00:00	QQQ	ETF	205.93	206.05	205.85	205.85	43948.0
2019-12-02 06:00:00	QQQ	ETF	205.85	205.85	205.34	205.5	67466.0
2019-12-02 07:00:00	QQQ	ETF	205.49	205.53	205.36	205.48	54127.0
2019-12-02 08:00:00	QQQ	ETF	205.5	206.0	205.06	205.29	192794.0
2019-12-02 09:00:00	QQQ	ETF	205.27	205.33	203.43	203.43	3506365.0
2019-12-02 10:00:00	QQQ	ETF	203.42	203.42	201.78	202.08	6328067.0
2019-12-02 11:00:00	QQQ	ETF	202.07	202.74	201.86	202.695	3026535.0
2019-12-02 12:00:00	QQQ	ETF	202.69	202.89	202.13	202.37	2556415.0
2019-12-02 13:00:00	QQQ	ETF	202.36	203.035	202.35	202.93	1323417.0
2019-12-02 14:00:00	QQQ	ETF	202.93	203.31	202.88	203.19	1286689.0
2019-12-02 15:00:00	QQQ	ETF	203.185	203.23	202.75	202.86	3815918.0
2019-12-02 16:00:00	QQQ	ETF	202.8	203.0	202.65	202.67	1532715.0
2019-12-02 17:00:00	QQQ	ETF	202.56	202.81	202.56	202.71	208905.0
2019-12-02 18:00:00	QQQ	ETF	202.74	202.81	202.25	202.57	77864.0
2019-12-02 19:00:00	QQQ	ETF	202.52	202.81	202.4	202.79	47740.0
2019-12-02 04:00:00	IWM	ETF	162.73	162.74	162.73	162.74	4800.0
2019-12-02 05:00:00	IWM	ETF	162.78	162.8	162.74	162.78	8240.0
2019-12-02 06:00:00	IWM	ETF	162.68	162.68	162.09	162.18	23757.0
2019-12-02 07:00:00	IWM	ETF	162.22	162.34	162.06	162.34	38430.0
2019-12-02 08:00:00	IWM	ETF	162.21	162.23	161.96	162.1	86576.0
2019-12-02 09:00:00	IWM	ETF	162.13	162.26	161.33	161.45	1838737.0
2019-12-02 10:00:00	IWM	ETF	161.43	161.43	160.03	160.34	3056941.0
2019-12-02 11:00:00	IWM	ETF	160.31	160.78	160.19	160.7	1444652.0
2019-12-02 12:00:00	IWM	ETF	160.7	160.75	159.91	160.13	1284497.0
2019-12-02 13:00:00	IWM	ETF	160.125	160.415	160.12	160.285	889702.0
2019-12-02 14:00:00	IWM	ETF	160.285	160.445	160.225	160.27	649758.0
2019-12-02 15:00:00	IWM	ETF	160.28	160.37	159.97	160.15	2793124.0
2019-12-02 16:00:00	IWM	ETF	160.19	160.32	160.09	160.17	1373096.0
2019-12-02 17:00:00	IWM	ETF	160.18	160.18	160.11	160.16	2964.0
2019-12-02 18:00:00	IWM	ETF	160.19	160.28	159.97	160.12	40064.0
2019-12-02 19:00:00	IWM	ETF	160.17	160.46	160.09	160.39	21900.0
2019-12-02 04:00:00	DIA	ETF	282.25	282.27	282.25	282.27	250.0
2019-12-02 05:00:00	DIA	ETF	282.32	282.32	282.32	282.32	100.0

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

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