PREVIEW / etf_30min / 2016-10-05

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-05.parquet
  size:    400 KB
  rows:    13,654

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
2016-10-05 04:00:00	SPY	ETF	214.81	214.88	214.81	214.88	1478.0
2016-10-05 04:30:00	SPY	ETF	214.86	214.9	214.86	214.86	1971.0
2016-10-05 05:00:00	SPY	ETF	215.0	215.0	214.8	214.83	26656.0
2016-10-05 05:30:00	SPY	ETF	214.8	214.83	214.72	214.8	5614.0
2016-10-05 06:00:00	SPY	ETF	214.78	214.88	214.77	214.77	9220.0
2016-10-05 06:30:00	SPY	ETF	214.8	214.8	214.7	214.75	18898.0
2016-10-05 07:00:00	SPY	ETF	214.78	214.98	214.75	214.88	57828.0
2016-10-05 07:30:00	SPY	ETF	214.9	215.33	214.9	215.26	195072.0
2016-10-05 08:00:00	SPY	ETF	215.2	215.48	214.82	215.42	389334.0
2016-10-05 08:30:00	SPY	ETF	215.43	215.43	214.68	215.28	702664.0
2016-10-05 09:00:00	SPY	ETF	215.28	215.41	215.08	215.41	532716.0
2016-10-05 09:30:00	SPY	ETF	215.41	215.77	215.37	215.685	8032481.0
2016-10-05 10:00:00	SPY	ETF	215.685	215.91	215.44	215.759	7567977.0
2016-10-05 10:30:00	SPY	ETF	215.755	215.875	215.33	215.64	8269893.0
2016-10-05 11:00:00	SPY	ETF	215.64	215.86	215.56	215.79	3380804.0
2016-10-05 11:30:00	SPY	ETF	215.79	215.9	215.64	215.7857	2673803.0
2016-10-05 12:00:00	SPY	ETF	215.78	216.035	215.76	215.85	3149845.0
2016-10-05 12:30:00	SPY	ETF	215.855	215.92	215.79	215.845	2432318.0
2016-10-05 13:00:00	SPY	ETF	215.84	215.998	215.73	215.8	2246700.0
2016-10-05 13:30:00	SPY	ETF	215.81	216.01	215.76	215.99	2857144.0
2016-10-05 14:00:00	SPY	ETF	215.98	216.0	215.85	215.87	3093585.0
2016-10-05 14:30:00	SPY	ETF	215.87	216.0	215.8	215.98	3375184.0
2016-10-05 15:00:00	SPY	ETF	215.98	216.13	215.64	215.67	5306610.0
2016-10-05 15:30:00	SPY	ETF	215.66	215.84	215.56	215.66	9290630.0
2016-10-05 16:00:00	SPY	ETF	215.64	215.8757	214.7658	215.68	6814200.0
2016-10-05 16:30:00	SPY	ETF	215.69	215.79	215.63	215.73	347498.0
2016-10-05 17:00:00	SPY	ETF	215.75	215.75	215.7	215.73	80321.0
2016-10-05 17:30:00	SPY	ETF	215.72	215.77	215.7	215.72	28210.0
2016-10-05 18:00:00	SPY	ETF	215.7	215.8	215.65	215.77	75175.0
2016-10-05 18:30:00	SPY	ETF	215.77	215.78	215.7	215.7	14000.0
2016-10-05 19:00:00	SPY	ETF	215.7	215.72	215.68	215.68	4303.0
2016-10-05 19:30:00	SPY	ETF	215.7	215.7	215.66	215.67	15796.0
2016-10-05 04:00:00	QQQ	ETF	118.33	118.5	118.33	118.38	4900.0
2016-10-05 06:00:00	QQQ	ETF	118.4	118.4	118.4	118.4	200.0
2016-10-05 06:30:00	QQQ	ETF	118.38	118.38	118.38	118.38	200.0
2016-10-05 07:00:00	QQQ	ETF	118.41	118.52	118.41	118.49	54895.0
2016-10-05 07:30:00	QQQ	ETF	118.51	118.68	118.5	118.65	22400.0
2016-10-05 08:00:00	QQQ	ETF	118.64	118.72	118.61	118.72	48405.0
2016-10-05 08:30:00	QQQ	ETF	118.71	118.71	118.37	118.62	29544.0
2016-10-05 09:00:00	QQQ	ETF	118.61	118.7	118.54	118.7	19776.0
2016-10-05 09:30:00	QQQ	ETF	118.7	118.9	118.67	118.87	1107714.0
2016-10-05 10:00:00	QQQ	ETF	118.88	119.05	118.77	119.05	1789007.0
2016-10-05 10:30:00	QQQ	ETF	119.05	119.11	118.74	118.86	1284359.0
2016-10-05 11:00:00	QQQ	ETF	118.85	119.01	118.81	118.9872	649943.0
2016-10-05 11:30:00	QQQ	ETF	118.9866	119.08	118.9	119.04	630760.0
2016-10-05 12:00:00	QQQ	ETF	119.04	119.17	119.0225	119.07	617897.0
2016-10-05 12:30:00	QQQ	ETF	119.07	119.1	119.01	119.03	451713.0
2016-10-05 13:00:00	QQQ	ETF	119.02	119.1	118.9001	118.96	569735.0
2016-10-05 13:30:00	QQQ	ETF	118.9595	119.09	118.94	119.07	494950.0
2016-10-05 14:00:00	QQQ	ETF	119.07	119.07	118.983	119.0	343639.0

> showing 50 of 13,654 rows — these rows as CSV

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