PREVIEW / etf_30min / 2018-02-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-23.parquet
  size:    462 KB
  rows:    15,818

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-23 04:00:00	SPY	ETF	271.73	271.74	271.62	271.68	5727.0
2018-02-23 04:30:00	SPY	ETF	271.83	272.08	271.82	271.96	7115.0
2018-02-23 05:00:00	SPY	ETF	271.95	271.95	271.51	271.51	6790.0
2018-02-23 05:30:00	SPY	ETF	271.53	271.53	271.3	271.49	9017.0
2018-02-23 06:00:00	SPY	ETF	271.51	271.82	271.51	271.82	12900.0
2018-02-23 06:30:00	SPY	ETF	271.76	272.06	271.73	272.04	25955.0
2018-02-23 07:00:00	SPY	ETF	272.04	272.34	272.03	272.25	66172.0
2018-02-23 07:30:00	SPY	ETF	272.23	272.34	271.95	271.95	157555.0
2018-02-23 08:00:00	SPY	ETF	271.99	272.44	271.89	272.02	151067.0
2018-02-23 08:30:00	SPY	ETF	272.11	272.13	271.71	271.78	252894.0
2018-02-23 09:00:00	SPY	ETF	271.83	271.88	271.55	271.81	436078.0
2018-02-23 09:30:00	SPY	ETF	271.79	272.27	271.43	271.89	5242555.0
2018-02-23 10:00:00	SPY	ETF	271.8999	272.21	271.29	271.37	3589074.0
2018-02-23 10:30:00	SPY	ETF	271.38	272.17	271.25	271.97	3277093.0
2018-02-23 11:00:00	SPY	ETF	271.96	272.44	271.89	272.275	4012928.0
2018-02-23 11:30:00	SPY	ETF	272.275	272.9	272.24	272.8	4166491.0
2018-02-23 12:00:00	SPY	ETF	272.81	272.95	272.34	272.41	3460264.0
2018-02-23 12:30:00	SPY	ETF	272.379	272.64	272.24	272.53	2722231.0
2018-02-23 13:00:00	SPY	ETF	272.54	272.54	272.13	272.49	1655517.0
2018-02-23 13:30:00	SPY	ETF	272.49	272.8	272.431	272.76	6746676.0
2018-02-23 14:00:00	SPY	ETF	272.76	272.93	272.37	272.81	3171455.0
2018-02-23 14:30:00	SPY	ETF	272.805	273.64	272.62	273.509	4569220.0
2018-02-23 15:00:00	SPY	ETF	273.505	274.31	273.495	274.12	8098567.0
2018-02-23 15:30:00	SPY	ETF	274.13	274.7	273.85	274.69	16796262.0
2018-02-23 16:00:00	SPY	ETF	274.71	274.93	274.3169	274.68	12903497.0
2018-02-23 16:30:00	SPY	ETF	274.68	274.95	273.65	274.5	2811065.0
2018-02-23 17:00:00	SPY	ETF	274.5	274.71	274.17	274.53	3886870.0
2018-02-23 17:30:00	SPY	ETF	274.53	274.85	274.53	274.76	429669.0
2018-02-23 18:00:00	SPY	ETF	274.76	274.78	274.63	274.65	13209.0
2018-02-23 18:30:00	SPY	ETF	274.71	274.74	274.62	274.7	305995.0
2018-02-23 19:00:00	SPY	ETF	274.72	274.74	274.62	274.67	11499.0
2018-02-23 19:30:00	SPY	ETF	274.69	274.73	274.62	274.7	12231.0
2018-02-23 04:00:00	QQQ	ETF	165.8	165.86	165.71	165.76	26102.0
2018-02-23 04:30:00	QQQ	ETF	165.9	166.07	165.85	165.98	19370.0
2018-02-23 05:00:00	QQQ	ETF	165.9	165.93	165.7	165.7	14331.0
2018-02-23 05:30:00	QQQ	ETF	165.68	165.73	165.58	165.72	29550.0
2018-02-23 06:00:00	QQQ	ETF	165.72	165.89	165.72	165.83	6500.0
2018-02-23 06:30:00	QQQ	ETF	165.84	166.08	165.78	166.05	13675.0
2018-02-23 07:00:00	QQQ	ETF	166.06	166.21	166.05	166.18	66430.0
2018-02-23 07:30:00	QQQ	ETF	166.18	166.18	166.06	166.1	83097.0
2018-02-23 08:00:00	QQQ	ETF	166.14	166.43	165.73	166.26	242523.0
2018-02-23 08:30:00	QQQ	ETF	166.3	166.31	166.1	166.1	178408.0
2018-02-23 09:00:00	QQQ	ETF	166.14	166.21	166.02	166.06	192807.0
2018-02-23 09:30:00	QQQ	ETF	166.06	166.3	165.7	165.99	2748024.0
2018-02-23 10:00:00	QQQ	ETF	165.99	166.15	165.48	165.54	1729667.0
2018-02-23 10:30:00	QQQ	ETF	165.55	166.1101	165.45	166.06	1360164.0
2018-02-23 11:00:00	QQQ	ETF	166.08	166.46	166.04	166.34	1807634.0
2018-02-23 11:30:00	QQQ	ETF	166.34	166.6699	166.2752	166.61	1463165.0
2018-02-23 12:00:00	QQQ	ETF	166.61	166.73	166.41	166.44	1456514.0
2018-02-23 12:30:00	QQQ	ETF	166.445	166.71	166.41	166.63	1199884.0

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

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