PREVIEW / etf_30min / 2012-08-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-20.parquet
  size:    274 KB
  rows:    9,229

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-20 05:00:00	SPY	ETF	142.39	142.39	142.39	142.39	500.0
2012-08-20 05:30:00	SPY	ETF	142.33	142.33	142.33	142.33	19930.0
2012-08-20 06:00:00	SPY	ETF	142.2	142.36	142.2	142.36	800.0
2012-08-20 06:30:00	SPY	ETF	142.26	142.31	142.25	142.27	2884.0
2012-08-20 07:00:00	SPY	ETF	142.29	142.29	142.07	142.07	121020.0
2012-08-20 07:30:00	SPY	ETF	142.11	142.11	141.97	142.09	237634.0
2012-08-20 08:00:00	SPY	ETF	142.03	142.15	141.97	142.02	227456.0
2012-08-20 08:30:00	SPY	ETF	142.01	142.05	141.97	141.98	214790.0
2012-08-20 09:00:00	SPY	ETF	141.97	142.22	141.83	141.97	400453.0
2012-08-20 09:30:00	SPY	ETF	141.98	142.12	141.76	141.82	10790163.0
2012-08-20 10:00:00	SPY	ETF	141.8281	141.89	141.59	141.73	8451519.0
2012-08-20 10:30:00	SPY	ETF	141.7299	141.88	141.62	141.8587	5937100.0
2012-08-20 11:00:00	SPY	ETF	141.85	141.94	141.76	141.78	4012512.0
2012-08-20 11:30:00	SPY	ETF	141.78	142.04	141.75	141.98	5274346.0
2012-08-20 12:00:00	SPY	ETF	141.98	142.11	141.96	142.02	5066187.0
2012-08-20 12:30:00	SPY	ETF	142.01	142.02	141.91	141.95	2872105.0
2012-08-20 13:00:00	SPY	ETF	141.96	142.04	141.93	141.99	2059310.0
2012-08-20 13:30:00	SPY	ETF	141.98	141.99	141.86	141.98	1686435.0
2012-08-20 14:00:00	SPY	ETF	141.978	142.11	141.9	142.11	4423193.0
2012-08-20 14:30:00	SPY	ETF	142.11	142.21	142.02	142.08	3651243.0
2012-08-20 15:00:00	SPY	ETF	142.08	142.13	141.99	142.12	3535785.0
2012-08-20 15:30:00	SPY	ETF	142.13	142.22	142.08	142.19	7861252.0
2012-08-20 16:00:00	SPY	ETF	142.19	142.26	142.09	142.12	10252402.0
2012-08-20 16:30:00	SPY	ETF	142.12	142.17	142.11	142.15	543136.0
2012-08-20 17:00:00	SPY	ETF	142.14	142.22	142.14	142.19	21114.0
2012-08-20 17:30:00	SPY	ETF	142.2	142.25	142.2	142.22	40550.0
2012-08-20 18:00:00	SPY	ETF	142.21	142.22	142.17	142.21	106417.0
2012-08-20 18:30:00	SPY	ETF	142.19	142.24	142.19	142.2	9200.0
2012-08-20 19:00:00	SPY	ETF	142.18	142.19	142.17	142.17	5000.0
2012-08-20 19:30:00	SPY	ETF	142.17	142.2	142.14	142.14	21512.0
2012-08-20 05:30:00	QQQ	ETF	68.35	68.35	68.35	68.35	100.0
2012-08-20 07:00:00	QQQ	ETF	68.26	68.26	68.22	68.22	4797.0
2012-08-20 07:30:00	QQQ	ETF	68.2	68.28	68.19	68.28	60500.0
2012-08-20 08:00:00	QQQ	ETF	68.25	68.32	68.22	68.28	64638.0
2012-08-20 08:30:00	QQQ	ETF	68.26	68.3	68.23	68.29	46262.0
2012-08-20 09:00:00	QQQ	ETF	68.3	68.32	68.24	68.25	86721.0
2012-08-20 09:30:00	QQQ	ETF	68.26	68.29	68.03	68.0601	3174291.0
2012-08-20 10:00:00	QQQ	ETF	68.06	68.18	68.0	68.1399	3026264.0
2012-08-20 10:30:00	QQQ	ETF	68.14	68.21	68.05	68.2	1656193.0
2012-08-20 11:00:00	QQQ	ETF	68.2	68.21	68.12	68.14	840978.0
2012-08-20 11:30:00	QQQ	ETF	68.14	68.34	68.13	68.325	1018914.0
2012-08-20 12:00:00	QQQ	ETF	68.32	68.43	68.29	68.34	1934522.0
2012-08-20 12:30:00	QQQ	ETF	68.3397	68.34	68.193	68.28	767639.0
2012-08-20 13:00:00	QQQ	ETF	68.27	68.32	68.25	68.27	360459.0
2012-08-20 13:30:00	QQQ	ETF	68.28	68.28	68.16	68.24	753718.0
2012-08-20 14:00:00	QQQ	ETF	68.23	68.33	68.2008	68.32	768077.0
2012-08-20 14:30:00	QQQ	ETF	68.3213	68.36	68.27	68.33	1063091.0
2012-08-20 15:00:00	QQQ	ETF	68.32	68.39	68.24	68.3857	1088796.0
2012-08-20 15:30:00	QQQ	ETF	68.39	68.43	68.33	68.41	2225803.0
2012-08-20 16:00:00	QQQ	ETF	68.41	68.43	68.33	68.36	508684.0

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

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