PREVIEW / etf_30min / 2015-04-10

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-10.parquet
  size:    375 KB
  rows:    12,682

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
2015-04-10 04:00:00	SPY	ETF	208.98	208.98	208.88	208.88	48303.0
2015-04-10 04:30:00	SPY	ETF	208.93	208.93	208.86	208.9	3350.0
2015-04-10 05:00:00	SPY	ETF	208.86	208.93	208.86	208.92	925.0
2015-04-10 05:30:00	SPY	ETF	208.92	209.06	208.92	209.06	3401.0
2015-04-10 06:00:00	SPY	ETF	209.1	209.18	209.07	209.15	12818.0
2015-04-10 06:30:00	SPY	ETF	209.17	209.44	209.17	209.25	41624.0
2015-04-10 07:00:00	SPY	ETF	209.24	209.53	209.22	209.42	83121.0
2015-04-10 07:30:00	SPY	ETF	209.44	209.48	209.34	209.44	70957.0
2015-04-10 08:00:00	SPY	ETF	209.41	209.49	208.89	209.35	176784.0
2015-04-10 08:30:00	SPY	ETF	209.33	209.34	209.24	209.24	200480.0
2015-04-10 09:00:00	SPY	ETF	209.25	209.34	209.15	209.18	466090.0
2015-04-10 09:30:00	SPY	ETF	209.2	209.36	208.96	209.23	8391088.0
2015-04-10 10:00:00	SPY	ETF	209.22	209.49	209.2	209.437	5016043.0
2015-04-10 10:30:00	SPY	ETF	209.44	209.82	209.44	209.67	6476125.0
2015-04-10 11:00:00	SPY	ETF	209.66	209.9	209.62	209.88	2955330.0
2015-04-10 11:30:00	SPY	ETF	209.88	209.98	209.75	209.75	5659773.0
2015-04-10 12:00:00	SPY	ETF	209.76	209.83	209.72	209.7934	3595476.0
2015-04-10 12:30:00	SPY	ETF	209.795	209.93	209.79	209.84	2659345.0
2015-04-10 13:00:00	SPY	ETF	209.84	209.88	209.66	209.7346	2224862.0
2015-04-10 13:30:00	SPY	ETF	209.74	209.95	209.726	209.893	1787256.0
2015-04-10 14:00:00	SPY	ETF	209.895	210.01	209.74	209.8	3197511.0
2015-04-10 14:30:00	SPY	ETF	209.8	210.09	209.75	209.96	3364279.0
2015-04-10 15:00:00	SPY	ETF	209.96	210.01	209.74	209.896	4506422.0
2015-04-10 15:30:00	SPY	ETF	209.9	210.06	209.82	210.04	10470758.0
2015-04-10 16:00:00	SPY	ETF	210.05	210.09	209.9778	210.03	6151288.0
2015-04-10 16:30:00	SPY	ETF	210.04	210.09	210.04	210.07	1854033.0
2015-04-10 17:00:00	SPY	ETF	210.06	210.1	210.05	210.08	159599.0
2015-04-10 17:30:00	SPY	ETF	210.08	210.13	209.09	210.13	2453876.0
2015-04-10 18:00:00	SPY	ETF	210.11	210.11	210.07	210.07	36664.0
2015-04-10 18:30:00	SPY	ETF	210.08	210.11	210.08	210.11	49075.0
2015-04-10 19:00:00	SPY	ETF	210.1	210.16	210.09	210.14	59380.0
2015-04-10 19:30:00	SPY	ETF	210.14	210.19	210.14	210.15	64779.0
2015-04-10 04:00:00	QQQ	ETF	107.27	107.27	107.27	107.27	220.0
2015-04-10 06:00:00	QQQ	ETF	107.3	107.3	107.3	107.3	200.0
2015-04-10 06:30:00	QQQ	ETF	107.3	107.48	107.29	107.35	9007.0
2015-04-10 07:00:00	QQQ	ETF	107.37	107.45	107.35	107.44	27369.0
2015-04-10 07:30:00	QQQ	ETF	107.39	107.39	107.37	107.38	28850.0
2015-04-10 08:00:00	QQQ	ETF	107.38	107.4	107.35	107.37	37222.0
2015-04-10 08:30:00	QQQ	ETF	107.35	107.38	107.32	107.33	77255.0
2015-04-10 09:00:00	QQQ	ETF	107.33	107.36	107.23	107.28	117735.0
2015-04-10 09:30:00	QQQ	ETF	107.27	107.4	107.03	107.26	2774097.0
2015-04-10 10:00:00	QQQ	ETF	107.27	107.45	107.25	107.36	1718704.0
2015-04-10 10:30:00	QQQ	ETF	107.37	107.531	107.369	107.49	1096763.0
2015-04-10 11:00:00	QQQ	ETF	107.49	107.57	107.45	107.56	668858.0
2015-04-10 11:30:00	QQQ	ETF	107.56	107.61	107.49	107.52	780990.0
2015-04-10 12:00:00	QQQ	ETF	107.53	107.59	107.48	107.5701	530333.0
2015-04-10 12:30:00	QQQ	ETF	107.58	107.65	107.56	107.59	792037.0
2015-04-10 13:00:00	QQQ	ETF	107.6	107.62	107.51	107.544	431479.0
2015-04-10 13:30:00	QQQ	ETF	107.55	107.69	107.5399	107.68	544733.0
2015-04-10 14:00:00	QQQ	ETF	107.671	107.74	107.61	107.63	876254.0

> showing 50 of 12,682 rows — these rows as CSV

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