PREVIEW / etf_30min / 2015-09-04

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-04.parquet
  size:    386 KB
  rows:    12,950

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-09-04 04:00:00	SPY	ETF	194.68	194.68	193.64	193.85	24493.0
2015-09-04 04:30:00	SPY	ETF	193.85	193.95	193.36	193.66	61085.0
2015-09-04 05:00:00	SPY	ETF	193.62	194.01	193.58	193.86	19228.0
2015-09-04 05:30:00	SPY	ETF	193.9	194.03	193.42	193.52	76874.0
2015-09-04 06:00:00	SPY	ETF	193.53	193.81	192.98	193.24	100873.0
2015-09-04 06:30:00	SPY	ETF	193.22	193.49	193.01	193.44	79770.0
2015-09-04 07:00:00	SPY	ETF	193.4	193.57	193.32	193.52	339354.0
2015-09-04 07:30:00	SPY	ETF	193.52	193.64	193.26	193.5	369720.0
2015-09-04 08:00:00	SPY	ETF	193.5	194.49	193.34	193.6	1162381.0
2015-09-04 08:30:00	SPY	ETF	193.79	194.35	191.88	192.53	6536018.0
2015-09-04 09:00:00	SPY	ETF	192.53	193.21	191.89	192.86	2942447.0
2015-09-04 09:30:00	SPY	ETF	192.85	193.8	192.44	192.88	27321398.0
2015-09-04 10:00:00	SPY	ETF	192.88	193.59	192.63	193.53	12975495.0
2015-09-04 10:30:00	SPY	ETF	193.51	193.86	192.85	193.055	12090456.0
2015-09-04 11:00:00	SPY	ETF	193.05	193.34	192.76	193.1	8222168.0
2015-09-04 11:30:00	SPY	ETF	193.1	193.25	192.65	192.92	7977176.0
2015-09-04 12:00:00	SPY	ETF	192.93	193.0	192.33	192.4392	9569369.0
2015-09-04 12:30:00	SPY	ETF	192.43	192.7	192.22	192.32	5472992.0
2015-09-04 13:00:00	SPY	ETF	192.32	192.41	191.85	192.12	10450059.0
2015-09-04 13:30:00	SPY	ETF	192.12	192.46	192.01	192.13	8072487.0
2015-09-04 14:00:00	SPY	ETF	192.125	192.21	191.61	191.85	12668842.0
2015-09-04 14:30:00	SPY	ETF	191.83	192.44	191.61	192.435	11704227.0
2015-09-04 15:00:00	SPY	ETF	192.435	192.7	192.1601	192.62	9653005.0
2015-09-04 15:30:00	SPY	ETF	192.63	193.72	192.44	192.56	25682805.0
2015-09-04 16:00:00	SPY	ETF	192.6	193.03	192.54	192.88	13979718.0
2015-09-04 16:30:00	SPY	ETF	192.88	192.97	192.59	192.85	13292164.0
2015-09-04 17:00:00	SPY	ETF	192.82	192.83	192.61	192.64	1524305.0
2015-09-04 17:30:00	SPY	ETF	192.66	192.66	192.36	192.38	2865412.0
2015-09-04 18:00:00	SPY	ETF	192.38	192.44	192.23	192.25	51754.0
2015-09-04 18:30:00	SPY	ETF	192.25	192.37	192.25	192.35	10947.0
2015-09-04 19:00:00	SPY	ETF	192.35	192.37	192.3	192.33	11710.0
2015-09-04 19:30:00	SPY	ETF	192.33	192.33	192.2	192.2	26775.0
2015-09-04 04:00:00	QQQ	ETF	102.8	102.8	102.29	102.41	28691.0
2015-09-04 04:30:00	QQQ	ETF	102.38	102.38	102.19	102.27	6885.0
2015-09-04 05:00:00	QQQ	ETF	102.33	102.47	102.33	102.47	16750.0
2015-09-04 05:30:00	QQQ	ETF	102.5	102.5	102.35	102.35	1800.0
2015-09-04 06:00:00	QQQ	ETF	102.41	102.43	102.1	102.26	56510.0
2015-09-04 06:30:00	QQQ	ETF	102.19	102.34	102.17	102.34	50968.0
2015-09-04 07:00:00	QQQ	ETF	102.32	102.38	102.26	102.32	29725.0
2015-09-04 07:30:00	QQQ	ETF	102.32	102.41	102.23	102.33	53446.0
2015-09-04 08:00:00	QQQ	ETF	102.33	102.7	102.27	102.48	115346.0
2015-09-04 08:30:00	QQQ	ETF	102.45	102.79	101.54	101.91	1162120.0
2015-09-04 09:00:00	QQQ	ETF	101.88	102.17	101.54	101.96	686325.0
2015-09-04 09:30:00	QQQ	ETF	101.97	102.69	101.92	102.19	7689021.0
2015-09-04 10:00:00	QQQ	ETF	102.18	102.69	102.01	102.64	4161813.0
2015-09-04 10:30:00	QQQ	ETF	102.62	102.845	102.2189	102.32	2965448.0
2015-09-04 11:00:00	QQQ	ETF	102.34	102.5	102.1	102.39	1596142.0
2015-09-04 11:30:00	QQQ	ETF	102.39	102.56	102.09	102.3801	1598708.0
2015-09-04 12:00:00	QQQ	ETF	102.39	102.42	102.0	102.08	2007988.0
2015-09-04 12:30:00	QQQ	ETF	102.08	102.2	101.89	101.945	1021561.0

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

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