PREVIEW / etf_30min / 2018-04-27

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-27.parquet
  size:    433 KB
  rows:    15,042

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-27 04:00:00	SPY	ETF	266.66	266.68	266.59	266.59	2425.0
2018-04-27 04:30:00	SPY	ETF	266.5	266.5	266.4	266.47	8300.0
2018-04-27 05:00:00	SPY	ETF	266.46	266.48	266.25	266.3	15085.0
2018-04-27 05:30:00	SPY	ETF	266.3	266.65	266.3	266.65	10686.0
2018-04-27 06:00:00	SPY	ETF	266.65	266.91	266.62	266.81	1750.0
2018-04-27 06:30:00	SPY	ETF	266.8	266.89	266.64	266.64	19254.0
2018-04-27 07:00:00	SPY	ETF	266.69	266.74	266.56	266.72	65849.0
2018-04-27 07:30:00	SPY	ETF	266.78	266.93	266.77	266.92	88921.0
2018-04-27 08:00:00	SPY	ETF	266.86	266.95	266.62	266.84	260632.0
2018-04-27 08:30:00	SPY	ETF	266.8	267.1899	266.72	267.17	469918.0
2018-04-27 09:00:00	SPY	ETF	267.17	267.24	266.96	266.98	313551.0
2018-04-27 09:30:00	SPY	ETF	267.0	267.34	266.37	266.48	7455476.0
2018-04-27 10:00:00	SPY	ETF	266.46	267.03	266.22	266.3	5406680.0
2018-04-27 10:30:00	SPY	ETF	266.3	266.31	265.5	265.88	5347616.0
2018-04-27 11:00:00	SPY	ETF	265.87	266.73	265.8	266.72	3081725.0
2018-04-27 11:30:00	SPY	ETF	266.7	266.7	265.99	266.19	2443799.0
2018-04-27 12:00:00	SPY	ETF	266.2	266.59	266.2	266.42	1875017.0
2018-04-27 12:30:00	SPY	ETF	266.43	267.07	266.06	266.95	2786244.0
2018-04-27 13:00:00	SPY	ETF	266.95	267.11	266.66	266.68	2561378.0
2018-04-27 13:30:00	SPY	ETF	266.66	266.81	266.4469	266.56	1275456.0
2018-04-27 14:00:00	SPY	ETF	266.57	266.72	266.35	266.67	2270544.0
2018-04-27 14:30:00	SPY	ETF	266.66	266.83	266.48	266.73	2044775.0
2018-04-27 15:00:00	SPY	ETF	266.72	267.02	266.31	266.45	3435115.0
2018-04-27 15:30:00	SPY	ETF	266.45	266.93	266.39	266.58	7990682.0
2018-04-27 16:00:00	SPY	ETF	266.57	266.94	266.56	266.8	6242287.0
2018-04-27 16:30:00	SPY	ETF	266.8	266.94	266.56	266.86	254180.0
2018-04-27 17:00:00	SPY	ETF	266.87	266.87	266.56	266.64	351712.0
2018-04-27 17:30:00	SPY	ETF	266.64	266.75	266.63	266.66	12881.0
2018-04-27 18:00:00	SPY	ETF	266.69	266.69	266.68	266.68	925.0
2018-04-27 18:30:00	SPY	ETF	266.68	266.71	266.62	266.62	6944.0
2018-04-27 19:00:00	SPY	ETF	266.63	266.63	266.58	266.58	4354.0
2018-04-27 19:30:00	SPY	ETF	266.6	266.61	266.54	266.55	9374.0
2018-04-27 04:00:00	QQQ	ETF	164.17	164.18	164.11	164.11	5998.0
2018-04-27 04:30:00	QQQ	ETF	164.04	164.09	164.0	164.09	5590.0
2018-04-27 05:00:00	QQQ	ETF	164.07	164.07	163.89	163.89	2863.0
2018-04-27 05:30:00	QQQ	ETF	163.92	164.13	163.92	164.13	5900.0
2018-04-27 06:00:00	QQQ	ETF	164.1	164.25	164.1	164.25	1842.0
2018-04-27 06:30:00	QQQ	ETF	164.27	164.32	164.18	164.18	3000.0
2018-04-27 07:00:00	QQQ	ETF	164.15	164.24	164.01	164.2	90747.0
2018-04-27 07:30:00	QQQ	ETF	164.19	164.35	164.19	164.35	76168.0
2018-04-27 08:00:00	QQQ	ETF	164.32	164.54	164.12	164.46	156906.0
2018-04-27 08:30:00	QQQ	ETF	164.42	164.76	164.42	164.75	488487.0
2018-04-27 09:00:00	QQQ	ETF	164.75	164.79	164.3	164.34	424809.0
2018-04-27 09:30:00	QQQ	ETF	164.35	164.41	162.4036	162.55	9538711.0
2018-04-27 10:00:00	QQQ	ETF	162.55	163.13	161.98	162.06	5502365.0
2018-04-27 10:30:00	QQQ	ETF	162.06	162.06	161.17	161.57	5376815.0
2018-04-27 11:00:00	QQQ	ETF	161.56	162.5775	161.5	162.57	3242460.0
2018-04-27 11:30:00	QQQ	ETF	162.56	162.56	161.72	161.95	2081334.0
2018-04-27 12:00:00	QQQ	ETF	161.95	162.41	161.95	162.0	973644.0
2018-04-27 12:30:00	QQQ	ETF	162.0	162.28	161.49	162.26	2009949.0

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

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