PREVIEW / etf_30min / 2018-04-20

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-20.parquet
  size:    452 KB
  rows:    15,547

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-20 04:00:00	SPY	ETF	268.1	268.42	268.1	268.29	4004.0
2018-04-20 04:30:00	SPY	ETF	268.33	268.5	268.33	268.5	4900.0
2018-04-20 05:00:00	SPY	ETF	268.52	268.55	268.03	268.24	9040.0
2018-04-20 05:30:00	SPY	ETF	268.45	268.78	268.37	268.77	12575.0
2018-04-20 06:00:00	SPY	ETF	268.77	268.79	268.63	268.63	19525.0
2018-04-20 06:30:00	SPY	ETF	268.62	269.24	268.62	269.23	61627.0
2018-04-20 07:00:00	SPY	ETF	269.21	269.43	269.05	269.05	56568.0
2018-04-20 07:30:00	SPY	ETF	269.07	269.11	268.98	269.03	46627.0
2018-04-20 08:00:00	SPY	ETF	269.08	269.11	268.05	268.81	123398.0
2018-04-20 08:30:00	SPY	ETF	268.85	269.08	268.62	268.96	215979.0
2018-04-20 09:00:00	SPY	ETF	268.98	269.18	268.78	268.84	782810.0
2018-04-20 09:30:00	SPY	ETF	268.81	269.06	268.17	268.42	7091676.0
2018-04-20 10:00:00	SPY	ETF	268.42	268.44	267.9	268.32	5755340.0
2018-04-20 10:30:00	SPY	ETF	268.33	268.42	267.22	267.48	11605154.0
2018-04-20 11:00:00	SPY	ETF	267.46	267.5	266.42	266.545	6732338.0
2018-04-20 11:30:00	SPY	ETF	266.56	268.9024	266.5	267.025	4203801.0
2018-04-20 12:00:00	SPY	ETF	267.03	267.07	266.4492	266.6245	4244245.0
2018-04-20 12:30:00	SPY	ETF	266.62	266.82	266.08	266.37	3703305.0
2018-04-20 13:00:00	SPY	ETF	266.35	266.97	266.21	266.96	3921467.0
2018-04-20 13:30:00	SPY	ETF	266.95	267.3	266.79	266.9508	4376947.0
2018-04-20 14:00:00	SPY	ETF	266.95	267.0866	266.63	266.8548	2925687.0
2018-04-20 14:30:00	SPY	ETF	266.85	266.9851	266.27	266.5592	4796256.0
2018-04-20 15:00:00	SPY	ETF	266.55	266.57	265.61	266.01	9956315.0
2018-04-20 15:30:00	SPY	ETF	266.01	266.63	265.79	266.63	15433062.0
2018-04-20 16:00:00	SPY	ETF	266.62	266.89	266.53	266.78	8879182.0
2018-04-20 16:30:00	SPY	ETF	266.77	266.81	266.61	266.68	2510289.0
2018-04-20 17:00:00	SPY	ETF	266.68	266.76	266.67	266.72	34067.0
2018-04-20 17:30:00	SPY	ETF	266.72	266.79	266.68	266.74	13578.0
2018-04-20 18:00:00	SPY	ETF	266.73	266.87	266.71	266.87	33057.0
2018-04-20 18:30:00	SPY	ETF	266.87	267.01	266.61	267.01	388740.0
2018-04-20 19:00:00	SPY	ETF	266.98	267.08	266.9	267.0	13257.0
2018-04-20 19:30:00	SPY	ETF	267.05	267.18	267.0	267.11	35147.0
2018-04-20 04:00:00	QQQ	ETF	164.32	164.34	164.07	164.26	18326.0
2018-04-20 04:30:00	QQQ	ETF	164.28	164.42	164.26	164.41	5800.0
2018-04-20 05:00:00	QQQ	ETF	164.48	164.49	164.12	164.16	12920.0
2018-04-20 05:30:00	QQQ	ETF	164.24	164.61	164.24	164.61	13170.0
2018-04-20 06:00:00	QQQ	ETF	164.56	164.6	164.47	164.47	8350.0
2018-04-20 06:30:00	QQQ	ETF	164.47	164.94	164.47	164.92	31100.0
2018-04-20 07:00:00	QQQ	ETF	164.93	165.13	164.82	164.88	41868.0
2018-04-20 07:30:00	QQQ	ETF	164.87	164.91	164.78	164.89	17786.0
2018-04-20 08:00:00	QQQ	ETF	164.88	165.1	164.47	164.5	109276.0
2018-04-20 08:30:00	QQQ	ETF	164.53	164.7	164.3	164.65	183230.0
2018-04-20 09:00:00	QQQ	ETF	164.68	164.79	164.45	164.5	198048.0
2018-04-20 09:30:00	QQQ	ETF	164.49	164.61	163.49	163.76	3283220.0
2018-04-20 10:00:00	QQQ	ETF	163.77	163.95	163.35	163.91	2235408.0
2018-04-20 10:30:00	QQQ	ETF	163.92	164.07	163.05	163.26	3168751.0
2018-04-20 11:00:00	QQQ	ETF	163.26	163.32	162.3738	162.42	3834457.0
2018-04-20 11:30:00	QQQ	ETF	162.43	163.0	162.38	162.7032	2285432.0
2018-04-20 12:00:00	QQQ	ETF	162.72	162.81	162.23	162.42	1231484.0
2018-04-20 12:30:00	QQQ	ETF	162.449	162.57	162.08	162.24	2005759.0

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

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