PREVIEW / etf_30min / 2018-04-25

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-25.parquet
  size:    460 KB
  rows:    15,856

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-04-25 04:00:00	SPY	ETF	262.84	262.84	262.47	262.52	9667.0
2018-04-25 04:30:00	SPY	ETF	262.45	262.45	261.98	262.11	18892.0
2018-04-25 05:00:00	SPY	ETF	262.22	262.28	261.81	262.2	8763.0
2018-04-25 05:30:00	SPY	ETF	262.18	262.44	262.18	262.44	9295.0
2018-04-25 06:00:00	SPY	ETF	262.51	262.62	262.48	262.58	19336.0
2018-04-25 06:30:00	SPY	ETF	262.52	262.52	261.82	261.86	101200.0
2018-04-25 07:00:00	SPY	ETF	261.79	262.15	261.55	261.65	153584.0
2018-04-25 07:30:00	SPY	ETF	261.79	262.52	261.71	262.52	261092.0
2018-04-25 08:00:00	SPY	ETF	262.5	263.27	261.63	262.61	246536.0
2018-04-25 08:30:00	SPY	ETF	262.61	262.79	262.17	262.35	409274.0
2018-04-25 09:00:00	SPY	ETF	262.4	263.01	262.4	262.9	433039.0
2018-04-25 09:30:00	SPY	ETF	262.91	263.06	260.85	261.04	11268740.0
2018-04-25 10:00:00	SPY	ETF	261.05	262.31	260.93	262.0266	8390188.0
2018-04-25 10:30:00	SPY	ETF	262.03	262.93	261.956	262.6402	7448917.0
2018-04-25 11:00:00	SPY	ETF	262.64	263.2	262.5	263.0	5634837.0
2018-04-25 11:30:00	SPY	ETF	263.01	263.09	261.83	261.87	4227894.0
2018-04-25 12:00:00	SPY	ETF	261.86	262.59	261.69	262.44	3453649.0
2018-04-25 12:30:00	SPY	ETF	262.44	262.94	262.34	262.561	3980100.0
2018-04-25 13:00:00	SPY	ETF	262.57	263.04	262.25	262.66	3116900.0
2018-04-25 13:30:00	SPY	ETF	262.66	263.44	262.63	263.17	6805118.0
2018-04-25 14:00:00	SPY	ETF	263.18	263.32	262.43	262.68	3880298.0
2018-04-25 14:30:00	SPY	ETF	262.68	264.05	262.53	264.04	7182285.0
2018-04-25 15:00:00	SPY	ETF	264.04	264.13	263.4753	263.66	5398555.0
2018-04-25 15:30:00	SPY	ETF	263.68	263.9	262.66	263.57	12910801.0
2018-04-25 16:00:00	SPY	ETF	263.56	264.28	263.5255	264.26	14779859.0
2018-04-25 16:30:00	SPY	ETF	264.23	264.54	264.08	264.37	976995.0
2018-04-25 17:00:00	SPY	ETF	264.37	264.45	264.14	264.14	510685.0
2018-04-25 17:30:00	SPY	ETF	264.16	264.45	264.0	264.45	304557.0
2018-04-25 18:00:00	SPY	ETF	264.45	265.03	264.45	264.75	390667.0
2018-04-25 18:30:00	SPY	ETF	264.75	264.88	264.68	264.87	12604.0
2018-04-25 19:00:00	SPY	ETF	264.87	264.99	264.72	264.98	60976.0
2018-04-25 19:30:00	SPY	ETF	264.99	264.99	264.73	264.75	13079.0
2018-04-25 04:00:00	QQQ	ETF	158.6	158.6	158.26	158.26	21161.0
2018-04-25 04:30:00	QQQ	ETF	158.24	158.24	157.81	158.0	66339.0
2018-04-25 05:00:00	QQQ	ETF	157.94	158.04	157.6	157.92	12500.0
2018-04-25 05:30:00	QQQ	ETF	157.96	158.09	157.94	158.09	1300.0
2018-04-25 06:00:00	QQQ	ETF	158.16	158.35	158.16	158.33	11000.0
2018-04-25 06:30:00	QQQ	ETF	158.21	158.28	157.87	157.87	90170.0
2018-04-25 07:00:00	QQQ	ETF	157.86	158.11	157.64	157.65	186945.0
2018-04-25 07:30:00	QQQ	ETF	157.68	158.36	157.68	158.36	291785.0
2018-04-25 08:00:00	QQQ	ETF	157.8	158.51	157.67	158.5	84284.0
2018-04-25 08:30:00	QQQ	ETF	158.49	158.75	158.32	158.48	418300.0
2018-04-25 09:00:00	QQQ	ETF	158.56	158.8	158.5	158.79	213724.0
2018-04-25 09:30:00	QQQ	ETF	158.79	158.82	156.79	156.8	7558329.0
2018-04-25 10:00:00	QQQ	ETF	156.81	157.69	156.47	157.58	6525638.0
2018-04-25 10:30:00	QQQ	ETF	157.61	158.65	157.57	158.44	4730668.0
2018-04-25 11:00:00	QQQ	ETF	158.44	159.27	158.31	159.14	3864170.0
2018-04-25 11:30:00	QQQ	ETF	159.14	159.2062	158.01	158.029	2935095.0
2018-04-25 12:00:00	QQQ	ETF	158.03	158.71	157.81	158.53	1635688.0
2018-04-25 12:30:00	QQQ	ETF	158.53	158.95	158.29	158.38	1503077.0

> showing 50 of 15,856 rows — these rows as CSV

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