PREVIEW / etf_30min / 2015-07-14

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-14.parquet
  size:    379 KB
  rows:    12,791

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-07-14 04:00:00	SPY	ETF	209.76	209.76	209.76	209.76	1200.0
2015-07-14 04:30:00	SPY	ETF	209.73	209.82	209.73	209.82	27035.0
2015-07-14 05:00:00	SPY	ETF	209.8	209.8	209.77	209.8	21400.0
2015-07-14 05:30:00	SPY	ETF	209.81	209.81	209.77	209.79	7300.0
2015-07-14 06:00:00	SPY	ETF	209.83	209.85	209.79	209.81	16210.0
2015-07-14 06:30:00	SPY	ETF	209.76	209.88	209.75	209.87	40701.0
2015-07-14 07:00:00	SPY	ETF	209.88	209.97	209.85	209.88	92433.0
2015-07-14 07:30:00	SPY	ETF	209.92	209.94	209.85	209.85	55718.0
2015-07-14 08:00:00	SPY	ETF	209.63	210.03	209.63	209.98	234585.0
2015-07-14 08:30:00	SPY	ETF	209.9	209.9	209.56	209.6	973709.0
2015-07-14 09:00:00	SPY	ETF	209.57	209.74	209.54	209.71	433286.0
2015-07-14 09:30:00	SPY	ETF	209.72	210.26	209.65	210.16	9992490.0
2015-07-14 10:00:00	SPY	ETF	210.17	210.35	210.05	210.3201	6441002.0
2015-07-14 10:30:00	SPY	ETF	210.323	210.45	210.29	210.38	5356475.0
2015-07-14 11:00:00	SPY	ETF	210.38	210.66	210.38	210.5965	4297231.0
2015-07-14 11:30:00	SPY	ETF	210.6	210.74	210.55	210.68	4975151.0
2015-07-14 12:00:00	SPY	ETF	210.67	210.76	210.54	210.56	3209545.0
2015-07-14 12:30:00	SPY	ETF	210.56	210.62	210.36	210.49	4293139.0
2015-07-14 13:00:00	SPY	ETF	210.49	210.64	210.42	210.58	1831947.0
2015-07-14 13:30:00	SPY	ETF	210.5745	210.65	210.47	210.635	3282316.0
2015-07-14 14:00:00	SPY	ETF	210.6337	210.77	210.575	210.765	4099260.0
2015-07-14 14:30:00	SPY	ETF	210.77	210.93	210.74	210.89	5244348.0
2015-07-14 15:00:00	SPY	ETF	210.88	211.05	210.88	210.96	6426181.0
2015-07-14 15:30:00	SPY	ETF	210.96	211.0	210.66	210.68	13272506.0
2015-07-14 16:00:00	SPY	ETF	210.68	210.87	209.9467	210.74	5512585.0
2015-07-14 16:30:00	SPY	ETF	210.74	210.8425	210.68	210.79	622818.0
2015-07-14 17:00:00	SPY	ETF	210.79	210.85	210.77	210.77	74603.0
2015-07-14 17:30:00	SPY	ETF	210.81	210.82	210.77	210.78	10297.0
2015-07-14 18:00:00	SPY	ETF	210.78	210.78	210.58	210.6	217425.0
2015-07-14 18:30:00	SPY	ETF	210.6	210.64	210.56	210.58	31602.0
2015-07-14 19:00:00	SPY	ETF	210.57	210.58	210.54	210.55	48428.0
2015-07-14 19:30:00	SPY	ETF	210.57	210.58	210.47	210.52	115072.0
2015-07-14 04:30:00	QQQ	ETF	109.64	109.64	109.64	109.64	25000.0
2015-07-14 05:00:00	QQQ	ETF	109.69	109.69	109.51	109.54	5000.0
2015-07-14 05:30:00	QQQ	ETF	109.68	109.69	109.56	109.56	10500.0
2015-07-14 06:00:00	QQQ	ETF	109.65	109.7	109.57	109.58	30090.0
2015-07-14 06:30:00	QQQ	ETF	109.56	109.58	109.56	109.57	750.0
2015-07-14 07:00:00	QQQ	ETF	109.61	109.63	109.6	109.6	6350.0
2015-07-14 07:30:00	QQQ	ETF	109.64	109.65	109.6	109.62	11290.0
2015-07-14 08:00:00	QQQ	ETF	109.63	109.71	109.61	109.71	19302.0
2015-07-14 08:30:00	QQQ	ETF	109.65	109.72	109.59	109.59	55675.0
2015-07-14 09:00:00	QQQ	ETF	109.6	109.69	109.6	109.68	36758.0
2015-07-14 09:30:00	QQQ	ETF	109.69	109.941	109.63	109.91	2689937.0
2015-07-14 10:00:00	QQQ	ETF	109.91	110.08	109.84	110.05	1619407.0
2015-07-14 10:30:00	QQQ	ETF	110.048	110.12	109.97	110.09	1615225.0
2015-07-14 11:00:00	QQQ	ETF	110.09	110.28	110.08	110.26	1735788.0
2015-07-14 11:30:00	QQQ	ETF	110.27	110.42	110.26	110.36	1560895.0
2015-07-14 12:00:00	QQQ	ETF	110.37	110.42	110.25	110.27	1187771.0
2015-07-14 12:30:00	QQQ	ETF	110.28	110.32	110.19	110.26	791087.0
2015-07-14 13:00:00	QQQ	ETF	110.26	110.37	110.2	110.37	569389.0

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

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