PREVIEW / etf_30min / 2013-11-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-18.parquet
  size:    336 KB
  rows:    11,481

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
2013-11-18 04:00:00	SPY	ETF	179.75	179.75	179.59	179.75	47113.0
2013-11-18 04:30:00	SPY	ETF	179.78	179.86	179.78	179.83	3500.0
2013-11-18 05:00:00	SPY	ETF	179.84	180.01	179.84	179.97	6796.0
2013-11-18 05:30:00	SPY	ETF	180.04	180.07	180.01	180.02	13159.0
2013-11-18 06:00:00	SPY	ETF	180.03	180.12	180.01	180.06	24031.0
2013-11-18 06:30:00	SPY	ETF	180.08	180.22	180.08	180.22	41064.0
2013-11-18 07:00:00	SPY	ETF	180.23	180.3	180.17	180.26	180527.0
2013-11-18 07:30:00	SPY	ETF	180.24	180.24	180.11	180.13	255020.0
2013-11-18 08:00:00	SPY	ETF	180.14	180.24	179.7	180.16	808862.0
2013-11-18 08:30:00	SPY	ETF	180.17	180.23	180.11	180.22	426688.0
2013-11-18 09:00:00	SPY	ETF	180.24	180.42	180.21	180.35	863394.0
2013-11-18 09:30:00	SPY	ETF	180.35	180.5	179.91	179.92	11100156.0
2013-11-18 10:00:00	SPY	ETF	179.91	180.23	179.79	180.12	6494215.0
2013-11-18 10:30:00	SPY	ETF	180.12	180.27	180.02	180.26	3886698.0
2013-11-18 11:00:00	SPY	ETF	180.2599	180.41	180.25	180.33	4768713.0
2013-11-18 11:30:00	SPY	ETF	180.321	180.39	180.07	180.12	3983122.0
2013-11-18 12:00:00	SPY	ETF	180.12	180.26	180.1	180.2	3368705.0
2013-11-18 12:30:00	SPY	ETF	180.19	180.27	180.03	180.07	3925301.0
2013-11-18 13:00:00	SPY	ETF	180.07	180.25	180.03	180.25	2462135.0
2013-11-18 13:30:00	SPY	ETF	180.24	180.25	180.12	180.2	3568326.0
2013-11-18 14:00:00	SPY	ETF	180.19	180.34	180.17	180.34	3248241.0
2013-11-18 14:30:00	SPY	ETF	180.335	180.34	179.8	179.801	5017717.0
2013-11-18 15:00:00	SPY	ETF	179.8099	179.81	179.0801	179.2699	15766835.0
2013-11-18 15:30:00	SPY	ETF	179.26	179.47	179.02	179.47	16040142.0
2013-11-18 16:00:00	SPY	ETF	179.46	180.1458	179.36	179.38	7014366.0
2013-11-18 16:30:00	SPY	ETF	180.0706	180.39	179.37	179.5	916803.0
2013-11-18 17:00:00	SPY	ETF	179.5	179.51	179.42	179.5	5849656.0
2013-11-18 17:30:00	SPY	ETF	179.48	179.49	179.43	179.43	6965.0
2013-11-18 18:00:00	SPY	ETF	179.45	179.48	179.31	179.38	40755.0
2013-11-18 18:30:00	SPY	ETF	179.37	179.45	179.37	179.42	6220.0
2013-11-18 19:00:00	SPY	ETF	179.41	179.57	179.4	179.54	84050.0
2013-11-18 19:30:00	SPY	ETF	179.54	179.56	179.45	179.49	58184.0
2013-11-18 04:00:00	QQQ	ETF	83.93	83.93	83.77	83.85	29600.0
2013-11-18 04:30:00	QQQ	ETF	83.87	83.89	83.87	83.89	9500.0
2013-11-18 05:00:00	QQQ	ETF	83.91	83.97	83.91	83.95	4179.0
2013-11-18 05:30:00	QQQ	ETF	83.97	83.97	83.97	83.97	1000.0
2013-11-18 06:00:00	QQQ	ETF	83.95	83.97	83.91	83.93	6547.0
2013-11-18 06:30:00	QQQ	ETF	83.97	83.97	83.95	83.95	2000.0
2013-11-18 07:00:00	QQQ	ETF	83.97	83.99	83.93	83.97	20400.0
2013-11-18 07:30:00	QQQ	ETF	83.95	83.95	83.94	83.94	1200.0
2013-11-18 08:00:00	QQQ	ETF	83.95	83.95	83.87	83.89	15195.0
2013-11-18 08:30:00	QQQ	ETF	83.9	83.96	83.87	83.91	143950.0
2013-11-18 09:00:00	QQQ	ETF	83.93	84.01	83.91	83.94	201862.0
2013-11-18 09:30:00	QQQ	ETF	83.94	84.105	83.77	83.77	4802943.0
2013-11-18 10:00:00	QQQ	ETF	83.771	83.85	83.59	83.79	4583721.0
2013-11-18 10:30:00	QQQ	ETF	83.8	83.94	83.73	83.91	1556810.0
2013-11-18 11:00:00	QQQ	ETF	83.91	83.97	83.86	83.87	1180666.0
2013-11-18 11:30:00	QQQ	ETF	83.87	83.9061	83.73	83.76	943210.0
2013-11-18 12:00:00	QQQ	ETF	83.76	83.85	83.73	83.84	822395.0
2013-11-18 12:30:00	QQQ	ETF	83.8499	83.89	83.7399	83.75	1004299.0

> showing 50 of 11,481 rows — these rows as CSV

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