PREVIEW / etf_30min / 2012-08-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-17.parquet
  size:    269 KB
  rows:    9,122

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
2012-08-17 04:00:00	SPY	ETF	141.99	141.99	141.8	141.8	345.0
2012-08-17 05:00:00	SPY	ETF	141.89	141.89	141.89	141.89	400.0
2012-08-17 05:30:00	SPY	ETF	141.92	141.92	141.91	141.91	1200.0
2012-08-17 06:00:00	SPY	ETF	141.87	141.88	141.82	141.88	15300.0
2012-08-17 06:30:00	SPY	ETF	141.87	141.88	141.74	141.77	12830.0
2012-08-17 07:00:00	SPY	ETF	141.78	141.83	141.72	141.78	89565.0
2012-08-17 07:30:00	SPY	ETF	141.8	141.88	141.72	141.77	54050.0
2012-08-17 08:00:00	SPY	ETF	141.77	141.88	141.73	141.81	264062.0
2012-08-17 08:30:00	SPY	ETF	141.8	141.88	141.78	141.86	236177.0
2012-08-17 09:00:00	SPY	ETF	141.86	142.26	141.83	142.24	1130775.0
2012-08-17 09:30:00	SPY	ETF	142.23	142.25	141.89	142.13	13772441.0
2012-08-17 10:00:00	SPY	ETF	142.13	142.15	141.92	141.965	8974942.0
2012-08-17 10:30:00	SPY	ETF	141.97	142.04	141.86	141.96	5954027.0
2012-08-17 11:00:00	SPY	ETF	141.96	142.02	141.87	141.97	4958034.0
2012-08-17 11:30:00	SPY	ETF	141.97	142.15	141.92	142.12	4582090.0
2012-08-17 12:00:00	SPY	ETF	142.12	142.13	142.03	142.04	4890297.0
2012-08-17 12:30:00	SPY	ETF	142.05	142.06	141.9	141.95	4000286.0
2012-08-17 13:00:00	SPY	ETF	141.95	142.01	141.93	141.99	2589555.0
2012-08-17 13:30:00	SPY	ETF	141.99	142.055	141.97	142.0	3097688.0
2012-08-17 14:00:00	SPY	ETF	142.0	142.1	141.95	142.07	4005099.0
2012-08-17 14:30:00	SPY	ETF	142.08	142.14	142.05	142.12	5189611.0
2012-08-17 15:00:00	SPY	ETF	142.12	142.18	142.05	142.07	4446967.0
2012-08-17 15:30:00	SPY	ETF	142.08	142.3	141.96	142.19	11784079.0
2012-08-17 16:00:00	SPY	ETF	142.18	142.29	141.994	142.07	6912060.0
2012-08-17 16:30:00	SPY	ETF	142.07	142.14	142.013	142.12	1360536.0
2012-08-17 17:00:00	SPY	ETF	142.12	142.13	142.11	142.12	61885.0
2012-08-17 17:30:00	SPY	ETF	142.12	142.13	142.11	142.13	39934.0
2012-08-17 18:00:00	SPY	ETF	142.13	142.13	142.1	142.11	4462.0
2012-08-17 18:30:00	SPY	ETF	142.11	142.13	142.11	142.12	5900.0
2012-08-17 19:00:00	SPY	ETF	142.12	142.13	142.07	142.1	11738.0
2012-08-17 19:30:00	SPY	ETF	142.12	142.13	142.09	142.13	6729.0
2012-08-17 04:30:00	QQQ	ETF	68.07	68.07	68.07	68.07	1000.0
2012-08-17 05:30:00	QQQ	ETF	68.09	68.09	68.09	68.09	400.0
2012-08-17 06:00:00	QQQ	ETF	68.06	68.07	68.05	68.05	4400.0
2012-08-17 06:30:00	QQQ	ETF	68.05	68.05	68.0	68.0	2700.0
2012-08-17 07:00:00	QQQ	ETF	68.0	68.0	68.0	68.0	500.0
2012-08-17 07:30:00	QQQ	ETF	68.01	68.02	68.0	68.02	2300.0
2012-08-17 08:00:00	QQQ	ETF	67.99	68.05	67.99	68.02	6520.0
2012-08-17 08:30:00	QQQ	ETF	68.01	68.08	68.0	68.06	392233.0
2012-08-17 09:00:00	QQQ	ETF	68.06	68.2	68.06	68.18	169827.0
2012-08-17 09:30:00	QQQ	ETF	68.17	68.23	68.02	68.21	3450252.0
2012-08-17 10:00:00	QQQ	ETF	68.21	68.25	68.07	68.08	1842886.0
2012-08-17 10:30:00	QQQ	ETF	68.08	68.14	68.02	68.12	2024557.0
2012-08-17 11:00:00	QQQ	ETF	68.11	68.14	68.01	68.13	1392107.0
2012-08-17 11:30:00	QQQ	ETF	68.125	68.24	68.1	68.23	1100072.0
2012-08-17 12:00:00	QQQ	ETF	68.239	68.26	68.18	68.2199	958921.0
2012-08-17 12:30:00	QQQ	ETF	68.22	68.22	68.11	68.14	1860882.0
2012-08-17 13:00:00	QQQ	ETF	68.1401	68.2	68.14	68.19	1151957.0
2012-08-17 13:30:00	QQQ	ETF	68.1899	68.23	68.16	68.1689	985931.0
2012-08-17 14:00:00	QQQ	ETF	68.165	68.23	68.13	68.2099	1269890.0

> showing 50 of 9,122 rows — these rows as CSV

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