PREVIEW / etf_30min / 2017-05-03

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-03.parquet
  size:    428 KB
  rows:    14,714

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-05-03 04:00:00	SPY	ETF	238.39	238.39	238.24	238.32	2010.0
2017-05-03 04:30:00	SPY	ETF	238.32	238.32	238.32	238.32	3710.0
2017-05-03 05:00:00	SPY	ETF	238.35	238.35	238.27	238.32	3800.0
2017-05-03 05:30:00	SPY	ETF	238.31	238.33	238.27	238.32	32185.0
2017-05-03 06:00:00	SPY	ETF	238.31	238.31	238.25	238.25	42944.0
2017-05-03 06:30:00	SPY	ETF	238.29	238.39	238.29	238.35	12778.0
2017-05-03 07:00:00	SPY	ETF	238.35	238.45	238.33	238.41	5494.0
2017-05-03 07:30:00	SPY	ETF	238.43	238.48	238.4	238.41	277083.0
2017-05-03 08:00:00	SPY	ETF	238.3	238.48	238.3	238.37	110493.0
2017-05-03 08:30:00	SPY	ETF	238.34	238.42	238.3	238.4	68620.0
2017-05-03 09:00:00	SPY	ETF	238.42	238.42	238.25	238.3	151440.0
2017-05-03 09:30:00	SPY	ETF	238.29	238.49	238.17	238.375	5836499.0
2017-05-03 10:00:00	SPY	ETF	238.37	238.47	238.05	238.38	5116335.0
2017-05-03 10:30:00	SPY	ETF	238.37	238.42	237.7	237.86	4438806.0
2017-05-03 11:00:00	SPY	ETF	237.8699	238.21	237.86	238.17	4835996.0
2017-05-03 11:30:00	SPY	ETF	238.16	238.44	238.105	238.31	2794822.0
2017-05-03 12:00:00	SPY	ETF	238.315	238.37	238.24	238.33	2171955.0
2017-05-03 12:30:00	SPY	ETF	238.325	238.35	238.15	238.2557	3158114.0
2017-05-03 13:00:00	SPY	ETF	238.25	238.8775	238.01	238.095	4011756.0
2017-05-03 13:30:00	SPY	ETF	238.0943	238.25	238.05	238.21	3957587.0
2017-05-03 14:00:00	SPY	ETF	238.19	238.55	238.045	238.2	6136065.0
2017-05-03 14:30:00	SPY	ETF	238.2	238.475	238.12	238.44	3265398.0
2017-05-03 15:00:00	SPY	ETF	238.44	238.61	238.32	238.42	4111247.0
2017-05-03 15:30:00	SPY	ETF	238.42	238.74	238.39	238.52	9350143.0
2017-05-03 16:00:00	SPY	ETF	238.54	238.6	238.2971	238.46	7371698.0
2017-05-03 16:30:00	SPY	ETF	238.45	238.48	238.35	238.38	1517144.0
2017-05-03 17:00:00	SPY	ETF	238.4	238.58	238.37	238.37	2115738.0
2017-05-03 17:30:00	SPY	ETF	238.38	238.41	238.37	238.38	35652.0
2017-05-03 18:00:00	SPY	ETF	238.38	238.4	238.32	238.4	37294.0
2017-05-03 18:30:00	SPY	ETF	238.38	238.39	238.35	238.36	22940.0
2017-05-03 19:00:00	SPY	ETF	238.36	238.52	238.34	238.52	53921.0
2017-05-03 19:30:00	SPY	ETF	238.52	238.75	238.52	238.67	161565.0
2017-05-03 04:00:00	QQQ	ETF	136.92	137.01	136.92	137.01	6500.0
2017-05-03 05:30:00	QQQ	ETF	137.03	137.04	137.03	137.04	3554.0
2017-05-03 06:00:00	QQQ	ETF	136.99	137.01	136.99	137.01	2600.0
2017-05-03 06:30:00	QQQ	ETF	137.04	137.07	137.04	137.06	4299.0
2017-05-03 07:00:00	QQQ	ETF	137.06	137.11	137.03	137.09	7966.0
2017-05-03 07:30:00	QQQ	ETF	137.11	137.15	137.1	137.11	14105.0
2017-05-03 08:00:00	QQQ	ETF	137.13	137.13	137.06	137.09	12568.0
2017-05-03 08:30:00	QQQ	ETF	137.1	137.2	137.1	137.2	47639.0
2017-05-03 09:00:00	QQQ	ETF	137.2	137.22	137.09	137.14	236957.0
2017-05-03 09:30:00	QQQ	ETF	137.14	137.17	136.86	136.945	2627814.0
2017-05-03 10:00:00	QQQ	ETF	136.94	136.97	136.66	136.9	2341088.0
2017-05-03 10:30:00	QQQ	ETF	136.9	136.99	136.63	136.68	1727474.0
2017-05-03 11:00:00	QQQ	ETF	136.68	136.9	136.615	136.88	1033493.0
2017-05-03 11:30:00	QQQ	ETF	136.88	136.93	136.81	136.85	822273.0
2017-05-03 12:00:00	QQQ	ETF	136.85	136.9461	136.8	136.94	483722.0
2017-05-03 12:30:00	QQQ	ETF	136.945	136.98	136.851	136.9125	391147.0
2017-05-03 13:00:00	QQQ	ETF	136.92	136.97	136.775	136.85	422016.0
2017-05-03 13:30:00	QQQ	ETF	136.86	136.87	136.765	136.83	498955.0

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

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