PREVIEW / etf_30min / 2018-12-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-18.parquet
  size:    524 KB
  rows:    18,104

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-12-18 04:00:00	SPY	ETF	256.37	256.53	255.94	256.08	21386.0
2018-12-18 04:30:00	SPY	ETF	256.06	256.82	256.04	256.73	28029.0
2018-12-18 05:00:00	SPY	ETF	256.7	257.0	256.64	256.99	44987.0
2018-12-18 05:30:00	SPY	ETF	256.94	256.94	256.47	256.47	41505.0
2018-12-18 06:00:00	SPY	ETF	256.5	256.89	256.46	256.81	35668.0
2018-12-18 06:30:00	SPY	ETF	256.8	256.95	256.56	256.7	58371.0
2018-12-18 07:00:00	SPY	ETF	256.72	256.86	256.55	256.85	181558.0
2018-12-18 07:30:00	SPY	ETF	256.85	257.74	256.85	257.6	374560.0
2018-12-18 08:00:00	SPY	ETF	257.6	257.78	255.48	257.5	516779.0
2018-12-18 08:30:00	SPY	ETF	257.5	257.51	257.08	257.13	314990.0
2018-12-18 09:00:00	SPY	ETF	257.12	257.46	257.1	257.17	441975.0
2018-12-18 09:30:00	SPY	ETF	257.2	257.95	256.78	257.8138	10372527.0
2018-12-18 10:00:00	SPY	ETF	257.78	257.85	256.89	257.445	6813605.0
2018-12-18 10:30:00	SPY	ETF	257.45	257.79	256.29	256.61	8654990.0
2018-12-18 11:00:00	SPY	ETF	256.62	257.0	255.65	256.05	8298969.0
2018-12-18 11:30:00	SPY	ETF	256.05	256.9	256.03	256.38	7585882.0
2018-12-18 12:00:00	SPY	ETF	256.38	257.8	256.34	257.315	8009228.0
2018-12-18 12:30:00	SPY	ETF	257.32	257.58	256.99	257.34	3671381.0
2018-12-18 13:00:00	SPY	ETF	257.33	257.53	256.59	256.76	4801074.0
2018-12-18 13:30:00	SPY	ETF	256.75	256.7701	255.6	255.9	5664293.0
2018-12-18 14:00:00	SPY	ETF	255.9	256.68	255.77	256.14	8233267.0
2018-12-18 14:30:00	SPY	ETF	256.14	256.17	253.79	253.81	13138135.0
2018-12-18 15:00:00	SPY	ETF	253.81	254.76	253.28	254.18	13902224.0
2018-12-18 15:30:00	SPY	ETF	254.24	256.51	254.2	255.14	19350813.0
2018-12-18 16:00:00	SPY	ETF	255.14	255.26	253.92	254.13	9123302.0
2018-12-18 16:30:00	SPY	ETF	254.11	255.14	253.31	253.43	1977057.0
2018-12-18 17:00:00	SPY	ETF	253.4	253.55	253.3	253.39	308922.0
2018-12-18 17:30:00	SPY	ETF	253.37	255.08	253.3	253.58	89939.0
2018-12-18 18:00:00	SPY	ETF	253.45	255.08	253.45	254.28	795710.0
2018-12-18 18:30:00	SPY	ETF	254.22	254.54	254.2	254.52	159404.0
2018-12-18 19:00:00	SPY	ETF	254.55	254.57	254.01	254.19	167101.0
2018-12-18 19:30:00	SPY	ETF	254.18	254.96	254.16	254.72	237842.0
2018-12-18 20:00:00	SPY	ETF	255.08	255.08	254.7	254.7	270.0
2018-12-18 04:00:00	QQQ	ETF	158.1	158.27	157.94	158.1	19176.0
2018-12-18 04:30:00	QQQ	ETF	158.11	158.56	158.08	158.56	22262.0
2018-12-18 05:00:00	QQQ	ETF	158.51	158.68	158.45	158.67	18450.0
2018-12-18 05:30:00	QQQ	ETF	158.64	158.64	158.3	158.37	34383.0
2018-12-18 06:00:00	QQQ	ETF	158.35	158.71	158.34	158.68	32080.0
2018-12-18 06:30:00	QQQ	ETF	158.64	158.81	158.52	158.64	36870.0
2018-12-18 07:00:00	QQQ	ETF	158.64	158.8	158.57	158.76	84917.0
2018-12-18 07:30:00	QQQ	ETF	158.76	159.15	158.76	159.08	112388.0
2018-12-18 08:00:00	QQQ	ETF	158.71	159.2	158.0	159.13	114617.0
2018-12-18 08:30:00	QQQ	ETF	159.14	159.14	158.64	158.65	152159.0
2018-12-18 09:00:00	QQQ	ETF	158.66	158.9	158.6201	158.67	134184.0
2018-12-18 09:30:00	QQQ	ETF	158.67	159.27	158.25	159.11	5961573.0
2018-12-18 10:00:00	QQQ	ETF	159.12	159.2089	158.32	158.99	3677148.0
2018-12-18 10:30:00	QQQ	ETF	159.0	159.29	158.3699	158.9	3447829.0
2018-12-18 11:00:00	QQQ	ETF	158.9	159.17	158.04	158.29	2455167.0
2018-12-18 11:30:00	QQQ	ETF	158.31	158.95	158.29	158.5999	2892692.0
2018-12-18 12:00:00	QQQ	ETF	158.59	159.87	158.57	159.55	3493315.0

> showing 50 of 18,104 rows — these rows as CSV

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