PREVIEW / etf_30min / 2017-02-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-28.parquet
  size:    436 KB
  rows:    14,925

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-02-28 04:00:00	SPY	ETF	236.94	236.96	236.86	236.96	950.0
2017-02-28 04:30:00	SPY	ETF	236.93	237.05	236.93	237.05	1600.0
2017-02-28 05:00:00	SPY	ETF	237.05	237.05	236.96	236.96	600.0
2017-02-28 05:30:00	SPY	ETF	237.1	237.1	236.9	236.9	705.0
2017-02-28 06:30:00	SPY	ETF	237.02	237.06	237.02	237.04	2405.0
2017-02-28 07:00:00	SPY	ETF	237.01	237.01	236.88	236.92	8219.0
2017-02-28 07:30:00	SPY	ETF	236.92	236.99	236.88	236.88	55934.0
2017-02-28 08:00:00	SPY	ETF	236.89	237.01	236.76	236.85	58359.0
2017-02-28 08:30:00	SPY	ETF	236.82	236.9	236.77	236.87	83506.0
2017-02-28 09:00:00	SPY	ETF	236.88	236.9	236.66	236.67	400413.0
2017-02-28 09:30:00	SPY	ETF	236.67	236.84	236.61	236.6899	6180994.0
2017-02-28 10:00:00	SPY	ETF	236.69	236.95	236.67	236.73	3590333.0
2017-02-28 10:30:00	SPY	ETF	236.73	236.92	236.71	236.91	2933345.0
2017-02-28 11:00:00	SPY	ETF	236.91	236.94	236.82	236.91	2034934.0
2017-02-28 11:30:00	SPY	ETF	236.91	236.92	236.75	236.79	2815643.0
2017-02-28 12:00:00	SPY	ETF	236.79	236.8	236.015	236.2	6112930.0
2017-02-28 12:30:00	SPY	ETF	236.2	236.43	236.16	236.38	2735274.0
2017-02-28 13:00:00	SPY	ETF	236.39	236.59	236.35	236.435	4033991.0
2017-02-28 13:30:00	SPY	ETF	236.44	236.63	236.435	236.62	3812803.0
2017-02-28 14:00:00	SPY	ETF	236.62	236.6685	236.23	236.42	5183638.0
2017-02-28 14:30:00	SPY	ETF	236.42	236.6	236.35	236.4865	3503547.0
2017-02-28 15:00:00	SPY	ETF	236.495	236.59	236.4	236.42	6068826.0
2017-02-28 15:30:00	SPY	ETF	236.42	236.69	236.16	236.51	18204191.0
2017-02-28 16:00:00	SPY	ETF	236.51	236.58	236.35	236.49	22486760.0
2017-02-28 16:30:00	SPY	ETF	236.49	236.72	236.2573	236.7	1151726.0
2017-02-28 17:00:00	SPY	ETF	236.69	236.7	236.47	236.67	1425528.0
2017-02-28 17:30:00	SPY	ETF	236.67	236.74	236.67	236.69	1036027.0
2017-02-28 18:00:00	SPY	ETF	236.69	236.77	236.47	236.72	126822.0
2017-02-28 18:30:00	SPY	ETF	236.69	236.74	236.69	236.72	6250.0
2017-02-28 19:00:00	SPY	ETF	236.73	236.92	236.7	236.81	54638.0
2017-02-28 19:30:00	SPY	ETF	236.81	236.93	236.8	236.93	37302.0
2017-02-28 05:30:00	QQQ	ETF	130.38	130.38	130.38	130.38	100.0
2017-02-28 06:00:00	QQQ	ETF	130.38	130.38	130.38	130.38	1100.0
2017-02-28 06:30:00	QQQ	ETF	130.39	130.39	130.39	130.39	321.0
2017-02-28 07:00:00	QQQ	ETF	130.41	130.41	130.41	130.41	200.0
2017-02-28 07:30:00	QQQ	ETF	130.4	130.44	130.4	130.44	49997.0
2017-02-28 08:00:00	QQQ	ETF	130.38	130.41	130.36	130.41	31871.0
2017-02-28 08:30:00	QQQ	ETF	130.41	130.42	130.34	130.42	22085.0
2017-02-28 09:00:00	QQQ	ETF	130.41	130.43	130.37	130.4	44171.0
2017-02-28 09:30:00	QQQ	ETF	130.39	130.45	130.19	130.24	1330300.0
2017-02-28 10:00:00	QQQ	ETF	130.24	130.32	130.19	130.195	604272.0
2017-02-28 10:30:00	QQQ	ETF	130.195	130.28	130.11	130.26	594970.0
2017-02-28 11:00:00	QQQ	ETF	130.25	130.34	130.18	130.3044	485884.0
2017-02-28 11:30:00	QQQ	ETF	130.31	130.32	130.19	130.19	308482.0
2017-02-28 12:00:00	QQQ	ETF	130.19	130.21	129.66	129.7772	1292832.0
2017-02-28 12:30:00	QQQ	ETF	129.77	129.9	129.76	129.88	770976.0
2017-02-28 13:00:00	QQQ	ETF	129.88	130.035	129.86	129.965	793559.0
2017-02-28 13:30:00	QQQ	ETF	129.96	130.06	129.935	130.06	470228.0
2017-02-28 14:00:00	QQQ	ETF	130.055	130.08	129.855	129.91	608899.0
2017-02-28 14:30:00	QQQ	ETF	129.9167	130.02	129.88	129.98	749249.0

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

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