PREVIEW / etf_30min / 2016-08-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-02.parquet
  size:    409 KB
  rows:    13,767

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
2016-08-02 04:00:00	SPY	ETF	216.64	216.94	216.32	216.32	20215.0
2016-08-02 04:30:00	SPY	ETF	216.27	216.38	216.21	216.31	4982.0
2016-08-02 05:00:00	SPY	ETF	216.27	216.41	216.27	216.37	3114.0
2016-08-02 05:30:00	SPY	ETF	216.47	216.57	216.43	216.43	15636.0
2016-08-02 06:00:00	SPY	ETF	216.39	216.5	216.38	216.42	35265.0
2016-08-02 06:30:00	SPY	ETF	216.41	216.64	216.4	216.49	33803.0
2016-08-02 07:00:00	SPY	ETF	216.52	216.58	216.27	216.3	159910.0
2016-08-02 07:30:00	SPY	ETF	216.37	216.39	216.24	216.39	173531.0
2016-08-02 08:00:00	SPY	ETF	216.27	216.49	216.27	216.48	271608.0
2016-08-02 08:30:00	SPY	ETF	216.48	216.55	216.41	216.42	143815.0
2016-08-02 09:00:00	SPY	ETF	216.42	216.66	216.38	216.65	388051.0
2016-08-02 09:30:00	SPY	ETF	216.65	216.83	216.13	216.29	9020348.0
2016-08-02 10:00:00	SPY	ETF	216.29	216.34	215.45	215.6934	9056866.0
2016-08-02 10:30:00	SPY	ETF	215.695	215.78	214.93	214.971	10075363.0
2016-08-02 11:00:00	SPY	ETF	214.97	215.47	214.97	215.3	5284768.0
2016-08-02 11:30:00	SPY	ETF	215.3	215.36	215.0	215.065	3905817.0
2016-08-02 12:00:00	SPY	ETF	215.06	215.344	214.89	215.205	4810035.0
2016-08-02 12:30:00	SPY	ETF	215.2	215.285	214.76	214.86	3401003.0
2016-08-02 13:00:00	SPY	ETF	214.86	214.9	214.57	214.88	4225477.0
2016-08-02 13:30:00	SPY	ETF	214.885	214.93	214.6201	214.849	3500532.0
2016-08-02 14:00:00	SPY	ETF	214.845	215.37	214.76	215.265	5040655.0
2016-08-02 14:30:00	SPY	ETF	215.27	215.57	215.16	215.33	6162716.0
2016-08-02 15:00:00	SPY	ETF	215.34	215.51	215.22	215.38	4592062.0
2016-08-02 15:30:00	SPY	ETF	215.38	215.72	215.34	215.55	15541371.0
2016-08-02 16:00:00	SPY	ETF	215.57	215.76	215.4635	215.67	3963546.0
2016-08-02 16:30:00	SPY	ETF	215.67	215.78	215.55	215.68	305393.0
2016-08-02 17:00:00	SPY	ETF	215.68	215.69	215.57	215.58	156328.0
2016-08-02 17:30:00	SPY	ETF	215.58	215.62	215.58	215.6	14909.0
2016-08-02 18:00:00	SPY	ETF	215.61	215.66	215.51	215.53	84679.0
2016-08-02 18:30:00	SPY	ETF	215.54	215.56	215.5	215.55	26692.0
2016-08-02 19:00:00	SPY	ETF	215.56	215.58	215.54	215.55	10349.0
2016-08-02 19:30:00	SPY	ETF	215.57	215.61	215.52	215.53	30670.0
2016-08-02 04:00:00	QQQ	ETF	115.6	115.6	115.51	115.51	200.0
2016-08-02 04:30:00	QQQ	ETF	115.47	115.47	115.47	115.47	199.0
2016-08-02 07:00:00	QQQ	ETF	115.55	115.55	115.48	115.48	9853.0
2016-08-02 07:30:00	QQQ	ETF	115.51	115.55	115.46	115.55	117931.0
2016-08-02 08:00:00	QQQ	ETF	115.54	115.58	115.5	115.58	78236.0
2016-08-02 08:30:00	QQQ	ETF	115.58	115.62	115.56	115.57	18578.0
2016-08-02 09:00:00	QQQ	ETF	115.55	115.69	115.55	115.68	108989.0
2016-08-02 09:30:00	QQQ	ETF	115.68	115.77	115.27	115.41	2515446.0
2016-08-02 10:00:00	QQQ	ETF	115.41	115.42	115.0	115.055	2214641.0
2016-08-02 10:30:00	QQQ	ETF	115.05	115.1399	114.52	114.54	2160826.0
2016-08-02 11:00:00	QQQ	ETF	114.54	114.74	114.53	114.67	1329317.0
2016-08-02 11:30:00	QQQ	ETF	114.67	114.78	114.57	114.615	876557.0
2016-08-02 12:00:00	QQQ	ETF	114.61	114.76	114.53	114.69	644445.0
2016-08-02 12:30:00	QQQ	ETF	114.68	114.78	114.46	114.52	731390.0
2016-08-02 13:00:00	QQQ	ETF	114.529	114.55	114.22	114.47	1514710.0
2016-08-02 13:30:00	QQQ	ETF	114.48	114.538	114.34	114.49	856776.0
2016-08-02 14:00:00	QQQ	ETF	114.48	114.8	114.43	114.74	1264443.0
2016-08-02 14:30:00	QQQ	ETF	114.73	115.12	114.67	114.925	1936743.0

> showing 50 of 13,767 rows — these rows as CSV

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