PREVIEW / etf_30min / 2017-11-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-20.parquet
  size:    443 KB
  rows:    15,440

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-20 04:00:00	SPY	ETF	257.55	257.55	257.4	257.41	3451.0
2017-11-20 05:00:00	SPY	ETF	257.41	257.41	257.41	257.41	300.0
2017-11-20 05:30:00	SPY	ETF	257.6	257.6	257.6	257.6	400.0
2017-11-20 06:00:00	SPY	ETF	257.64	257.7	257.58	257.58	7111.0
2017-11-20 06:30:00	SPY	ETF	257.6	257.82	257.59	257.71	45520.0
2017-11-20 07:00:00	SPY	ETF	257.74	257.77	257.63	257.68	164787.0
2017-11-20 07:30:00	SPY	ETF	257.69	257.77	257.64	257.65	53422.0
2017-11-20 08:00:00	SPY	ETF	257.71	257.85	257.62	257.83	132026.0
2017-11-20 08:30:00	SPY	ETF	257.84	258.03	257.81	257.99	173403.0
2017-11-20 09:00:00	SPY	ETF	257.99	258.14	257.99	258.14	517430.0
2017-11-20 09:30:00	SPY	ETF	258.14	258.19	257.86	258.15	5695761.0
2017-11-20 10:00:00	SPY	ETF	258.145	258.26	257.96	258.1	4483928.0
2017-11-20 10:30:00	SPY	ETF	258.11	258.29	258.06	258.26	1852997.0
2017-11-20 11:00:00	SPY	ETF	258.265	258.395	258.21	258.24	2288288.0
2017-11-20 11:30:00	SPY	ETF	258.235	258.36	258.19	258.32	1579173.0
2017-11-20 12:00:00	SPY	ETF	258.32	258.36	258.11	258.2192	1660265.0
2017-11-20 12:30:00	SPY	ETF	258.21	258.36	258.19	258.33	2508992.0
2017-11-20 13:00:00	SPY	ETF	258.33	258.49	258.28	258.4558	1771236.0
2017-11-20 13:30:00	SPY	ETF	258.4599	258.47	258.35	258.47	1494015.0
2017-11-20 14:00:00	SPY	ETF	258.465	258.48	258.365	258.44	1387796.0
2017-11-20 14:30:00	SPY	ETF	258.45	258.49	258.36	258.4	3826578.0
2017-11-20 15:00:00	SPY	ETF	258.409	258.525	258.2	258.26	3121563.0
2017-11-20 15:30:00	SPY	ETF	258.26	258.32	258.13	258.29	6534320.0
2017-11-20 16:00:00	SPY	ETF	258.28	258.42	258.15	258.3	7598606.0
2017-11-20 16:30:00	SPY	ETF	258.31	258.44	257.9996	258.36	413253.0
2017-11-20 17:00:00	SPY	ETF	258.39	258.42	258.36	258.36	47680.0
2017-11-20 17:30:00	SPY	ETF	258.37	258.38	258.33	258.33	26817.0
2017-11-20 18:00:00	SPY	ETF	258.33	258.33	258.21	258.26	84428.0
2017-11-20 18:30:00	SPY	ETF	258.24	258.24	258.2	258.24	15884.0
2017-11-20 19:00:00	SPY	ETF	258.22	258.35	258.12	258.31	64679.0
2017-11-20 19:30:00	SPY	ETF	258.29	258.29	258.2	258.2	48016.0
2017-11-20 04:00:00	QQQ	ETF	153.47	153.69	153.47	153.68	16500.0
2017-11-20 04:30:00	QQQ	ETF	153.64	153.64	153.64	153.64	296.0
2017-11-20 05:30:00	QQQ	ETF	153.69	153.69	153.69	153.69	200.0
2017-11-20 06:00:00	QQQ	ETF	153.79	153.8	153.79	153.8	400.0
2017-11-20 06:30:00	QQQ	ETF	153.89	153.94	153.85	153.85	31411.0
2017-11-20 07:00:00	QQQ	ETF	153.86	153.93	153.84	153.84	35965.0
2017-11-20 07:30:00	QQQ	ETF	153.88	153.94	153.87	153.87	17878.0
2017-11-20 08:00:00	QQQ	ETF	153.85	153.99	153.82	153.96	166834.0
2017-11-20 08:30:00	QQQ	ETF	153.97	154.07	153.95	154.03	70700.0
2017-11-20 09:00:00	QQQ	ETF	154.04	154.11	154.04	154.08	85556.0
2017-11-20 09:30:00	QQQ	ETF	154.08	154.2	153.9	154.0878	2230879.0
2017-11-20 10:00:00	QQQ	ETF	154.09	154.14	153.835	153.87	1602432.0
2017-11-20 10:30:00	QQQ	ETF	153.865	154.01	153.79	153.97	801765.0
2017-11-20 11:00:00	QQQ	ETF	153.98	154.0266	153.83	153.86	1034456.0
2017-11-20 11:30:00	QQQ	ETF	153.86	153.98	153.795	153.93	1229249.0
2017-11-20 12:00:00	QQQ	ETF	153.925	153.96	153.61	153.74	1146382.0
2017-11-20 12:30:00	QQQ	ETF	153.74	153.88	153.725	153.86	365298.0
2017-11-20 13:00:00	QQQ	ETF	153.8653	153.97	153.82	153.94	437691.0
2017-11-20 13:30:00	QQQ	ETF	153.9314	153.9469	153.86	153.91	673719.0

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

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