PREVIEW / etf_30min / 2014-08-05

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-05.parquet
  size:    352 KB
  rows:    11,807

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-05 04:00:00	SPY	ETF	193.65	193.8	193.59	193.8	1952.0
2014-08-05 04:30:00	SPY	ETF	193.69	193.76	193.69	193.76	405.0
2014-08-05 05:00:00	SPY	ETF	193.77	193.81	193.71	193.81	2072.0
2014-08-05 05:30:00	SPY	ETF	193.67	193.67	193.57	193.57	1621.0
2014-08-05 06:00:00	SPY	ETF	193.51	193.51	193.4	193.48	32810.0
2014-08-05 06:30:00	SPY	ETF	193.52	193.52	193.34	193.44	12820.0
2014-08-05 07:00:00	SPY	ETF	193.42	193.43	193.19	193.25	174310.0
2014-08-05 07:30:00	SPY	ETF	193.25	193.27	193.12	193.15	160477.0
2014-08-05 08:00:00	SPY	ETF	193.15	193.55	192.91	192.95	521786.0
2014-08-05 08:30:00	SPY	ETF	192.94	193.11	192.76	193.08	850342.0
2014-08-05 09:00:00	SPY	ETF	193.06	193.88	192.94	193.1	593957.0
2014-08-05 09:30:00	SPY	ETF	193.1	193.41	192.62	192.88	13111044.0
2014-08-05 10:00:00	SPY	ETF	192.89	193.295	192.56	193.27	10736264.0
2014-08-05 10:30:00	SPY	ETF	193.27	193.55	193.06	193.16	6783080.0
2014-08-05 11:00:00	SPY	ETF	193.17	193.6	192.92	193.295	6355021.0
2014-08-05 11:30:00	SPY	ETF	193.3	193.39	192.9	192.98	3253132.0
2014-08-05 12:00:00	SPY	ETF	192.97	193.11	192.67	192.8372	4343197.0
2014-08-05 12:30:00	SPY	ETF	192.83	192.89	192.57	192.87	6280249.0
2014-08-05 13:00:00	SPY	ETF	192.87	193.1	192.71	193.025	3710830.0
2014-08-05 13:30:00	SPY	ETF	193.02	193.06	191.59	191.85	24327668.0
2014-08-05 14:00:00	SPY	ETF	191.85	191.95	191.31	191.91	15821316.0
2014-08-05 14:30:00	SPY	ETF	191.92	192.17	191.75	191.75	8892288.0
2014-08-05 15:00:00	SPY	ETF	191.75	191.92	191.4	191.69	10718420.0
2014-08-05 15:30:00	SPY	ETF	191.69	192.3	191.69	191.98	19772605.0
2014-08-05 16:00:00	SPY	ETF	191.97	192.08	191.719	191.85	10316712.0
2014-08-05 16:30:00	SPY	ETF	191.86	193.8959	191.86	191.97	3274509.0
2014-08-05 17:00:00	SPY	ETF	191.97	192.04	191.95	192.0	138049.0
2014-08-05 17:30:00	SPY	ETF	192.0	192.03	191.93	192.01	42632.0
2014-08-05 18:00:00	SPY	ETF	192.01	192.15	192.01	192.13	78684.0
2014-08-05 18:30:00	SPY	ETF	192.15	192.17	192.1	192.11	24347.0
2014-08-05 19:00:00	SPY	ETF	192.15	192.15	192.05	192.05	6267.0
2014-08-05 19:30:00	SPY	ETF	192.03	192.09	192.01	192.09	38376.0
2014-08-05 05:00:00	QQQ	ETF	95.26	95.26	95.26	95.26	5000.0
2014-08-05 05:30:00	QQQ	ETF	95.14	95.21	95.14	95.21	2700.0
2014-08-05 06:00:00	QQQ	ETF	95.24	95.24	95.08	95.08	5500.0
2014-08-05 06:30:00	QQQ	ETF	95.07	95.12	95.06	95.12	3200.0
2014-08-05 07:00:00	QQQ	ETF	95.1	95.1	95.0	95.04	12875.0
2014-08-05 07:30:00	QQQ	ETF	95.02	95.05	94.98	95.0	22608.0
2014-08-05 08:00:00	QQQ	ETF	94.98	94.99	94.87	94.89	123995.0
2014-08-05 08:30:00	QQQ	ETF	94.89	94.95	94.83	94.93	93981.0
2014-08-05 09:00:00	QQQ	ETF	94.93	94.96	94.86	94.93	145782.0
2014-08-05 09:30:00	QQQ	ETF	94.94	95.16	94.56	94.68	4848380.0
2014-08-05 10:00:00	QQQ	ETF	94.69	94.98	94.55	94.98	3969955.0
2014-08-05 10:30:00	QQQ	ETF	94.97	95.16	94.91	94.97	2227026.0
2014-08-05 11:00:00	QQQ	ETF	94.97	95.21	94.83	95.08	2263953.0
2014-08-05 11:30:00	QQQ	ETF	95.09	95.14	94.79	94.86	1329711.0
2014-08-05 12:00:00	QQQ	ETF	94.86	94.92	94.6989	94.7972	1304602.0
2014-08-05 12:30:00	QQQ	ETF	94.79	94.83	94.64	94.83	1567281.0
2014-08-05 13:00:00	QQQ	ETF	94.84	94.999	94.71	94.965	1221104.0
2014-08-05 13:30:00	QQQ	ETF	94.97	94.99	94.3	94.42	6388227.0

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

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