PREVIEW / etf_30min / 2018-02-13

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-13.parquet
  size:    476 KB
  rows:    16,466

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-02-13 04:00:00	SPY	ETF	264.01	264.24	263.87	264.07	20210.0
2018-02-13 04:30:00	SPY	ETF	264.1	264.1	263.66	263.85	25999.0
2018-02-13 05:00:00	SPY	ETF	263.75	264.05	263.63	263.85	13992.0
2018-02-13 05:30:00	SPY	ETF	263.82	264.18	263.7	264.17	9300.0
2018-02-13 06:00:00	SPY	ETF	264.06	264.06	263.64	263.84	52823.0
2018-02-13 06:30:00	SPY	ETF	263.87	264.13	263.5	264.12	93290.0
2018-02-13 07:00:00	SPY	ETF	264.07	264.36	263.97	264.31	88338.0
2018-02-13 07:30:00	SPY	ETF	264.3	264.7	264.12	264.56	97725.0
2018-02-13 08:00:00	SPY	ETF	264.12	264.93	263.76	264.41	129579.0
2018-02-13 08:30:00	SPY	ETF	264.41	264.54	263.84	263.93	299099.0
2018-02-13 09:00:00	SPY	ETF	263.91	264.149	263.56	264.0	460572.0
2018-02-13 09:30:00	SPY	ETF	263.97	264.59	263.31	264.01	8868642.0
2018-02-13 10:00:00	SPY	ETF	263.97	264.9	263.81	264.32	8173828.0
2018-02-13 10:30:00	SPY	ETF	264.32	265.16	263.87	264.86	7751037.0
2018-02-13 11:00:00	SPY	ETF	264.87	265.06	264.15	264.42	6647044.0
2018-02-13 11:30:00	SPY	ETF	264.42	264.95	264.14	264.83	5106761.0
2018-02-13 12:00:00	SPY	ETF	264.84	265.12	264.53	264.6	2203207.0
2018-02-13 12:30:00	SPY	ETF	264.59	264.85	264.24	264.45	3233203.0
2018-02-13 13:00:00	SPY	ETF	264.44	265.95	264.4299	265.72	4188511.0
2018-02-13 13:30:00	SPY	ETF	265.72	266.21	265.5775	265.89	3062062.0
2018-02-13 14:00:00	SPY	ETF	265.895	266.51	265.7962	266.04	3839045.0
2018-02-13 14:30:00	SPY	ETF	266.03	266.29	265.63	266.23	4249547.0
2018-02-13 15:00:00	SPY	ETF	266.22	266.42	265.7499	266.26	3849203.0
2018-02-13 15:30:00	SPY	ETF	266.255	266.62	265.81	266.01	10539638.0
2018-02-13 16:00:00	SPY	ETF	266.01	266.25	265.77	266.08	4564919.0
2018-02-13 16:30:00	SPY	ETF	266.11	266.43	264.65	266.18	563695.0
2018-02-13 17:00:00	SPY	ETF	266.19	266.25	266.0	266.22	1851080.0
2018-02-13 17:30:00	SPY	ETF	266.22	266.22	266.08	266.1	71709.0
2018-02-13 18:00:00	SPY	ETF	266.11	266.27	266.02	266.15	74504.0
2018-02-13 18:30:00	SPY	ETF	266.2	266.39	266.19	266.36	15465.0
2018-02-13 19:00:00	SPY	ETF	266.34	266.39	266.31	266.37	4084.0
2018-02-13 19:30:00	SPY	ETF	266.26	266.48	266.2	266.4	30742.0
2018-02-13 04:00:00	QQQ	ETF	158.72	158.72	158.34	158.44	8487.0
2018-02-13 04:30:00	QQQ	ETF	158.17	158.28	158.17	158.28	250.0
2018-02-13 05:00:00	QQQ	ETF	158.31	158.56	158.15	158.15	4000.0
2018-02-13 05:30:00	QQQ	ETF	158.18	158.34	158.18	158.34	6400.0
2018-02-13 06:00:00	QQQ	ETF	158.18	158.18	157.98	158.09	2487.0
2018-02-13 06:30:00	QQQ	ETF	158.12	158.18	157.74	158.18	5737.0
2018-02-13 07:00:00	QQQ	ETF	158.17	158.36	158.05	158.34	43476.0
2018-02-13 07:30:00	QQQ	ETF	158.3	158.62	158.13	158.47	29606.0
2018-02-13 08:00:00	QQQ	ETF	158.13	158.73	158.13	158.28	70939.0
2018-02-13 08:30:00	QQQ	ETF	158.31	158.41	157.88	157.88	148259.0
2018-02-13 09:00:00	QQQ	ETF	157.89	158.05	157.61	157.96	178342.0
2018-02-13 09:30:00	QQQ	ETF	157.97	158.6689	157.7197	158.36	4288161.0
2018-02-13 10:00:00	QQQ	ETF	158.35	159.225	158.34	158.85	2947101.0
2018-02-13 10:30:00	QQQ	ETF	158.85	159.29	158.5552	159.04	2326841.0
2018-02-13 11:00:00	QQQ	ETF	159.04	159.11	158.56	158.7199	1860439.0
2018-02-13 11:30:00	QQQ	ETF	158.72	158.99	158.44	158.9199	1050274.0
2018-02-13 12:00:00	QQQ	ETF	158.929	159.11	158.65	158.71	822475.0
2018-02-13 12:30:00	QQQ	ETF	158.7	158.835	158.4107	158.57	1028985.0

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

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