PREVIEW / etf_30min / 2017-04-12

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-12.parquet
  size:    424 KB
  rows:    14,444

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
2017-04-12 04:00:00	SPY	ETF	235.4	235.48	235.24	235.38	5540.0
2017-04-12 04:30:00	SPY	ETF	235.43	235.43	235.3	235.3	1105.0
2017-04-12 05:00:00	SPY	ETF	235.21	235.32	235.21	235.26	3490.0
2017-04-12 05:30:00	SPY	ETF	235.36	235.38	235.14	235.14	5350.0
2017-04-12 06:00:00	SPY	ETF	235.17	235.17	234.98	235.02	4948.0
2017-04-12 06:30:00	SPY	ETF	234.98	234.98	234.89	234.89	1510.0
2017-04-12 07:00:00	SPY	ETF	234.97	235.03	234.73	234.73	135304.0
2017-04-12 07:30:00	SPY	ETF	234.78	234.85	234.7	234.78	91584.0
2017-04-12 08:00:00	SPY	ETF	234.82	235.03	234.62	234.76	160344.0
2017-04-12 08:30:00	SPY	ETF	234.76	235.06	234.61	234.69	116144.0
2017-04-12 09:00:00	SPY	ETF	234.69	234.77	234.61	234.74	181972.0
2017-04-12 09:30:00	SPY	ETF	234.74	234.87	234.38	234.6553	6446347.0
2017-04-12 10:00:00	SPY	ETF	234.65	234.96	234.42	234.59	5026291.0
2017-04-12 10:30:00	SPY	ETF	234.59	234.8	234.18	234.265	4203517.0
2017-04-12 11:00:00	SPY	ETF	234.27	234.44	234.16	234.29	2651634.0
2017-04-12 11:30:00	SPY	ETF	234.29	234.33	233.77	234.01	3404464.0
2017-04-12 12:00:00	SPY	ETF	234.0139	234.24	233.93	234.025	2296129.0
2017-04-12 12:30:00	SPY	ETF	234.03	234.18	233.82	233.9398	1960002.0
2017-04-12 13:00:00	SPY	ETF	233.93	234.3	233.93	234.09	2730998.0
2017-04-12 13:30:00	SPY	ETF	234.08	234.65	233.98	234.62	4895882.0
2017-04-12 14:00:00	SPY	ETF	234.6092	234.66	234.32	234.41	2943566.0
2017-04-12 14:30:00	SPY	ETF	234.4	234.5	233.92	234.21	7111020.0
2017-04-12 15:00:00	SPY	ETF	234.205	234.36	233.86	234.17	6436863.0
2017-04-12 15:30:00	SPY	ETF	234.18	234.34	233.88	234.1	14415903.0
2017-04-12 16:00:00	SPY	ETF	234.1	235.0235	233.97	234.02	10831164.0
2017-04-12 16:30:00	SPY	ETF	234.02	234.1398	233.92	233.92	2134574.0
2017-04-12 17:00:00	SPY	ETF	233.95	234.03	233.94	233.97	1611924.0
2017-04-12 17:30:00	SPY	ETF	233.96	234.03	233.9	233.92	358187.0
2017-04-12 18:00:00	SPY	ETF	233.89	234.09	233.89	234.08	90575.0
2017-04-12 18:30:00	SPY	ETF	234.07	234.14	234.04	234.08	29499.0
2017-04-12 19:00:00	SPY	ETF	234.08	234.1	234.02	234.1	17845.0
2017-04-12 19:30:00	SPY	ETF	234.06	234.07	234.0	234.0	9122.0
2017-04-12 04:00:00	QQQ	ETF	131.63	131.75	131.63	131.75	6848.0
2017-04-12 04:30:00	QQQ	ETF	131.7	131.7	131.67	131.67	350.0
2017-04-12 06:00:00	QQQ	ETF	131.55	131.55	131.51	131.51	600.0
2017-04-12 07:00:00	QQQ	ETF	131.45	131.46	131.39	131.39	950.0
2017-04-12 07:30:00	QQQ	ETF	131.39	131.43	131.36	131.39	1200.0
2017-04-12 08:00:00	QQQ	ETF	131.36	131.4	131.29	131.4	47260.0
2017-04-12 08:30:00	QQQ	ETF	131.4	131.45	131.35	131.35	33329.0
2017-04-12 09:00:00	QQQ	ETF	131.37	131.45	131.37	131.43	25328.0
2017-04-12 09:30:00	QQQ	ETF	131.44	131.54	131.21	131.394	2053595.0
2017-04-12 10:00:00	QQQ	ETF	131.395	131.5	131.17	131.26	991041.0
2017-04-12 10:30:00	QQQ	ETF	131.26	131.37	131.055	131.1	1067615.0
2017-04-12 11:00:00	QQQ	ETF	131.11	131.25	131.0199	131.15	995352.0
2017-04-12 11:30:00	QQQ	ETF	131.14	131.14	130.78	130.939	778341.0
2017-04-12 12:00:00	QQQ	ETF	130.94	131.05	130.875	130.94	564978.0
2017-04-12 12:30:00	QQQ	ETF	130.9266	131.01	130.78	130.851	484615.0
2017-04-12 13:00:00	QQQ	ETF	130.86	131.05	130.8551	130.91	607117.0
2017-04-12 13:30:00	QQQ	ETF	130.91	131.28	130.83	131.26	1183468.0
2017-04-12 14:00:00	QQQ	ETF	131.27	131.29	131.089	131.15	742897.0

> showing 50 of 14,444 rows — these rows as CSV

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