PREVIEW / etf_30min / 2013-11-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-13.parquet
  size:    330 KB
  rows:    11,052

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-13 04:00:00	SPY	ETF	176.8	176.85	176.65	176.8	5759.0
2013-11-13 04:30:00	SPY	ETF	176.83	176.83	176.66	176.75	6271.0
2013-11-13 05:00:00	SPY	ETF	176.73	176.91	176.73	176.81	19983.0
2013-11-13 05:30:00	SPY	ETF	176.78	176.8	176.72	176.75	5200.0
2013-11-13 06:00:00	SPY	ETF	176.72	176.78	176.66	176.72	16750.0
2013-11-13 06:30:00	SPY	ETF	176.7	176.7	176.5	176.52	160255.0
2013-11-13 07:00:00	SPY	ETF	176.54	176.6	176.5	176.51	81146.0
2013-11-13 07:30:00	SPY	ETF	176.5	176.5	176.3	176.39	325328.0
2013-11-13 08:00:00	SPY	ETF	176.4	176.56	176.04	176.1	828772.0
2013-11-13 08:30:00	SPY	ETF	176.1	176.2	175.96	176.06	647207.0
2013-11-13 09:00:00	SPY	ETF	176.07	176.2	176.03	176.08	633175.0
2013-11-13 09:30:00	SPY	ETF	176.09	176.71	176.09	176.68	10166460.0
2013-11-13 10:00:00	SPY	ETF	176.69	176.845	176.44	176.77	6896796.0
2013-11-13 10:30:00	SPY	ETF	176.78	176.99	176.76	176.87	5324840.0
2013-11-13 11:00:00	SPY	ETF	176.875	176.89	176.7	176.815	5562303.0
2013-11-13 11:30:00	SPY	ETF	176.81	176.92	176.6901	176.9	4296684.0
2013-11-13 12:00:00	SPY	ETF	176.9	177.32	176.79	177.3	5832573.0
2013-11-13 12:30:00	SPY	ETF	177.29	177.51	177.23	177.46	5455497.0
2013-11-13 13:00:00	SPY	ETF	177.46	177.68	177.34	177.67	3764729.0
2013-11-13 13:30:00	SPY	ETF	177.67	177.89	177.63	177.751	5378816.0
2013-11-13 14:00:00	SPY	ETF	177.7503	177.82	177.66	177.767	4231470.0
2013-11-13 14:30:00	SPY	ETF	177.77	177.78	177.55	177.5905	2795566.0
2013-11-13 15:00:00	SPY	ETF	177.591	177.91	177.59	177.81	3613381.0
2013-11-13 15:30:00	SPY	ETF	177.81	178.41	177.76	178.36	19088003.0
2013-11-13 16:00:00	SPY	ETF	178.37	178.46	176.9864	178.36	8594916.0
2013-11-13 16:30:00	SPY	ETF	178.36	178.73	176.9864	178.55	1653333.0
2013-11-13 17:00:00	SPY	ETF	178.55	178.63	178.38	178.38	3308164.0
2013-11-13 17:30:00	SPY	ETF	178.4	178.49	178.3	178.46	215264.0
2013-11-13 18:00:00	SPY	ETF	178.46	178.73	178.45	178.72	187922.0
2013-11-13 18:30:00	SPY	ETF	178.73	178.82	178.71	178.75	186300.0
2013-11-13 19:00:00	SPY	ETF	178.75	178.78	178.71	178.77	184500.0
2013-11-13 19:30:00	SPY	ETF	178.77	178.81	178.75	178.8	227988.0
2013-11-13 04:00:00	QQQ	ETF	82.38	82.41	82.31	82.41	17200.0
2013-11-13 04:30:00	QQQ	ETF	82.39	82.39	82.33	82.37	11400.0
2013-11-13 05:00:00	QQQ	ETF	82.39	82.49	82.39	82.45	11000.0
2013-11-13 05:30:00	QQQ	ETF	82.43	82.43	82.41	82.43	6600.0
2013-11-13 06:00:00	QQQ	ETF	82.41	82.47	82.39	82.45	8000.0
2013-11-13 06:30:00	QQQ	ETF	82.43	82.45	82.35	82.35	12300.0
2013-11-13 07:00:00	QQQ	ETF	82.37	82.4	82.37	82.4	5100.0
2013-11-13 07:30:00	QQQ	ETF	82.37	82.37	82.26	82.29	23498.0
2013-11-13 08:00:00	QQQ	ETF	82.3	82.3	82.13	82.135	113135.0
2013-11-13 08:30:00	QQQ	ETF	82.13	82.13	81.97	82.01	201067.0
2013-11-13 09:00:00	QQQ	ETF	82.0	82.07	81.99	82.0	102342.0
2013-11-13 09:30:00	QQQ	ETF	82.01	82.4299	82.0	82.39	3533091.0
2013-11-13 10:00:00	QQQ	ETF	82.395	82.56	82.29	82.4939	2481478.0
2013-11-13 10:30:00	QQQ	ETF	82.491	82.65	82.49	82.6	1689716.0
2013-11-13 11:00:00	QQQ	ETF	82.59	82.61	82.51	82.56	897701.0
2013-11-13 11:30:00	QQQ	ETF	82.55	82.65	82.51	82.61	1626754.0
2013-11-13 12:00:00	QQQ	ETF	82.6	82.9386	82.55	82.91	2018605.0
2013-11-13 12:30:00	QQQ	ETF	82.91	83.03	82.89	82.99	2211916.0

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

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