PREVIEW / etf_30min / 2017-01-09

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-09.parquet
  size:    431 KB
  rows:    14,727

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-01-09 04:00:00	SPY	ETF	227.21	227.21	227.17	227.21	4800.0
2017-01-09 04:30:00	SPY	ETF	227.17	227.23	227.12	227.18	5414.0
2017-01-09 05:00:00	SPY	ETF	227.21	227.21	227.11	227.11	1752.0
2017-01-09 05:30:00	SPY	ETF	227.11	227.11	227.04	227.08	4400.0
2017-01-09 06:00:00	SPY	ETF	227.08	227.08	226.93	226.93	8022.0
2017-01-09 06:30:00	SPY	ETF	226.92	226.98	226.83	226.96	21163.0
2017-01-09 07:00:00	SPY	ETF	226.95	227.05	226.9	226.95	31531.0
2017-01-09 07:30:00	SPY	ETF	227.03	227.06	227.0	227.06	16140.0
2017-01-09 08:00:00	SPY	ETF	226.91	227.11	226.91	227.0	127924.0
2017-01-09 08:30:00	SPY	ETF	227.0	227.08	226.84	226.92	151829.0
2017-01-09 09:00:00	SPY	ETF	226.91	226.92	226.79	226.89	150644.0
2017-01-09 09:30:00	SPY	ETF	226.91	226.93	226.4163	226.68	5930935.0
2017-01-09 10:00:00	SPY	ETF	226.685	226.77	226.47	226.725	4074081.0
2017-01-09 10:30:00	SPY	ETF	226.72	227.02	226.65	226.979	4206374.0
2017-01-09 11:00:00	SPY	ETF	226.97	227.0701	226.85	226.98	2466552.0
2017-01-09 11:30:00	SPY	ETF	226.98	226.99	226.73	226.84	1357606.0
2017-01-09 12:00:00	SPY	ETF	226.84	226.95	226.71	226.88	1340937.0
2017-01-09 12:30:00	SPY	ETF	226.88	227.02	226.79	226.96	1611776.0
2017-01-09 13:00:00	SPY	ETF	226.96	226.98	226.68	226.75	1133679.0
2017-01-09 13:30:00	SPY	ETF	226.75	226.82	226.65	226.77	3461428.0
2017-01-09 14:00:00	SPY	ETF	226.775	226.81	226.53	226.655	3520295.0
2017-01-09 14:30:00	SPY	ETF	226.66	226.66	226.431	226.57	2932754.0
2017-01-09 15:00:00	SPY	ETF	226.57	226.78	226.52	226.77	2442534.0
2017-01-09 15:30:00	SPY	ETF	226.77	226.81	226.44	226.49	6035018.0
2017-01-09 16:00:00	SPY	ETF	226.49	226.63	226.4105	226.55	4666818.0
2017-01-09 16:30:00	SPY	ETF	226.55	226.55	226.4107	226.48	316821.0
2017-01-09 17:00:00	SPY	ETF	226.5	226.54	226.46	226.52	37786.0
2017-01-09 17:30:00	SPY	ETF	226.55	226.57	226.54	226.56	37853.0
2017-01-09 18:00:00	SPY	ETF	226.53	226.58	226.28	226.32	149001.0
2017-01-09 18:30:00	SPY	ETF	226.3	226.37	226.29	226.29	20527.0
2017-01-09 19:00:00	SPY	ETF	226.32	226.35	226.3	226.32	1966.0
2017-01-09 19:30:00	SPY	ETF	226.31	226.35	226.27	226.3	28422.0
2017-01-09 04:00:00	QQQ	ETF	122.04	122.04	121.99	122.01	5595.0
2017-01-09 04:30:00	QQQ	ETF	122.01	122.05	122.0	122.05	15950.0
2017-01-09 05:00:00	QQQ	ETF	121.98	122.0	121.98	122.0	1358.0
2017-01-09 05:30:00	QQQ	ETF	121.97	121.98	121.97	121.98	741.0
2017-01-09 06:00:00	QQQ	ETF	121.96	121.96	121.93	121.94	1365.0
2017-01-09 06:30:00	QQQ	ETF	121.89	121.92	121.89	121.92	398.0
2017-01-09 07:00:00	QQQ	ETF	121.93	121.95	121.92	121.95	3500.0
2017-01-09 07:30:00	QQQ	ETF	121.94	122.0	121.94	122.0	3544.0
2017-01-09 08:00:00	QQQ	ETF	121.97	122.01	121.97	121.99	3448.0
2017-01-09 08:30:00	QQQ	ETF	122.01	122.01	121.92	121.96	17804.0
2017-01-09 09:00:00	QQQ	ETF	121.96	122.05	121.93	122.02	132467.0
2017-01-09 09:30:00	QQQ	ETF	122.03	122.305	121.95	122.19	3075928.0
2017-01-09 10:00:00	QQQ	ETF	122.19	122.33	121.95	122.26	1140263.0
2017-01-09 10:30:00	QQQ	ETF	122.2501	122.28	122.09	122.23	971451.0
2017-01-09 11:00:00	QQQ	ETF	122.22	122.4	122.13	122.29	685905.0
2017-01-09 11:30:00	QQQ	ETF	122.29	122.32	122.19	122.3	650822.0
2017-01-09 12:00:00	QQQ	ETF	122.29	122.41	122.24	122.4	805470.0
2017-01-09 12:30:00	QQQ	ETF	122.4	122.46	122.32	122.43	972246.0

> showing 50 of 14,727 rows — these rows as CSV

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