PREVIEW / etf_30min / 2017-04-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-21.parquet
  size:    419 KB
  rows:    14,401

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-21 04:00:00	SPY	ETF	235.45	235.54	235.45	235.54	354.0
2017-04-21 04:30:00	SPY	ETF	235.44	235.46	235.36	235.45	1201.0
2017-04-21 05:00:00	SPY	ETF	235.35	235.35	235.32	235.32	303.0
2017-04-21 05:30:00	SPY	ETF	235.37	235.47	235.36	235.46	1604.0
2017-04-21 06:00:00	SPY	ETF	235.46	235.47	235.39	235.47	1000.0
2017-04-21 06:30:00	SPY	ETF	235.4	235.44	235.31	235.44	5154.0
2017-04-21 07:00:00	SPY	ETF	235.48	235.61	235.48	235.54	22042.0
2017-04-21 07:30:00	SPY	ETF	235.54	235.55	235.49	235.49	8079.0
2017-04-21 08:00:00	SPY	ETF	235.55	235.6	235.41	235.48	88894.0
2017-04-21 08:30:00	SPY	ETF	235.48	235.56	235.44	235.44	155929.0
2017-04-21 09:00:00	SPY	ETF	235.44	235.44	235.15	235.26	512403.0
2017-04-21 09:30:00	SPY	ETF	235.25	235.31	234.91	235.0599	6744199.0
2017-04-21 10:00:00	SPY	ETF	235.06	235.22	234.93	235.14	18262149.0
2017-04-21 10:30:00	SPY	ETF	235.135	235.14	234.73	234.8701	4055388.0
2017-04-21 11:00:00	SPY	ETF	234.88	234.98	234.5625	234.93	7434933.0
2017-04-21 11:30:00	SPY	ETF	234.93	235.12	234.85	235.02	3607088.0
2017-04-21 12:00:00	SPY	ETF	235.02	235.02	234.63	234.7	3571625.0
2017-04-21 12:30:00	SPY	ETF	234.69	234.86	234.66	234.71	3064418.0
2017-04-21 13:00:00	SPY	ETF	234.72	234.75	234.13	234.4	7819702.0
2017-04-21 13:30:00	SPY	ETF	234.39	234.87	234.275	234.79	4395809.0
2017-04-21 14:00:00	SPY	ETF	234.79	234.975	234.66	234.93	4233248.0
2017-04-21 14:30:00	SPY	ETF	234.93	235.0	234.67	234.815	3094724.0
2017-04-21 15:00:00	SPY	ETF	234.82	234.85	234.47	234.7	6681832.0
2017-04-21 15:30:00	SPY	ETF	234.7	234.92	234.55	234.59	16500624.0
2017-04-21 16:00:00	SPY	ETF	234.58	234.83	234.515	234.73	11359606.0
2017-04-21 16:30:00	SPY	ETF	234.73	235.2729	234.58	234.6	943987.0
2017-04-21 17:00:00	SPY	ETF	234.6	234.74	234.0	234.56	6154942.0
2017-04-21 17:30:00	SPY	ETF	234.55	234.56	234.12	234.27	440777.0
2017-04-21 18:00:00	SPY	ETF	234.28	234.37	234.26	234.32	46483.0
2017-04-21 18:30:00	SPY	ETF	234.32	234.45	234.32	234.38	22817.0
2017-04-21 19:00:00	SPY	ETF	234.38	234.44	234.36	234.43	14917.0
2017-04-21 19:30:00	SPY	ETF	234.41	234.48	234.33	234.33	29436.0
2017-04-21 04:30:00	QQQ	ETF	132.77	132.77	132.77	132.77	5000.0
2017-04-21 05:00:00	QQQ	ETF	132.76	132.76	132.76	132.76	300.0
2017-04-21 05:30:00	QQQ	ETF	132.77	132.86	132.77	132.86	11298.0
2017-04-21 06:00:00	QQQ	ETF	132.86	132.87	132.86	132.87	9979.0
2017-04-21 06:30:00	QQQ	ETF	132.76	132.81	132.76	132.81	5699.0
2017-04-21 07:00:00	QQQ	ETF	132.82	132.86	132.8	132.8	5399.0
2017-04-21 07:30:00	QQQ	ETF	132.85	132.85	132.8	132.82	6900.0
2017-04-21 08:00:00	QQQ	ETF	132.8	132.8	132.76	132.76	19431.0
2017-04-21 08:30:00	QQQ	ETF	132.76	132.78	132.73	132.73	35451.0
2017-04-21 09:00:00	QQQ	ETF	132.72	132.74	132.62	132.7	159268.0
2017-04-21 09:30:00	QQQ	ETF	132.7	132.71	132.36	132.47	1710555.0
2017-04-21 10:00:00	QQQ	ETF	132.48	132.63	132.41	132.61	801473.0
2017-04-21 10:30:00	QQQ	ETF	132.6125	132.6125	132.41	132.49	1214211.0
2017-04-21 11:00:00	QQQ	ETF	132.48	132.7	132.4	132.64	744483.0
2017-04-21 11:30:00	QQQ	ETF	132.65	132.76	132.62	132.71	469294.0
2017-04-21 12:00:00	QQQ	ETF	132.71	132.73	132.49	132.55	809355.0
2017-04-21 12:30:00	QQQ	ETF	132.545	132.64	132.51	132.54	724175.0
2017-04-21 13:00:00	QQQ	ETF	132.535	132.57	132.22	132.38	1155524.0

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

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