PREVIEW / etf_30min / 2019-01-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-14.parquet
  size:    486 KB
  rows:    17,010

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
2019-01-14 04:00:00	SPY	ETF	257.04	257.09	256.79	257.09	19469.0
2019-01-14 04:30:00	SPY	ETF	257.06	257.06	256.6	256.67	17243.0
2019-01-14 05:00:00	SPY	ETF	256.59	256.67	256.11	256.24	13079.0
2019-01-14 05:30:00	SPY	ETF	256.42	256.42	256.3	256.39	11001.0
2019-01-14 06:00:00	SPY	ETF	256.4	256.46	256.22	256.42	20063.0
2019-01-14 06:30:00	SPY	ETF	256.45	256.7	256.4	256.7	41673.0
2019-01-14 07:00:00	SPY	ETF	256.72	256.88	256.58	256.84	196950.0
2019-01-14 07:30:00	SPY	ETF	256.85	257.05	256.67	256.71	161166.0
2019-01-14 08:00:00	SPY	ETF	256.6701	256.97	256.54	256.68	220779.0
2019-01-14 08:30:00	SPY	ETF	256.68	257.1	256.64	256.92	312471.0
2019-01-14 09:00:00	SPY	ETF	256.95	256.95	256.79	256.92	199208.0
2019-01-14 09:30:00	SPY	ETF	256.86	257.525	256.41	257.17	6983566.0
2019-01-14 10:00:00	SPY	ETF	257.185	257.86	257.0315	257.52	4498983.0
2019-01-14 10:30:00	SPY	ETF	257.52	258.11	257.41	257.84	4768526.0
2019-01-14 11:00:00	SPY	ETF	257.85	258.0	257.17	257.41	2898297.0
2019-01-14 11:30:00	SPY	ETF	257.41	257.97	257.2702	257.59	2747842.0
2019-01-14 12:00:00	SPY	ETF	257.6	258.16	257.4401	258.01	2526189.0
2019-01-14 12:30:00	SPY	ETF	258.01	258.07	257.79	257.85	2555960.0
2019-01-14 13:00:00	SPY	ETF	257.84	258.23	257.68	258.0414	3151877.0
2019-01-14 13:30:00	SPY	ETF	258.05	258.3	257.93	257.97	2884691.0
2019-01-14 14:00:00	SPY	ETF	257.97	258.1	257.48	257.62	3461991.0
2019-01-14 14:30:00	SPY	ETF	257.62	258.22	257.61	258.14	2262826.0
2019-01-14 15:00:00	SPY	ETF	258.15	258.26	257.87	257.91	4177836.0
2019-01-14 15:30:00	SPY	ETF	257.91	258.09	257.33	257.46	12010158.0
2019-01-14 16:00:00	SPY	ETF	257.46	257.6395	257.05	257.41	12200412.0
2019-01-14 16:30:00	SPY	ETF	257.42	257.64	257.39	257.51	450825.0
2019-01-14 17:00:00	SPY	ETF	257.51	257.51	257.42	257.49	60204.0
2019-01-14 17:30:00	SPY	ETF	257.48	257.57	257.48	257.51	63285.0
2019-01-14 18:00:00	SPY	ETF	257.5	257.6	257.38	257.4	55220.0
2019-01-14 18:30:00	SPY	ETF	257.4	257.67	257.38	257.62	810508.0
2019-01-14 19:00:00	SPY	ETF	257.65	258.16	257.65	258.09	48936.0
2019-01-14 19:30:00	SPY	ETF	258.09	258.2	257.6426	258.09	44519.0
2019-01-14 04:00:00	QQQ	ETF	159.5	159.5	159.26	159.5	18862.0
2019-01-14 04:30:00	QQQ	ETF	159.39	159.42	159.16	159.18	6002.0
2019-01-14 05:00:00	QQQ	ETF	159.18	159.24	158.76	158.95	15712.0
2019-01-14 05:30:00	QQQ	ETF	158.93	158.93	158.71	158.85	14650.0
2019-01-14 06:00:00	QQQ	ETF	158.85	158.92	158.74	158.85	16764.0
2019-01-14 06:30:00	QQQ	ETF	158.95	159.04	158.82	159.04	47050.0
2019-01-14 07:00:00	QQQ	ETF	159.08	159.19	158.96	159.18	126919.0
2019-01-14 07:30:00	QQQ	ETF	159.17	159.28	159.06	159.11	63670.0
2019-01-14 08:00:00	QQQ	ETF	160.69	160.69	158.97	159.2	64078.0
2019-01-14 08:30:00	QQQ	ETF	159.18	159.49	159.15	159.36	219387.0
2019-01-14 09:00:00	QQQ	ETF	159.38	159.38	159.24	159.33	83618.0
2019-01-14 09:30:00	QQQ	ETF	159.33	159.35	158.59	158.85	4236146.0
2019-01-14 10:00:00	QQQ	ETF	158.87	159.53	158.7216	159.36	2748138.0
2019-01-14 10:30:00	QQQ	ETF	159.35	159.91	159.28	159.7664	2092301.0
2019-01-14 11:00:00	QQQ	ETF	159.77	159.8701	159.35	159.55	1581562.0
2019-01-14 11:30:00	QQQ	ETF	159.55	159.93	159.44	159.645	1215758.0
2019-01-14 12:00:00	QQQ	ETF	159.6523	159.91	159.4823	159.74	1045193.0
2019-01-14 12:30:00	QQQ	ETF	159.73	159.83	159.56	159.69	779116.0

> showing 50 of 17,010 rows — these rows as CSV

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