PREVIEW / etf_30min / 2014-08-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-07.parquet
  size:    350 KB
  rows:    11,584

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-08-07 04:00:00	SPY	ETF	192.27	192.64	192.27	192.64	3061.0
2014-08-07 04:30:00	SPY	ETF	192.64	192.65	192.56	192.56	16164.0
2014-08-07 05:00:00	SPY	ETF	192.63	192.63	192.47	192.55	1200.0
2014-08-07 05:30:00	SPY	ETF	192.38	192.56	192.38	192.56	1806.0
2014-08-07 06:00:00	SPY	ETF	192.57	192.57	192.42	192.52	25500.0
2014-08-07 06:30:00	SPY	ETF	192.5	192.5	192.25	192.3	31215.0
2014-08-07 07:00:00	SPY	ETF	192.3	192.52	192.3	192.42	115146.0
2014-08-07 07:30:00	SPY	ETF	192.47	192.49	192.33	192.43	72693.0
2014-08-07 08:00:00	SPY	ETF	192.44	193.04	192.25	192.96	866768.0
2014-08-07 08:30:00	SPY	ETF	192.94	193.03	192.43	192.59	1184082.0
2014-08-07 09:00:00	SPY	ETF	192.6	192.98	192.58	192.93	967391.0
2014-08-07 09:30:00	SPY	ETF	192.935	193.13	192.41	192.71	12958669.0
2014-08-07 10:00:00	SPY	ETF	192.71	192.88	192.46	192.72	6682093.0
2014-08-07 10:30:00	SPY	ETF	192.72	192.925	191.835	192.15	10690011.0
2014-08-07 11:00:00	SPY	ETF	192.15	192.15	191.58	191.86	8608691.0
2014-08-07 11:30:00	SPY	ETF	191.86	192.1285	191.34	191.63	10481812.0
2014-08-07 12:00:00	SPY	ETF	191.62	191.77	191.14	191.39	7974455.0
2014-08-07 12:30:00	SPY	ETF	191.38	191.39	190.88	191.29	7515216.0
2014-08-07 13:00:00	SPY	ETF	191.28	191.79	191.28	191.67	5758835.0
2014-08-07 13:30:00	SPY	ETF	191.67	191.928	191.61	191.82	5293828.0
2014-08-07 14:00:00	SPY	ETF	191.82	191.83	191.33	191.42	5046068.0
2014-08-07 14:30:00	SPY	ETF	191.41	191.45	191.04	191.06	5108910.0
2014-08-07 15:00:00	SPY	ETF	191.06	191.27	190.55	190.79	14573402.0
2014-08-07 15:30:00	SPY	ETF	190.79	191.28	190.62	191.01	19269745.0
2014-08-07 16:00:00	SPY	ETF	191.02	192.1286	190.94	191.09	7146317.0
2014-08-07 16:30:00	SPY	ETF	191.08	192.01	190.98	191.01	1777113.0
2014-08-07 17:00:00	SPY	ETF	191.01	191.12	191.01	191.09	38999.0
2014-08-07 17:30:00	SPY	ETF	191.07	191.12	191.07	191.08	11986.0
2014-08-07 18:00:00	SPY	ETF	191.07	191.14	191.04	191.14	42301.0
2014-08-07 18:30:00	SPY	ETF	191.14	191.17	191.12	191.15	20868.0
2014-08-07 19:00:00	SPY	ETF	191.13	191.19	191.1	191.11	35456.0
2014-08-07 19:30:00	SPY	ETF	191.14	191.21	191.1	191.21	118845.0
2014-08-07 04:00:00	QQQ	ETF	94.71	94.71	94.71	94.71	300.0
2014-08-07 04:30:00	QQQ	ETF	94.76	94.76	94.75	94.75	200.0
2014-08-07 05:30:00	QQQ	ETF	94.71	94.71	94.7	94.7	200.0
2014-08-07 06:00:00	QQQ	ETF	94.69	94.74	94.65	94.68	2700.0
2014-08-07 06:30:00	QQQ	ETF	94.68	94.68	94.6	94.61	3500.0
2014-08-07 07:00:00	QQQ	ETF	94.69	94.71	94.64	94.64	17500.0
2014-08-07 07:30:00	QQQ	ETF	94.67	94.68	94.62	94.63	12228.0
2014-08-07 08:00:00	QQQ	ETF	94.67	94.98	94.67	94.93	173700.0
2014-08-07 08:30:00	QQQ	ETF	94.91	94.96	94.72	94.76	169367.0
2014-08-07 09:00:00	QQQ	ETF	94.78	94.96	94.78	94.94	183536.0
2014-08-07 09:30:00	QQQ	ETF	94.95	95.05	94.787	95.0	3471891.0
2014-08-07 10:00:00	QQQ	ETF	95.0	95.1	94.81	95.04	2190110.0
2014-08-07 10:30:00	QQQ	ETF	95.039	95.139	94.565	94.76	3352412.0
2014-08-07 11:00:00	QQQ	ETF	94.75	94.7751	94.52	94.685	2193684.0
2014-08-07 11:30:00	QQQ	ETF	94.68	94.84	94.401	94.53	2012185.0
2014-08-07 12:00:00	QQQ	ETF	94.52	94.63	94.38	94.46	1666058.0
2014-08-07 12:30:00	QQQ	ETF	94.46	94.46	94.25	94.39	1699148.0
2014-08-07 13:00:00	QQQ	ETF	94.38	94.61	94.38	94.55	1288332.0

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

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