PREVIEW / etf_30min / 2018-06-01

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-01.parquet
  size:    461 KB
  rows:    16,008

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-01 04:00:00	SPY	ETF	271.72	271.83	271.7	271.75	11675.0
2018-06-01 04:30:00	SPY	ETF	271.7	271.74	271.65	271.65	1000.0
2018-06-01 05:00:00	SPY	ETF	271.83	272.06	271.76	272.06	12947.0
2018-06-01 05:30:00	SPY	ETF	272.06	272.17	271.93	272.03	17600.0
2018-06-01 06:00:00	SPY	ETF	272.14	272.14	271.9	271.9	9055.0
2018-06-01 06:30:00	SPY	ETF	271.9	272.1	271.9	272.04	38931.0
2018-06-01 07:00:00	SPY	ETF	272.05	272.11	271.98	272.09	255686.0
2018-06-01 07:30:00	SPY	ETF	272.13	272.2	271.95	272.06	161713.0
2018-06-01 08:00:00	SPY	ETF	272.0301	272.21	271.08	272.11	704715.0
2018-06-01 08:30:00	SPY	ETF	272.11	272.46	270.94	272.45	830351.0
2018-06-01 09:00:00	SPY	ETF	272.45	272.58	272.33	272.4	854302.0
2018-06-01 09:30:00	SPY	ETF	272.41	273.06	272.33	272.94	6920479.0
2018-06-01 10:00:00	SPY	ETF	272.95	273.6	272.41	273.05	10933204.0
2018-06-01 10:30:00	SPY	ETF	273.0553	273.39	272.76	273.26	4513388.0
2018-06-01 11:00:00	SPY	ETF	273.26	273.42	273.05	273.05	4492848.0
2018-06-01 11:30:00	SPY	ETF	273.05	273.49	273.01	273.39	2350399.0
2018-06-01 12:00:00	SPY	ETF	273.4	273.695	273.37	273.495	1764812.0
2018-06-01 12:30:00	SPY	ETF	273.49	273.72	273.45	273.595	2335963.0
2018-06-01 13:00:00	SPY	ETF	273.6	273.94	273.5875	273.8	2800761.0
2018-06-01 13:30:00	SPY	ETF	273.805	273.9	273.59	273.62	2325876.0
2018-06-01 14:00:00	SPY	ETF	273.63	273.72	273.26	273.53	3166031.0
2018-06-01 14:30:00	SPY	ETF	273.534	273.74	273.32	273.63	2806538.0
2018-06-01 15:00:00	SPY	ETF	273.62	273.63	273.09	273.285	4661335.0
2018-06-01 15:30:00	SPY	ETF	273.2875	273.65	273.25	273.65	9478683.0
2018-06-01 16:00:00	SPY	ETF	273.65	273.6962	273.16	273.6	5758937.0
2018-06-01 16:30:00	SPY	ETF	273.6	273.87	273.58	273.68	473894.0
2018-06-01 17:00:00	SPY	ETF	273.61	273.76	273.61	273.7	528394.0
2018-06-01 17:30:00	SPY	ETF	273.7	273.95	273.67	273.89	129658.0
2018-06-01 18:00:00	SPY	ETF	273.83	273.83	273.75	273.8	13387.0
2018-06-01 18:30:00	SPY	ETF	273.79	273.83	273.75	273.75	4216.0
2018-06-01 19:00:00	SPY	ETF	273.75	273.83	273.75	273.8	4200.0
2018-06-01 19:30:00	SPY	ETF	273.84	273.96	273.84	273.96	21659.0
2018-06-01 04:00:00	QQQ	ETF	170.53	170.62	170.53	170.62	4511.0
2018-06-01 05:00:00	QQQ	ETF	170.6	170.69	170.6	170.69	1200.0
2018-06-01 05:30:00	QQQ	ETF	170.73	170.77	170.6	170.67	19123.0
2018-06-01 06:00:00	QQQ	ETF	170.6	170.6	170.54	170.54	1600.0
2018-06-01 06:30:00	QQQ	ETF	170.64	170.66	170.61	170.64	8150.0
2018-06-01 07:00:00	QQQ	ETF	170.66	170.8	170.64	170.8	59536.0
2018-06-01 07:30:00	QQQ	ETF	170.82	170.87	170.73	170.73	51807.0
2018-06-01 08:00:00	QQQ	ETF	170.8	170.86	170.62	170.86	107927.0
2018-06-01 08:30:00	QQQ	ETF	170.63	170.99	170.07	170.98	534739.0
2018-06-01 09:00:00	QQQ	ETF	170.96	171.05	170.84	170.87	309447.0
2018-06-01 09:30:00	QQQ	ETF	170.89	171.56	170.87	171.44	3100098.0
2018-06-01 10:00:00	QQQ	ETF	171.45	172.12	171.12	171.87	4799904.0
2018-06-01 10:30:00	QQQ	ETF	171.88	172.4	171.74	172.25	3081838.0
2018-06-01 11:00:00	QQQ	ETF	172.25	172.445	172.215	172.24	1747705.0
2018-06-01 11:30:00	QQQ	ETF	172.25	172.65	172.22	172.545	1993340.0
2018-06-01 12:00:00	QQQ	ETF	172.55	172.7	172.525	172.6	1123199.0
2018-06-01 12:30:00	QQQ	ETF	172.61	172.68	172.49	172.56	983887.0
2018-06-01 13:00:00	QQQ	ETF	172.57	172.84	172.56	172.76	1729620.0

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

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