PREVIEW / etf_30min / 2018-06-20

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-20.parquet
  size:    467 KB
  rows:    16,133

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
2018-06-20 04:00:00	SPY	ETF	276.34	276.39	276.12	276.22	26763.0
2018-06-20 04:30:00	SPY	ETF	276.2	276.26	276.2	276.22	1000.0
2018-06-20 05:00:00	SPY	ETF	276.31	276.46	276.31	276.41	1142.0
2018-06-20 05:30:00	SPY	ETF	276.5	276.5	276.42	276.48	5710.0
2018-06-20 06:00:00	SPY	ETF	276.37	276.37	276.37	276.37	610.0
2018-06-20 06:30:00	SPY	ETF	276.48	276.57	276.38	276.38	11000.0
2018-06-20 07:00:00	SPY	ETF	276.44	276.45	275.96	276.09	80963.0
2018-06-20 07:30:00	SPY	ETF	276.12	276.2	276.06	276.1	68683.0
2018-06-20 08:00:00	SPY	ETF	276.32	276.42	275.62	276.29	133682.0
2018-06-20 08:30:00	SPY	ETF	276.27	276.39	276.21	276.35	102360.0
2018-06-20 09:00:00	SPY	ETF	276.35	276.49	276.08	276.26	797949.0
2018-06-20 09:30:00	SPY	ETF	276.27	276.46	276.08	276.31	5684487.0
2018-06-20 10:00:00	SPY	ETF	276.31	276.44	275.67	275.75	4676667.0
2018-06-20 10:30:00	SPY	ETF	275.7585	276.06	275.59	275.98	3305983.0
2018-06-20 11:00:00	SPY	ETF	275.99	276.175	275.67	276.09	2471622.0
2018-06-20 11:30:00	SPY	ETF	276.1	276.33	275.8942	276.3	1845685.0
2018-06-20 12:00:00	SPY	ETF	276.31	276.48	276.2133	276.31	2078984.0
2018-06-20 12:30:00	SPY	ETF	276.3099	276.72	276.27	276.58	2442486.0
2018-06-20 13:00:00	SPY	ETF	276.58	276.63	276.26	276.32	2841332.0
2018-06-20 13:30:00	SPY	ETF	276.32	276.59	276.32	276.58	2270952.0
2018-06-20 14:00:00	SPY	ETF	276.58	276.65	276.41	276.48	4090356.0
2018-06-20 14:30:00	SPY	ETF	276.47	276.47	275.95	276.0268	2506898.0
2018-06-20 15:00:00	SPY	ETF	276.02	276.31	275.9	276.3	3034135.0
2018-06-20 15:30:00	SPY	ETF	276.3	276.37	275.89	275.98	7392501.0
2018-06-20 16:00:00	SPY	ETF	275.99	276.09	275.4815	276.04	5179919.0
2018-06-20 16:30:00	SPY	ETF	276.04	276.06	275.94	275.97	128577.0
2018-06-20 17:00:00	SPY	ETF	275.97	276.02	275.95	276.01	66566.0
2018-06-20 17:30:00	SPY	ETF	276.01	276.04	276.0	276.03	49005.0
2018-06-20 18:00:00	SPY	ETF	276.02	276.19	275.95	276.19	82850.0
2018-06-20 18:30:00	SPY	ETF	276.12	276.12	276.08	276.08	6020.0
2018-06-20 19:00:00	SPY	ETF	276.12	276.18	276.1	276.18	3415.0
2018-06-20 19:30:00	SPY	ETF	276.18	276.27	276.13	276.25	27146.0
2018-06-20 04:00:00	QQQ	ETF	176.39	176.43	176.29	176.4	11735.0
2018-06-20 04:30:00	QQQ	ETF	176.42	176.43	176.38	176.4	7450.0
2018-06-20 05:00:00	QQQ	ETF	176.48	176.61	176.48	176.58	3300.0
2018-06-20 05:30:00	QQQ	ETF	176.59	176.75	176.52	176.58	7390.0
2018-06-20 06:00:00	QQQ	ETF	176.57	176.62	176.51	176.62	5220.0
2018-06-20 06:30:00	QQQ	ETF	176.59	176.61	176.59	176.6	11549.0
2018-06-20 07:00:00	QQQ	ETF	176.56	176.58	176.31	176.43	23675.0
2018-06-20 07:30:00	QQQ	ETF	176.43	176.49	176.39	176.4	38375.0
2018-06-20 08:00:00	QQQ	ETF	176.56	176.64	176.38	176.61	47957.0
2018-06-20 08:30:00	QQQ	ETF	176.61	176.94	176.57	176.85	93185.0
2018-06-20 09:00:00	QQQ	ETF	176.85	176.98	176.75	176.79	287631.0
2018-06-20 09:30:00	QQQ	ETF	176.79	177.28	176.75	177.15	4674540.0
2018-06-20 10:00:00	QQQ	ETF	177.14	177.34	176.74	176.8	2128886.0
2018-06-20 10:30:00	QQQ	ETF	176.8	177.28	176.65	177.25	1932363.0
2018-06-20 11:00:00	QQQ	ETF	177.26	177.385	177.01	177.275	1559565.0
2018-06-20 11:30:00	QQQ	ETF	177.28	177.51	177.08	177.51	698637.0
2018-06-20 12:00:00	QQQ	ETF	177.55	177.71	177.49	177.62	1436192.0
2018-06-20 12:30:00	QQQ	ETF	177.63	177.9	177.59	177.77	1213571.0

> showing 50 of 16,133 rows — these rows as CSV

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