PREVIEW / etf_30min / 2019-06-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-24.parquet
  size:    495 KB
  rows:    17,426

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-24 04:00:00	SPY	ETF	294.3	294.38	294.22	294.38	38127.0
2019-06-24 04:30:00	SPY	ETF	294.38	294.38	294.27	294.35	3507.0
2019-06-24 05:00:00	SPY	ETF	294.29	294.38	294.27	294.36	9245.0
2019-06-24 05:30:00	SPY	ETF	294.24	294.3	294.24	294.28	4700.0
2019-06-24 06:00:00	SPY	ETF	294.33	294.53	294.33	294.42	18950.0
2019-06-24 06:30:00	SPY	ETF	294.44	294.44	294.24	294.24	20517.0
2019-06-24 07:00:00	SPY	ETF	294.24	294.29	294.07	294.19	93833.0
2019-06-24 07:30:00	SPY	ETF	294.2	294.29	294.16	294.27	31846.0
2019-06-24 08:00:00	SPY	ETF	294.07	294.67	294.07	294.18	66991.0
2019-06-24 08:30:00	SPY	ETF	294.16	294.36	294.15	294.23	118826.0
2019-06-24 09:00:00	SPY	ETF	294.21	294.31	294.13	294.22	221995.0
2019-06-24 09:30:00	SPY	ETF	294.23	294.5	293.85	293.92	5223915.0
2019-06-24 10:00:00	SPY	ETF	293.93	294.55	293.88	294.5323	3013988.0
2019-06-24 10:30:00	SPY	ETF	294.54	294.58	294.06	294.19	3189397.0
2019-06-24 11:00:00	SPY	ETF	294.19	294.43	294.03	294.36	2208245.0
2019-06-24 11:30:00	SPY	ETF	294.36	294.51	294.22	294.25	1456646.0
2019-06-24 12:00:00	SPY	ETF	294.2501	294.36	294.11	294.185	1778563.0
2019-06-24 12:30:00	SPY	ETF	294.185	294.26	294.11	294.14	1596036.0
2019-06-24 13:00:00	SPY	ETF	294.15	294.18	294.05	294.08	1068185.0
2019-06-24 13:30:00	SPY	ETF	294.07	294.21	293.78	293.9	2084828.0
2019-06-24 14:00:00	SPY	ETF	293.89	294.01	293.73	293.815	2457300.0
2019-06-24 14:30:00	SPY	ETF	293.815	293.98	293.74	293.9	1917379.0
2019-06-24 15:00:00	SPY	ETF	293.9	293.99	293.66	293.795	3214753.0
2019-06-24 15:30:00	SPY	ETF	293.8	293.89	293.47	293.64	8255347.0
2019-06-24 16:00:00	SPY	ETF	293.63	293.81	293.5928	293.76	7214697.0
2019-06-24 16:30:00	SPY	ETF	293.77	294.1015	293.6	293.75	1157657.0
2019-06-24 17:00:00	SPY	ETF	293.73	293.78	293.7	293.74	33897.0
2019-06-24 17:30:00	SPY	ETF	293.73	293.75	293.67	293.67	15323.0
2019-06-24 18:00:00	SPY	ETF	293.7	293.85	293.7	293.8	28105.0
2019-06-24 18:30:00	SPY	ETF	293.74	293.8	293.7	293.74	9860.0
2019-06-24 19:00:00	SPY	ETF	293.77	293.87	293.77	293.87	9666.0
2019-06-24 19:30:00	SPY	ETF	293.88	293.88	293.75	293.81	7019.0
2019-06-24 04:00:00	QQQ	ETF	188.7	188.78	188.63	188.76	26975.0
2019-06-24 04:30:00	QQQ	ETF	188.76	188.76	188.64	188.73	22419.0
2019-06-24 05:00:00	QQQ	ETF	188.74	188.74	188.63	188.74	15045.0
2019-06-24 05:30:00	QQQ	ETF	188.63	188.72	188.63	188.72	11500.0
2019-06-24 06:00:00	QQQ	ETF	188.72	188.86	188.72	188.81	16005.0
2019-06-24 06:30:00	QQQ	ETF	188.84	188.84	188.57	188.57	9540.0
2019-06-24 07:00:00	QQQ	ETF	188.59	188.66	188.4	188.53	23842.0
2019-06-24 07:30:00	QQQ	ETF	188.54	188.67	188.54	188.65	25997.0
2019-06-24 08:00:00	QQQ	ETF	188.51	189.0	188.4499	188.56	83003.0
2019-06-24 08:30:00	QQQ	ETF	188.59	188.74	188.55	188.62	39910.0
2019-06-24 09:00:00	QQQ	ETF	188.62	188.67	188.47	188.51	43530.0
2019-06-24 09:30:00	QQQ	ETF	188.52	188.72	188.07	188.12	2554102.0
2019-06-24 10:00:00	QQQ	ETF	188.12	188.6367	188.0801	188.6	1511372.0
2019-06-24 10:30:00	QQQ	ETF	188.62	188.67	188.23	188.34	953055.0
2019-06-24 11:00:00	QQQ	ETF	188.34	188.62	188.29	188.535	870699.0
2019-06-24 11:30:00	QQQ	ETF	188.54	188.67	188.45	188.5627	707496.0
2019-06-24 12:00:00	QQQ	ETF	188.57	188.67	188.39	188.48	383350.0
2019-06-24 12:30:00	QQQ	ETF	188.485	188.59	188.42	188.517	404276.0

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

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