PREVIEW / etf_30min / 2017-11-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-13.parquet
  size:    444 KB
  rows:    15,400

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
2017-11-13 04:00:00	SPY	ETF	258.01	258.09	258.0	258.0	2500.0
2017-11-13 04:30:00	SPY	ETF	257.86	257.91	257.86	257.9	4500.0
2017-11-13 05:00:00	SPY	ETF	257.9	257.9	257.8	257.9	10418.0
2017-11-13 05:30:00	SPY	ETF	257.86	257.86	257.8	257.81	7403.0
2017-11-13 06:00:00	SPY	ETF	257.77	257.8	257.58	257.65	23066.0
2017-11-13 06:30:00	SPY	ETF	257.67	257.75	257.62	257.65	15017.0
2017-11-13 07:00:00	SPY	ETF	257.61	257.67	257.2	257.33	94019.0
2017-11-13 07:30:00	SPY	ETF	257.3	257.45	257.26	257.39	92291.0
2017-11-13 08:00:00	SPY	ETF	257.4	257.5	257.23	257.33	123325.0
2017-11-13 08:30:00	SPY	ETF	257.33	257.34	257.19	257.19	147189.0
2017-11-13 09:00:00	SPY	ETF	257.21	257.34	257.08	257.32	552793.0
2017-11-13 09:30:00	SPY	ETF	257.31	257.85	257.27	257.83	5735529.0
2017-11-13 10:00:00	SPY	ETF	257.82	258.255	257.815	258.23	4770385.0
2017-11-13 10:30:00	SPY	ETF	258.23	258.2499	257.89	258.07	2521891.0
2017-11-13 11:00:00	SPY	ETF	258.0677	258.31	258.0	258.18	2274168.0
2017-11-13 11:30:00	SPY	ETF	258.18	258.28	258.0514	258.28	1442019.0
2017-11-13 12:00:00	SPY	ETF	258.28	258.36	258.2	258.2	1283352.0
2017-11-13 12:30:00	SPY	ETF	258.19	258.27	258.17	258.25	2383362.0
2017-11-13 13:00:00	SPY	ETF	258.26	258.28	258.1	258.23	1701368.0
2017-11-13 13:30:00	SPY	ETF	258.23	258.38	258.19	258.34	1115087.0
2017-11-13 14:00:00	SPY	ETF	258.34	258.42	258.29	258.34	3443876.0
2017-11-13 14:30:00	SPY	ETF	258.345	258.43	258.31	258.34	3121359.0
2017-11-13 15:00:00	SPY	ETF	258.34	258.59	258.32	258.4799	2802244.0
2017-11-13 15:30:00	SPY	ETF	258.47	258.49	258.13	258.34	8146970.0
2017-11-13 16:00:00	SPY	ETF	258.35	258.35	257.5487	258.2	6856332.0
2017-11-13 16:30:00	SPY	ETF	258.2	258.3301	258.1	258.12	500646.0
2017-11-13 17:00:00	SPY	ETF	258.1	258.11	258.03	258.07	84912.0
2017-11-13 17:30:00	SPY	ETF	258.05	258.08	258.02	258.03	64961.0
2017-11-13 18:00:00	SPY	ETF	258.05	258.13	258.0	258.08	53026.0
2017-11-13 18:30:00	SPY	ETF	258.08	258.1	257.96	257.97	10929.0
2017-11-13 19:00:00	SPY	ETF	257.95	258.1	257.9	258.1	54364.0
2017-11-13 19:30:00	SPY	ETF	258.08	258.3165	258.02	258.15	114961.0
2017-11-13 04:30:00	QQQ	ETF	153.68	153.72	153.68	153.71	73428.0
2017-11-13 05:30:00	QQQ	ETF	153.68	153.68	153.61	153.61	12996.0
2017-11-13 06:00:00	QQQ	ETF	153.61	153.61	153.5	153.53	2197.0
2017-11-13 06:30:00	QQQ	ETF	153.54	153.54	153.5	153.5	10896.0
2017-11-13 07:00:00	QQQ	ETF	153.52	153.52	153.24	153.25	41372.0
2017-11-13 07:30:00	QQQ	ETF	153.23	153.31	153.2	153.24	30981.0
2017-11-13 08:00:00	QQQ	ETF	153.4	153.4	153.12	153.17	61259.0
2017-11-13 08:30:00	QQQ	ETF	153.17	153.17	153.01	153.07	44877.0
2017-11-13 09:00:00	QQQ	ETF	153.06	153.15	153.01	153.13	126852.0
2017-11-13 09:30:00	QQQ	ETF	153.13	153.58	153.1	153.55	1708977.0
2017-11-13 10:00:00	QQQ	ETF	153.55	153.89	153.55	153.8575	1263347.0
2017-11-13 10:30:00	QQQ	ETF	153.84	153.87	153.55	153.78	779998.0
2017-11-13 11:00:00	QQQ	ETF	153.79	153.96	153.7	153.8461	501932.0
2017-11-13 11:30:00	QQQ	ETF	153.85	153.95	153.79	153.863	496712.0
2017-11-13 12:00:00	QQQ	ETF	153.87	153.8992	153.8	153.87	239285.0
2017-11-13 12:30:00	QQQ	ETF	153.87	153.9	153.78	153.85	257135.0
2017-11-13 13:00:00	QQQ	ETF	153.85	153.87	153.73	153.805	292902.0
2017-11-13 13:30:00	QQQ	ETF	153.81	153.89	153.8	153.87	376140.0

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

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