PREVIEW / etf_30min / 2014-06-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-17.parquet
  size:    328 KB
  rows:    11,334

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
2014-06-17 04:00:00	SPY	ETF	194.75	194.85	194.75	194.85	400.0
2014-06-17 05:00:00	SPY	ETF	194.66	194.8	194.66	194.8	3053.0
2014-06-17 05:30:00	SPY	ETF	194.72	194.79	194.6	194.6	13727.0
2014-06-17 06:00:00	SPY	ETF	194.56	194.6	194.36	194.36	46645.0
2014-06-17 06:30:00	SPY	ETF	194.36	194.39	194.32	194.33	30536.0
2014-06-17 07:00:00	SPY	ETF	194.32	194.63	194.32	194.63	144442.0
2014-06-17 07:30:00	SPY	ETF	194.6	194.63	194.52	194.53	56222.0
2014-06-17 08:00:00	SPY	ETF	194.52	194.65	194.49	194.51	143446.0
2014-06-17 08:30:00	SPY	ETF	194.51	194.51	193.76	193.94	1235960.0
2014-06-17 09:00:00	SPY	ETF	193.91	194.1	193.87	194.01	626798.0
2014-06-17 09:30:00	SPY	ETF	194.02	194.47	193.81	194.36	9153068.0
2014-06-17 10:00:00	SPY	ETF	194.37	194.74	194.36	194.617	5960355.0
2014-06-17 10:30:00	SPY	ETF	194.62	194.63	194.0489	194.24	7306449.0
2014-06-17 11:00:00	SPY	ETF	194.24	194.33	194.03	194.3	3592352.0
2014-06-17 11:30:00	SPY	ETF	194.3	194.58	194.3	194.57	2896522.0
2014-06-17 12:00:00	SPY	ETF	194.56	194.65	194.49	194.56	2592579.0
2014-06-17 12:30:00	SPY	ETF	194.5596	194.84	194.5596	194.76	2857658.0
2014-06-17 13:00:00	SPY	ETF	194.77	194.81	194.58	194.59	4252599.0
2014-06-17 13:30:00	SPY	ETF	194.59	194.91	194.59	194.85	3424241.0
2014-06-17 14:00:00	SPY	ETF	194.855	194.97	194.66	194.9047	5154886.0
2014-06-17 14:30:00	SPY	ETF	194.91	194.93	194.77	194.9	3229818.0
2014-06-17 15:00:00	SPY	ETF	194.9	194.92	194.68	194.76	4400110.0
2014-06-17 15:30:00	SPY	ETF	194.765	194.95	194.69	194.82	14740160.0
2014-06-17 16:00:00	SPY	ETF	194.81	194.83	194.73	194.77	6116079.0
2014-06-17 16:30:00	SPY	ETF	194.76	194.83	194.3437	194.83	1143655.0
2014-06-17 17:00:00	SPY	ETF	194.82	194.83	194.74	194.77	33319.0
2014-06-17 17:30:00	SPY	ETF	194.77	194.77	194.75	194.76	1558.0
2014-06-17 18:00:00	SPY	ETF	194.77	194.82	194.76	194.79	23116.0
2014-06-17 18:30:00	SPY	ETF	194.81	194.81	194.79	194.79	3100.0
2014-06-17 19:00:00	SPY	ETF	194.82	194.82	194.77	194.81	5020.0
2014-06-17 19:30:00	SPY	ETF	194.78	194.79	194.74	194.75	25703.0
2014-06-17 04:00:00	QQQ	ETF	92.65	92.65	92.65	92.65	100.0
2014-06-17 04:30:00	QQQ	ETF	92.7	92.7	92.7	92.7	300.0
2014-06-17 05:00:00	QQQ	ETF	92.56	92.56	92.56	92.56	2000.0
2014-06-17 06:00:00	QQQ	ETF	92.5	92.54	92.5	92.54	7611.0
2014-06-17 06:30:00	QQQ	ETF	92.53	92.53	92.53	92.53	1500.0
2014-06-17 07:00:00	QQQ	ETF	92.58	92.6	92.57	92.59	8700.0
2014-06-17 07:30:00	QQQ	ETF	92.66	92.66	92.57	92.57	53700.0
2014-06-17 08:00:00	QQQ	ETF	92.57	92.59	92.55	92.56	11485.0
2014-06-17 08:30:00	QQQ	ETF	92.54	92.54	92.22	92.32	217844.0
2014-06-17 09:00:00	QQQ	ETF	92.31	92.39	92.27	92.34	236792.0
2014-06-17 09:30:00	QQQ	ETF	92.34	92.58	92.18	92.545	3434114.0
2014-06-17 10:00:00	QQQ	ETF	92.55	92.7	92.509	92.65	2330886.0
2014-06-17 10:30:00	QQQ	ETF	92.65	92.66	92.33	92.42	1623108.0
2014-06-17 11:00:00	QQQ	ETF	92.41	92.46	92.21	92.31	1456008.0
2014-06-17 11:30:00	QQQ	ETF	92.31	92.52	92.31	92.5	806961.0
2014-06-17 12:00:00	QQQ	ETF	92.5	92.56	92.46	92.48	377461.0
2014-06-17 12:30:00	QQQ	ETF	92.481	92.62	92.481	92.57	697087.0
2014-06-17 13:00:00	QQQ	ETF	92.57	92.59	92.47	92.47	691529.0
2014-06-17 13:30:00	QQQ	ETF	92.48	92.67	92.47	92.61	841283.0

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

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