PREVIEW / etf_30min / 2017-11-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-07.parquet
  size:    455 KB
  rows:    15,807

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-07 04:00:00	SPY	ETF	258.93	259.04	258.92	259.04	12685.0
2017-11-07 04:30:00	SPY	ETF	259.0	259.02	258.83	258.95	12747.0
2017-11-07 05:00:00	SPY	ETF	258.92	258.92	258.83	258.83	800.0
2017-11-07 05:30:00	SPY	ETF	258.8	258.8	258.8	258.8	100.0
2017-11-07 06:00:00	SPY	ETF	258.9	258.9	258.78	258.78	6410.0
2017-11-07 06:30:00	SPY	ETF	258.8	258.9	258.79	258.79	6410.0
2017-11-07 07:00:00	SPY	ETF	258.82	258.85	258.81	258.83	33656.0
2017-11-07 07:30:00	SPY	ETF	258.8	258.8	258.66	258.71	46925.0
2017-11-07 08:00:00	SPY	ETF	258.69	258.85	258.69	258.82	125978.0
2017-11-07 08:30:00	SPY	ETF	258.81	258.94	258.8	258.92	98510.0
2017-11-07 09:00:00	SPY	ETF	258.9	259.02	258.81	259.0	131703.0
2017-11-07 09:30:00	SPY	ETF	258.97	259.35	258.9	259.2	4911745.0
2017-11-07 10:00:00	SPY	ETF	259.2	259.27	258.92	258.98	4986687.0
2017-11-07 10:30:00	SPY	ETF	258.98	259.07	258.56	258.735	4023391.0
2017-11-07 11:00:00	SPY	ETF	258.74	258.935	258.71	258.765	4977400.0
2017-11-07 11:30:00	SPY	ETF	258.7699	258.815	258.21	258.26	4076608.0
2017-11-07 12:00:00	SPY	ETF	258.26	258.43	258.09	258.38	4151850.0
2017-11-07 12:30:00	SPY	ETF	258.37	258.52	258.33	258.4238	1964704.0
2017-11-07 13:00:00	SPY	ETF	258.42	258.62	258.4	258.59	1893151.0
2017-11-07 13:30:00	SPY	ETF	258.6	258.66	258.48	258.49	1386722.0
2017-11-07 14:00:00	SPY	ETF	258.4868	258.5621	258.35	258.43	4518964.0
2017-11-07 14:30:00	SPY	ETF	258.43	258.54	258.3	258.33	2696953.0
2017-11-07 15:00:00	SPY	ETF	258.33	258.46	258.23	258.26	3152120.0
2017-11-07 15:30:00	SPY	ETF	258.27	258.72	258.24	258.7	7985636.0
2017-11-07 16:00:00	SPY	ETF	258.69	258.7645	258.4929	258.66	4270788.0
2017-11-07 16:30:00	SPY	ETF	258.66	258.66	258.55	258.56	374620.0
2017-11-07 17:00:00	SPY	ETF	258.57	258.62	258.54	258.58	95533.0
2017-11-07 17:30:00	SPY	ETF	258.58	258.58	258.36	258.37	140141.0
2017-11-07 18:00:00	SPY	ETF	258.4	258.4	258.07	258.18	97924.0
2017-11-07 18:30:00	SPY	ETF	258.18	258.2	257.98	258.08	71781.0
2017-11-07 19:00:00	SPY	ETF	258.08	258.3	258.08	258.2	20763.0
2017-11-07 19:30:00	SPY	ETF	258.17	258.19	258.04	258.13	27215.0
2017-11-07 04:00:00	QQQ	ETF	153.84	153.86	153.82	153.86	1650.0
2017-11-07 04:30:00	QQQ	ETF	153.85	153.85	153.69	153.69	2313.0
2017-11-07 05:00:00	QQQ	ETF	153.73	153.73	153.68	153.68	350.0
2017-11-07 05:30:00	QQQ	ETF	153.64	153.71	153.61	153.71	19970.0
2017-11-07 06:00:00	QQQ	ETF	153.74	153.74	153.73	153.73	10200.0
2017-11-07 06:30:00	QQQ	ETF	153.7	153.76	153.7	153.76	10500.0
2017-11-07 07:00:00	QQQ	ETF	153.74	153.74	153.69	153.69	2570.0
2017-11-07 07:30:00	QQQ	ETF	153.65	153.65	153.56	153.58	20148.0
2017-11-07 08:00:00	QQQ	ETF	153.62	153.7	153.61	153.7	23020.0
2017-11-07 08:30:00	QQQ	ETF	153.7	153.77	153.69	153.74	57707.0
2017-11-07 09:00:00	QQQ	ETF	153.68	153.73	153.6	153.65	67027.0
2017-11-07 09:30:00	QQQ	ETF	153.67	154.0823	153.65	153.92	2332827.0
2017-11-07 10:00:00	QQQ	ETF	153.91	153.94	153.61	153.72	1670994.0
2017-11-07 10:30:00	QQQ	ETF	153.71	153.819	153.5	153.64	1465405.0
2017-11-07 11:00:00	QQQ	ETF	153.65	153.8367	153.54	153.62	1269927.0
2017-11-07 11:30:00	QQQ	ETF	153.61	153.8601	153.4	153.45	1423233.0
2017-11-07 12:00:00	QQQ	ETF	153.45	153.629	153.34	153.61	2002463.0
2017-11-07 12:30:00	QQQ	ETF	153.61	153.81	153.579	153.73	662405.0

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

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