PREVIEW / etf_30min / 2015-08-03

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-03.parquet
  size:    384 KB
  rows:    12,847

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
2015-08-03 04:00:00	SPY	ETF	210.6	210.7	209.97	210.1	19601.0
2015-08-03 04:30:00	SPY	ETF	210.12	210.34	210.12	210.34	22200.0
2015-08-03 05:00:00	SPY	ETF	210.42	210.56	210.13	210.13	53051.0
2015-08-03 05:30:00	SPY	ETF	210.15	210.28	210.15	210.22	1350.0
2015-08-03 06:00:00	SPY	ETF	210.2	210.34	210.18	210.27	10916.0
2015-08-03 06:30:00	SPY	ETF	210.29	210.52	210.29	210.44	20039.0
2015-08-03 07:00:00	SPY	ETF	210.41	210.59	210.39	210.48	50361.0
2015-08-03 07:30:00	SPY	ETF	210.47	210.58	210.3	210.35	154278.0
2015-08-03 08:00:00	SPY	ETF	210.35	210.58	210.29	210.48	354725.0
2015-08-03 08:30:00	SPY	ETF	210.49	210.5	210.31	210.32	245037.0
2015-08-03 09:00:00	SPY	ETF	210.31	210.61	210.29	210.47	515654.0
2015-08-03 09:30:00	SPY	ETF	210.46	210.53	209.759	210.2697	10876975.0
2015-08-03 10:00:00	SPY	ETF	210.26	210.38	209.68	209.8401	11355016.0
2015-08-03 10:30:00	SPY	ETF	209.84	210.15	209.58	210.06	6020421.0
2015-08-03 11:00:00	SPY	ETF	210.055	210.37	209.97	210.24	5224922.0
2015-08-03 11:30:00	SPY	ETF	210.25	210.43	210.09	210.15	3833270.0
2015-08-03 12:00:00	SPY	ETF	210.15	210.205	209.82	209.91	3689549.0
2015-08-03 12:30:00	SPY	ETF	209.9	209.9	208.885	209.005	7741984.0
2015-08-03 13:00:00	SPY	ETF	209.005	209.04	208.65	208.93	6856468.0
2015-08-03 13:30:00	SPY	ETF	208.92	209.22	208.845	209.05	4832517.0
2015-08-03 14:00:00	SPY	ETF	209.04	209.7699	208.7	208.8891	6533091.0
2015-08-03 14:30:00	SPY	ETF	208.88	209.18	208.715	208.89	6123855.0
2015-08-03 15:00:00	SPY	ETF	208.9	209.14	208.85	209.11	7972229.0
2015-08-03 15:30:00	SPY	ETF	209.12	209.8	208.99	209.76	18997854.0
2015-08-03 16:00:00	SPY	ETF	209.75	209.82	209.3045	209.74	5803260.0
2015-08-03 16:30:00	SPY	ETF	209.74	209.81	209.67	209.793	817266.0
2015-08-03 17:00:00	SPY	ETF	209.77	209.77	209.68	209.68	58641.0
2015-08-03 17:30:00	SPY	ETF	209.7	209.79	209.62	209.66	430170.0
2015-08-03 18:00:00	SPY	ETF	209.71	209.73	209.59	209.64	37686.0
2015-08-03 18:30:00	SPY	ETF	209.66	209.72	209.58	209.7	10403.0
2015-08-03 19:00:00	SPY	ETF	209.65	209.65	209.5	209.51	16753.0
2015-08-03 19:30:00	SPY	ETF	209.51	209.6	209.36	209.4	51057.0
2015-08-03 04:00:00	QQQ	ETF	112.0	112.0	111.66	111.66	6650.0
2015-08-03 07:30:00	QQQ	ETF	111.98	111.98	111.92	111.92	3000.0
2015-08-03 08:00:00	QQQ	ETF	111.87	112.0	111.6175	112.0	259200.0
2015-08-03 08:30:00	QQQ	ETF	111.93	111.96	111.89	111.89	43211.0
2015-08-03 09:00:00	QQQ	ETF	111.88	112.03	111.87	111.97	87011.0
2015-08-03 09:30:00	QQQ	ETF	111.97	112.28	111.82	112.17	3394541.0
2015-08-03 10:00:00	QQQ	ETF	112.17	112.2	111.64	111.77	1913355.0
2015-08-03 10:30:00	QQQ	ETF	111.765	111.85	111.59	111.8186	1448696.0
2015-08-03 11:00:00	QQQ	ETF	111.81	112.129	111.775	112.05	1496916.0
2015-08-03 11:30:00	QQQ	ETF	112.05	112.15	111.99	112.04	649764.0
2015-08-03 12:00:00	QQQ	ETF	112.06	112.08	111.82	111.88	752836.0
2015-08-03 12:30:00	QQQ	ETF	111.88	111.88	110.97	111.0862	2393748.0
2015-08-03 13:00:00	QQQ	ETF	111.08	111.16	110.861	111.12	1670412.0
2015-08-03 13:30:00	QQQ	ETF	111.11	111.37	111.08	111.249	1540372.0
2015-08-03 14:00:00	QQQ	ETF	111.245	111.25	111.04	111.18	890481.0
2015-08-03 14:30:00	QQQ	ETF	111.181	111.39	111.1	111.215	1226795.0
2015-08-03 15:00:00	QQQ	ETF	111.21	111.3	111.12	111.24	1046640.0
2015-08-03 15:30:00	QQQ	ETF	111.24	111.66	111.1769	111.63	3318147.0

> showing 50 of 12,847 rows — these rows as CSV

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