PREVIEW / etf_30min / 2013-09-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-17.parquet
  size:    312 KB
  rows:    10,782

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
2013-09-17 04:00:00	SPY	ETF	170.1	170.18	170.06	170.06	9079.0
2013-09-17 04:30:00	SPY	ETF	170.09	170.24	170.09	170.21	2000.0
2013-09-17 05:00:00	SPY	ETF	170.24	170.24	170.09	170.12	6400.0
2013-09-17 05:30:00	SPY	ETF	170.09	170.18	170.05	170.15	26648.0
2013-09-17 06:00:00	SPY	ETF	170.18	170.18	170.07	170.15	45287.0
2013-09-17 06:30:00	SPY	ETF	170.15	170.21	170.15	170.2	9000.0
2013-09-17 07:00:00	SPY	ETF	170.17	170.36	170.1	170.36	68624.0
2013-09-17 07:30:00	SPY	ETF	170.34	170.36	170.21	170.36	57400.0
2013-09-17 08:00:00	SPY	ETF	170.34	170.42	170.2	170.42	121228.0
2013-09-17 08:30:00	SPY	ETF	170.39	170.51	170.37	170.43	229967.0
2013-09-17 09:00:00	SPY	ETF	170.43	170.56	170.42	170.45	501143.0
2013-09-17 09:30:00	SPY	ETF	170.46	170.89	170.46	170.76	11369352.0
2013-09-17 10:00:00	SPY	ETF	170.755	170.961	170.72	170.9	6914286.0
2013-09-17 10:30:00	SPY	ETF	170.895	171.0	170.81	170.86	5899241.0
2013-09-17 11:00:00	SPY	ETF	170.86	170.94	170.8	170.929	3566837.0
2013-09-17 11:30:00	SPY	ETF	170.93	170.96	170.8	170.86	4922815.0
2013-09-17 12:00:00	SPY	ETF	170.86	170.92	170.81	170.91	2614206.0
2013-09-17 12:30:00	SPY	ETF	170.91	171.06	170.83	171.03	4114675.0
2013-09-17 13:00:00	SPY	ETF	171.03	171.08	170.93	170.97	4329805.0
2013-09-17 13:30:00	SPY	ETF	170.98	171.06	170.96	171.045	2064793.0
2013-09-17 14:00:00	SPY	ETF	171.045	171.11	170.95	171.01	3214214.0
2013-09-17 14:30:00	SPY	ETF	171.01	171.09	170.99	171.031	3711781.0
2013-09-17 15:00:00	SPY	ETF	171.03	171.07	170.99	171.019	5489402.0
2013-09-17 15:30:00	SPY	ETF	171.02	171.05	170.89	171.04	10741794.0
2013-09-17 16:00:00	SPY	ETF	171.05	171.1935	170.297	171.14	5198273.0
2013-09-17 16:30:00	SPY	ETF	171.14	171.19	170.297	171.17	4965783.0
2013-09-17 17:00:00	SPY	ETF	171.15	171.19	170.9383	171.19	320574.0
2013-09-17 17:30:00	SPY	ETF	171.19	171.22	171.17	171.18	147911.0
2013-09-17 18:00:00	SPY	ETF	171.18	171.18	171.08	171.08	203314.0
2013-09-17 18:30:00	SPY	ETF	171.11	171.12	171.1	171.12	17800.0
2013-09-17 19:00:00	SPY	ETF	171.12	171.12	171.11	171.12	23000.0
2013-09-17 19:30:00	SPY	ETF	171.12	171.13	171.11	171.13	20272.0
2013-09-17 05:00:00	QQQ	ETF	77.79	77.79	77.74	77.76	10000.0
2013-09-17 05:30:00	QQQ	ETF	77.74	77.76	77.74	77.76	3200.0
2013-09-17 06:00:00	QQQ	ETF	77.74	77.74	77.72	77.74	2400.0
2013-09-17 07:00:00	QQQ	ETF	77.72	77.82	77.72	77.82	16090.0
2013-09-17 07:30:00	QQQ	ETF	77.8	77.82	77.78	77.82	11055.0
2013-09-17 08:00:00	QQQ	ETF	77.82	77.86	77.81	77.85	55885.0
2013-09-17 08:30:00	QQQ	ETF	77.85	77.92	77.85	77.91	25500.0
2013-09-17 09:00:00	QQQ	ETF	77.92	78.09	77.92	77.98	245333.0
2013-09-17 09:30:00	QQQ	ETF	77.98	78.2	77.98	78.13	2996957.0
2013-09-17 10:00:00	QQQ	ETF	78.121	78.31	78.105	78.21	2191836.0
2013-09-17 10:30:00	QQQ	ETF	78.22	78.31	78.201	78.309	1224350.0
2013-09-17 11:00:00	QQQ	ETF	78.31	78.4	78.2826	78.368	1165966.0
2013-09-17 11:30:00	QQQ	ETF	78.365	78.38	78.248	78.3	969515.0
2013-09-17 12:00:00	QQQ	ETF	78.3	78.38	78.3	78.37	855372.0
2013-09-17 12:30:00	QQQ	ETF	78.3676	78.42	78.32	78.41	493307.0
2013-09-17 13:00:00	QQQ	ETF	78.41	78.44	78.3201	78.38	625659.0
2013-09-17 13:30:00	QQQ	ETF	78.39	78.45	78.37	78.43	660471.0
2013-09-17 14:00:00	QQQ	ETF	78.43	78.47	78.3934	78.43	566210.0

> showing 50 of 10,782 rows — these rows as CSV

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