PREVIEW / etf_30min / 2019-06-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-26.parquet
  size:    497 KB
  rows:    17,610

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-06-26 04:00:00	SPY	ETF	291.11	291.11	290.97	290.97	1605.0
2019-06-26 04:30:00	SPY	ETF	291.01	291.32	291.0	291.29	6089.0
2019-06-26 05:00:00	SPY	ETF	291.33	292.47	291.33	292.44	42251.0
2019-06-26 05:30:00	SPY	ETF	292.39	292.4	292.15	292.24	52236.0
2019-06-26 06:00:00	SPY	ETF	292.24	292.5	292.24	292.39	10418.0
2019-06-26 06:30:00	SPY	ETF	292.35	292.4	292.04	292.08	87171.0
2019-06-26 07:00:00	SPY	ETF	292.08	292.2	291.97	292.06	168518.0
2019-06-26 07:30:00	SPY	ETF	292.07	292.18	291.97	292.07	113230.0
2019-06-26 08:00:00	SPY	ETF	292.11	292.18	290.96	291.93	370337.0
2019-06-26 08:30:00	SPY	ETF	291.96	291.96	291.3	291.62	353526.0
2019-06-26 09:00:00	SPY	ETF	291.61	291.84	291.5	291.75	246684.0
2019-06-26 09:30:00	SPY	ETF	291.75	292.31	291.37	291.58	6293391.0
2019-06-26 10:00:00	SPY	ETF	291.56	291.62	291.04	291.29	3217503.0
2019-06-26 10:30:00	SPY	ETF	291.29	291.78	291.29	291.62	2269374.0
2019-06-26 11:00:00	SPY	ETF	291.61	291.81	291.205	291.48	1839381.0
2019-06-26 11:30:00	SPY	ETF	291.49	291.49	291.11	291.46	1396245.0
2019-06-26 12:00:00	SPY	ETF	291.46	291.58	291.14	291.38	2186506.0
2019-06-26 12:30:00	SPY	ETF	291.38	291.68	291.34	291.49	1108755.0
2019-06-26 13:00:00	SPY	ETF	291.49	291.52	291.01	291.015	1831979.0
2019-06-26 13:30:00	SPY	ETF	291.01	291.04	290.7	290.9733	1821707.0
2019-06-26 14:00:00	SPY	ETF	290.97	291.15	290.76	290.985	2837933.0
2019-06-26 14:30:00	SPY	ETF	290.99	291.0	290.345	290.7193	3995016.0
2019-06-26 15:00:00	SPY	ETF	290.715	290.95	290.64	290.67	3609726.0
2019-06-26 15:30:00	SPY	ETF	290.67	291.06	290.4	290.47	9306347.0
2019-06-26 16:00:00	SPY	ETF	290.48	290.6	290.32	290.5	5016431.0
2019-06-26 16:30:00	SPY	ETF	290.5	290.52	290.1	290.17	270738.0
2019-06-26 17:00:00	SPY	ETF	290.17	290.22	290.12	290.18	15882.0
2019-06-26 17:30:00	SPY	ETF	290.18	290.47	290.07	290.09	110068.0
2019-06-26 18:00:00	SPY	ETF	290.14	290.32	290.11	290.3	80725.0
2019-06-26 18:30:00	SPY	ETF	290.3	290.36	290.2	290.2	20347.0
2019-06-26 19:00:00	SPY	ETF	290.2	290.36	290.18	290.3	18892.0
2019-06-26 19:30:00	SPY	ETF	290.31	290.49	290.31	290.46	29190.0
2019-06-26 04:00:00	QQQ	ETF	185.35	185.4	185.3	185.37	8750.0
2019-06-26 04:30:00	QQQ	ETF	185.42	185.57	185.42	185.57	12850.0
2019-06-26 05:00:00	QQQ	ETF	185.6	186.68	185.6	186.68	50419.0
2019-06-26 05:30:00	QQQ	ETF	186.68	186.69	186.45	186.55	57255.0
2019-06-26 06:00:00	QQQ	ETF	186.55	186.82	186.55	186.71	10020.0
2019-06-26 06:30:00	QQQ	ETF	186.6	186.66	186.37	186.45	30237.0
2019-06-26 07:00:00	QQQ	ETF	186.43	186.52	186.25	186.32	76786.0
2019-06-26 07:30:00	QQQ	ETF	186.34	186.47	186.32	186.36	37252.0
2019-06-26 08:00:00	QQQ	ETF	186.47	186.51	185.01	186.33	142576.0
2019-06-26 08:30:00	QQQ	ETF	186.28	186.28	185.52	185.86	354713.0
2019-06-26 09:00:00	QQQ	ETF	185.8	186.18	185.78	186.14	169575.0
2019-06-26 09:30:00	QQQ	ETF	186.14	187.33	186.12	187.0001	4764646.0
2019-06-26 10:00:00	QQQ	ETF	187.01	187.04	186.36	186.58	1805091.0
2019-06-26 10:30:00	QQQ	ETF	186.59	186.85	186.37	186.58	1084517.0
2019-06-26 11:00:00	QQQ	ETF	186.57	186.64	186.14	186.48	883145.0
2019-06-26 11:30:00	QQQ	ETF	186.48	186.55	186.1699	186.55	616513.0
2019-06-26 12:00:00	QQQ	ETF	186.55	186.68	186.23	186.48	697066.0
2019-06-26 12:30:00	QQQ	ETF	186.47	186.65	186.36	186.39	476934.0

> showing 50 of 17,610 rows — these rows as CSV

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