PREVIEW / etf_30min / 2018-04-30

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-30.parquet
  size:    457 KB
  rows:    15,680

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-30 04:00:00	SPY	ETF	267.32	267.57	267.32	267.5	7723.0
2018-04-30 04:30:00	SPY	ETF	267.51	267.61	267.5	267.6	3660.0
2018-04-30 05:00:00	SPY	ETF	267.58	267.6	267.54	267.6	800.0
2018-04-30 05:30:00	SPY	ETF	267.62	267.89	267.57	267.89	13217.0
2018-04-30 06:00:00	SPY	ETF	267.87	267.94	267.74	267.74	28735.0
2018-04-30 06:30:00	SPY	ETF	267.79	267.82	267.62	267.75	10552.0
2018-04-30 07:00:00	SPY	ETF	267.77	267.82	267.52	267.54	26611.0
2018-04-30 07:30:00	SPY	ETF	267.52	267.74	267.52	267.68	72379.0
2018-04-30 08:00:00	SPY	ETF	267.7	267.78	267.42	267.61	48778.0
2018-04-30 08:30:00	SPY	ETF	267.57	267.62	267.28	267.45	151185.0
2018-04-30 09:00:00	SPY	ETF	267.44	267.48	267.16	267.28	358235.0
2018-04-30 09:30:00	SPY	ETF	267.26	267.89	267.205	267.4808	5069568.0
2018-04-30 10:00:00	SPY	ETF	267.48	267.87	266.93	267.26	3333296.0
2018-04-30 10:30:00	SPY	ETF	267.255	267.62	267.09	267.289	2255505.0
2018-04-30 11:00:00	SPY	ETF	267.29	267.52	267.05	267.18	2331591.0
2018-04-30 11:30:00	SPY	ETF	267.18	267.22	266.02	266.26	3888338.0
2018-04-30 12:00:00	SPY	ETF	266.26	266.27	265.5	265.91	3818075.0
2018-04-30 12:30:00	SPY	ETF	265.91	265.9375	265.19	265.7492	2687582.0
2018-04-30 13:00:00	SPY	ETF	265.74	265.92	265.295	265.8	2764591.0
2018-04-30 13:30:00	SPY	ETF	265.8	266.2	265.66	266.06	3117686.0
2018-04-30 14:00:00	SPY	ETF	266.05	266.06	264.98	265.48	5492356.0
2018-04-30 14:30:00	SPY	ETF	265.48	266.5866	265.04	265.22	6790599.0
2018-04-30 15:00:00	SPY	ETF	265.23	265.56	264.75	264.94	5590592.0
2018-04-30 15:30:00	SPY	ETF	264.935	265.65	264.43	264.45	14647261.0
2018-04-30 16:00:00	SPY	ETF	264.44	266.5866	264.35	264.409	14372820.0
2018-04-30 16:30:00	SPY	ETF	264.51	264.51	264.26	264.3	844650.0
2018-04-30 17:00:00	SPY	ETF	264.29	264.51	264.29	264.42	222250.0
2018-04-30 17:30:00	SPY	ETF	264.42	264.47	264.35	264.39	1372202.0
2018-04-30 18:00:00	SPY	ETF	264.43	264.43	264.1	264.12	68937.0
2018-04-30 18:30:00	SPY	ETF	264.2	264.22	264.0	264.1	54047.0
2018-04-30 19:00:00	SPY	ETF	264.1	264.37	264.09	264.37	86100.0
2018-04-30 19:30:00	SPY	ETF	264.39	264.68	264.39	264.63	151819.0
2018-04-30 04:00:00	QQQ	ETF	162.8	163.11	162.8	163.09	50561.0
2018-04-30 04:30:00	QQQ	ETF	163.08	163.16	163.06	163.13	7076.0
2018-04-30 05:00:00	QQQ	ETF	163.09	163.15	163.05	163.09	12700.0
2018-04-30 05:30:00	QQQ	ETF	163.08	163.27	163.08	163.23	19700.0
2018-04-30 06:00:00	QQQ	ETF	163.29	163.29	163.14	163.15	12600.0
2018-04-30 06:30:00	QQQ	ETF	163.17	163.22	163.02	163.22	6039.0
2018-04-30 07:00:00	QQQ	ETF	163.18	163.21	162.9	162.91	39709.0
2018-04-30 07:30:00	QQQ	ETF	162.9	163.12	162.88	163.01	34169.0
2018-04-30 08:00:00	QQQ	ETF	162.97	163.05	162.9	162.95	29536.0
2018-04-30 08:30:00	QQQ	ETF	162.95	162.99	162.7	162.76	150741.0
2018-04-30 09:00:00	QQQ	ETF	162.75	162.78	162.44	162.45	150073.0
2018-04-30 09:30:00	QQQ	ETF	162.48	163.22	162.35	162.93	3433949.0
2018-04-30 10:00:00	QQQ	ETF	162.92	163.48	162.69	163.0592	2822998.0
2018-04-30 10:30:00	QQQ	ETF	163.06	163.23	162.67	162.87	1377059.0
2018-04-30 11:00:00	QQQ	ETF	162.89	163.03	162.42	162.51	1218870.0
2018-04-30 11:30:00	QQQ	ETF	162.5	162.52	161.25	161.49	3320246.0
2018-04-30 12:00:00	QQQ	ETF	161.49	161.49	160.54	161.1	3559608.0
2018-04-30 12:30:00	QQQ	ETF	161.08	161.22	160.62	161.08	2051441.0

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

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