PREVIEW / etf_30min / 2019-12-02

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-02.parquet
  size:    529 KB
  rows:    18,722

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.57	315.66	11140.0
2019-12-02 04:30:00	SPY	ETF	315.6	315.67	315.5	315.53	3550.0
2019-12-02 05:00:00	SPY	ETF	315.6	315.75	315.6	315.73	2850.0
2019-12-02 05:30:00	SPY	ETF	315.7	315.74	315.58	315.6	6068.0
2019-12-02 06:00:00	SPY	ETF	315.55	315.55	315.05	315.2	13308.0
2019-12-02 06:30:00	SPY	ETF	315.2	315.2	314.79	315.01	17934.0
2019-12-02 07:00:00	SPY	ETF	314.99	315.03	314.82	314.93	135979.0
2019-12-02 07:30:00	SPY	ETF	314.96	315.07	314.88	315.01	82354.0
2019-12-02 08:00:00	SPY	ETF	314.97	315.42	314.1872	314.77	121524.0
2019-12-02 08:30:00	SPY	ETF	314.77	314.78	314.49	314.77	103643.0
2019-12-02 09:00:00	SPY	ETF	314.75	314.85	314.59	314.59	143377.0
2019-12-02 09:30:00	SPY	ETF	314.59	314.66	313.02	313.103	6217412.0
2019-12-02 10:00:00	SPY	ETF	313.07	313.09	311.79	312.25	8445956.0
2019-12-02 10:30:00	SPY	ETF	312.25	312.4854	311.27	311.49	7139503.0
2019-12-02 11:00:00	SPY	ETF	311.495	311.86	311.17	311.71	5494610.0
2019-12-02 11:30:00	SPY	ETF	311.71	312.06	311.26	311.97	4152041.0
2019-12-02 12:00:00	SPY	ETF	311.97	312.28	311.36	311.77	5009843.0
2019-12-02 12:30:00	SPY	ETF	311.77	311.82	311.46	311.46	3994919.0
2019-12-02 13:00:00	SPY	ETF	311.4599	312.11	311.41	312.06	2537711.0
2019-12-02 13:30:00	SPY	ETF	312.0699	312.189	311.8	312.04	2216598.0
2019-12-02 14:00:00	SPY	ETF	312.04	312.48	311.95	312.42	2803796.0
2019-12-02 14:30:00	SPY	ETF	312.41	312.6	312.28	312.4	2944624.0
2019-12-02 15:00:00	SPY	ETF	312.39	312.44	311.71	311.775	3206964.0
2019-12-02 15:30:00	SPY	ETF	311.778	312.25	311.48	311.6	10412449.0
2019-12-02 16:00:00	SPY	ETF	311.59	314.1968	311.4943	311.56	7578815.0
2019-12-02 16:30:00	SPY	ETF	311.57	311.64	311.41	311.41	519392.0
2019-12-02 17:00:00	SPY	ETF	311.5	311.64	311.36	311.44	61190.0
2019-12-02 17:30:00	SPY	ETF	311.45	311.55	311.42	311.52	23519.0
2019-12-02 18:00:00	SPY	ETF	311.55	311.63	310.99	311.13	100958.0
2019-12-02 18:30:00	SPY	ETF	311.16	311.42	311.11	311.38	42417.0
2019-12-02 19:00:00	SPY	ETF	311.39	311.56	311.16	311.49	191049.0
2019-12-02 19:30:00	SPY	ETF	311.52	311.86	311.52	311.76	50536.0
2019-12-02 04:00:00	QQQ	ETF	205.98	206.14	205.96	205.96	29317.0
2019-12-02 04:30:00	QQQ	ETF	205.96	205.96	205.86	205.92	65393.0
2019-12-02 05:00:00	QQQ	ETF	205.93	206.05	205.92	206.01	11170.0
2019-12-02 05:30:00	QQQ	ETF	206.01	206.03	205.85	205.85	32778.0
2019-12-02 06:00:00	QQQ	ETF	205.85	205.85	205.54	205.63	32180.0
2019-12-02 06:30:00	QQQ	ETF	205.65	205.65	205.34	205.5	35286.0
2019-12-02 07:00:00	QQQ	ETF	205.49	205.53	205.36	205.45	36644.0
2019-12-02 07:30:00	QQQ	ETF	205.47	205.53	205.4	205.48	17483.0
2019-12-02 08:00:00	QQQ	ETF	205.5	206.0	205.2	205.29	86445.0
2019-12-02 08:30:00	QQQ	ETF	205.27	205.34	205.06	205.29	106349.0
2019-12-02 09:00:00	QQQ	ETF	205.27	205.33	205.11	205.11	94834.0
2019-12-02 09:30:00	QQQ	ETF	205.11	205.18	203.43	203.43	3411531.0
2019-12-02 10:00:00	QQQ	ETF	203.42	203.42	202.39	202.69	3565880.0
2019-12-02 10:30:00	QQQ	ETF	202.69	202.74	201.78	202.08	2762187.0
2019-12-02 11:00:00	QQQ	ETF	202.07	202.467	201.86	202.36	1788656.0
2019-12-02 11:30:00	QQQ	ETF	202.3615	202.74	202.05	202.695	1237879.0
2019-12-02 12:00:00	QQQ	ETF	202.69	202.89	202.13	202.44	1735443.0
2019-12-02 12:30:00	QQQ	ETF	202.44	202.54	202.27	202.37	820972.0

> showing 50 of 18,722 rows — these rows as CSV

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