PREVIEW / etf_30min / 2013-09-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-10.parquet
  size:    331 KB
  rows:    11,368

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-10 04:00:00	SPY	ETF	168.06	168.3	168.06	168.3	23402.0
2013-09-10 04:30:00	SPY	ETF	168.3	168.32	168.24	168.27	4820.0
2013-09-10 05:00:00	SPY	ETF	168.26	168.26	168.18	168.24	11700.0
2013-09-10 05:30:00	SPY	ETF	168.22	168.33	168.2	168.33	28350.0
2013-09-10 06:00:00	SPY	ETF	168.33	168.34	168.33	168.34	5900.0
2013-09-10 06:30:00	SPY	ETF	168.33	168.41	168.3	168.34	15250.0
2013-09-10 07:00:00	SPY	ETF	168.3	168.47	168.3	168.44	360127.0
2013-09-10 07:30:00	SPY	ETF	168.43	168.7	168.43	168.6	320822.0
2013-09-10 08:00:00	SPY	ETF	168.57	168.64	168.38	168.5	552106.0
2013-09-10 08:30:00	SPY	ETF	168.49	168.64	168.45	168.5	744983.0
2013-09-10 09:00:00	SPY	ETF	168.49	168.65	168.46	168.64	572267.0
2013-09-10 09:30:00	SPY	ETF	168.64	168.69	168.26	168.54	12413133.0
2013-09-10 10:00:00	SPY	ETF	168.55	168.77	168.48	168.72	9452086.0
2013-09-10 10:30:00	SPY	ETF	168.73	168.88	168.66	168.73	7630359.0
2013-09-10 11:00:00	SPY	ETF	168.735	168.8	168.66	168.695	5265563.0
2013-09-10 11:30:00	SPY	ETF	168.69	168.71	168.27	168.45	8954031.0
2013-09-10 12:00:00	SPY	ETF	168.445	168.585	168.43	168.51	4152582.0
2013-09-10 12:30:00	SPY	ETF	168.515	168.69	168.45	168.66	2947126.0
2013-09-10 13:00:00	SPY	ETF	168.655	168.78	168.49	168.7399	5434888.0
2013-09-10 13:30:00	SPY	ETF	168.735	168.755	168.63	168.7	3507972.0
2013-09-10 14:00:00	SPY	ETF	168.7	168.77	168.61	168.69	4538193.0
2013-09-10 14:30:00	SPY	ETF	168.69	168.77	168.51	168.73	4791418.0
2013-09-10 15:00:00	SPY	ETF	168.725	168.83	168.65	168.77	6368982.0
2013-09-10 15:30:00	SPY	ETF	168.775	168.9	168.62	168.89	14673590.0
2013-09-10 16:00:00	SPY	ETF	168.88	168.88	168.76	168.81	3338810.0
2013-09-10 16:30:00	SPY	ETF	168.82	168.88	168.5475	168.82	204638.0
2013-09-10 17:00:00	SPY	ETF	168.83	168.85	168.8	168.85	74950.0
2013-09-10 17:30:00	SPY	ETF	168.81	168.85	167.6413	168.77	2871072.0
2013-09-10 18:00:00	SPY	ETF	168.78	168.84	168.75	168.81	82648.0
2013-09-10 18:30:00	SPY	ETF	168.79	168.84	168.76	168.76	294675.0
2013-09-10 19:00:00	SPY	ETF	168.75	168.75	168.71	168.71	148288.0
2013-09-10 19:30:00	SPY	ETF	168.73	168.75	168.68	168.7	21269.0
2013-09-10 04:00:00	QQQ	ETF	78.05	78.18	78.05	78.18	16965.0
2013-09-10 04:30:00	QQQ	ETF	78.16	78.16	78.14	78.14	1800.0
2013-09-10 05:00:00	QQQ	ETF	78.12	78.12	78.1	78.1	1700.0
2013-09-10 05:30:00	QQQ	ETF	78.12	78.17	78.12	78.17	3300.0
2013-09-10 06:00:00	QQQ	ETF	78.17	78.18	78.17	78.18	10900.0
2013-09-10 06:30:00	QQQ	ETF	78.2	78.2	78.2	78.2	3560.0
2013-09-10 07:00:00	QQQ	ETF	78.18	78.24	78.15	78.21	56400.0
2013-09-10 07:30:00	QQQ	ETF	78.21	78.31	78.21	78.27	62585.0
2013-09-10 08:00:00	QQQ	ETF	78.26	78.28	78.21	78.23	109019.0
2013-09-10 08:30:00	QQQ	ETF	78.23	78.28	78.18	78.2	94517.0
2013-09-10 09:00:00	QQQ	ETF	78.2	78.29	78.19	78.27	671723.0
2013-09-10 09:30:00	QQQ	ETF	78.27	78.28	78.07	78.16	5068471.0
2013-09-10 10:00:00	QQQ	ETF	78.16	78.28	78.07	78.2095	2900384.0
2013-09-10 10:30:00	QQQ	ETF	78.2023	78.3099	78.17	78.19	1719632.0
2013-09-10 11:00:00	QQQ	ETF	78.2	78.32	78.2	78.28	1161942.0
2013-09-10 11:30:00	QQQ	ETF	78.28	78.3	78.109	78.16	1153565.0
2013-09-10 12:00:00	QQQ	ETF	78.16	78.18	78.08	78.1098	816384.0
2013-09-10 12:30:00	QQQ	ETF	78.1	78.19	78.02	78.18	945529.0

> showing 50 of 11,368 rows — these rows as CSV

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