PREVIEW / etf_30min / 2013-02-01

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-01.parquet
  size:    315 KB
  rows:    10,676

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-02-01 04:00:00	SPY	ETF	150.3	150.3	150.3	150.3	200.0
2013-02-01 04:30:00	SPY	ETF	150.3	150.3	150.27	150.27	2299.0
2013-02-01 05:00:00	SPY	ETF	150.3	150.34	150.29	150.34	5400.0
2013-02-01 05:30:00	SPY	ETF	150.32	150.32	150.21	150.22	19073.0
2013-02-01 06:00:00	SPY	ETF	150.13	150.14	149.99	150.07	24253.0
2013-02-01 06:30:00	SPY	ETF	150.16	150.16	150.11	150.12	31510.0
2013-02-01 07:00:00	SPY	ETF	150.09	150.14	150.06	150.06	105982.0
2013-02-01 07:30:00	SPY	ETF	150.11	150.25	150.09	150.21	117561.0
2013-02-01 08:00:00	SPY	ETF	150.12	150.44	149.7	150.36	767129.0
2013-02-01 08:30:00	SPY	ETF	150.19	150.92	149.7	150.76	3997235.0
2013-02-01 09:00:00	SPY	ETF	150.77	150.8	150.52	150.64	2128028.0
2013-02-01 09:30:00	SPY	ETF	150.65	150.72	150.39	150.44	16596615.0
2013-02-01 10:00:00	SPY	ETF	150.57	151.12	150.43	150.7199	21357254.0
2013-02-01 10:30:00	SPY	ETF	150.715	151.0	150.69	150.99	9221803.0
2013-02-01 11:00:00	SPY	ETF	150.99	151.08	150.93	150.95	7010322.0
2013-02-01 11:30:00	SPY	ETF	150.95	151.24	150.93	151.215	7400873.0
2013-02-01 12:00:00	SPY	ETF	151.22	151.27	151.15	151.1892	4251939.0
2013-02-01 12:30:00	SPY	ETF	151.19	151.28	151.15	151.25	3433422.0
2013-02-01 13:00:00	SPY	ETF	151.25	151.33	151.17	151.27	4842781.0
2013-02-01 13:30:00	SPY	ETF	151.28	151.42	151.26	151.36	3833066.0
2013-02-01 14:00:00	SPY	ETF	151.355	151.37	151.22	151.32	4161537.0
2013-02-01 14:30:00	SPY	ETF	151.32	151.35	151.12	151.1498	4697921.0
2013-02-01 15:00:00	SPY	ETF	151.15	151.235	151.06	151.07	4884763.0
2013-02-01 15:30:00	SPY	ETF	151.08	151.36	151.03	151.22	17188366.0
2013-02-01 16:00:00	SPY	ETF	151.2	151.29	151.02	151.07	9582530.0
2013-02-01 16:30:00	SPY	ETF	151.07	151.19	151.07	151.18	1273536.0
2013-02-01 17:00:00	SPY	ETF	151.16	151.2	151.13	151.16	100638.0
2013-02-01 17:30:00	SPY	ETF	151.2	151.38	151.2	151.27	240179.0
2013-02-01 18:00:00	SPY	ETF	151.27	151.27	151.17	151.2	44545.0
2013-02-01 18:30:00	SPY	ETF	151.24	151.26	151.2	151.25	6635.0
2013-02-01 19:00:00	SPY	ETF	151.25	151.25	151.2	151.2	2350.0
2013-02-01 19:30:00	SPY	ETF	151.24	151.26	151.21	151.24	15557.0
2013-02-01 06:00:00	QQQ	ETF	66.96	66.96	66.96	66.96	150.0
2013-02-01 06:30:00	QQQ	ETF	67.02	67.06	67.02	67.04	1710.0
2013-02-01 07:00:00	QQQ	ETF	67.05	67.07	67.05	67.06	5400.0
2013-02-01 07:30:00	QQQ	ETF	67.09	67.13	67.08	67.13	13500.0
2013-02-01 08:00:00	QQQ	ETF	67.06	67.22	67.06	67.19	61281.0
2013-02-01 08:30:00	QQQ	ETF	67.13	67.4	67.13	67.36	1367440.0
2013-02-01 09:00:00	QQQ	ETF	67.37	67.38	67.28	67.335	137188.0
2013-02-01 09:30:00	QQQ	ETF	67.34	67.36	67.07	67.1	5782089.0
2013-02-01 10:00:00	QQQ	ETF	67.12	67.47	67.1	67.21	4296617.0
2013-02-01 10:30:00	QQQ	ETF	67.21	67.34	67.16	67.33	2646442.0
2013-02-01 11:00:00	QQQ	ETF	67.33	67.38	67.32	67.33	1629518.0
2013-02-01 11:30:00	QQQ	ETF	67.33	67.62	67.325	67.609	2573636.0
2013-02-01 12:00:00	QQQ	ETF	67.61	67.65	67.56	67.615	1418224.0
2013-02-01 12:30:00	QQQ	ETF	67.615	67.74	67.615	67.69	2209506.0
2013-02-01 13:00:00	QQQ	ETF	67.68	67.71	67.63	67.69	1425510.0
2013-02-01 13:30:00	QQQ	ETF	67.69	67.78	67.69	67.74	1381010.0
2013-02-01 14:00:00	QQQ	ETF	67.74	67.749	67.66	67.68	1004846.0
2013-02-01 14:30:00	QQQ	ETF	67.69	67.69	67.6	67.625	1578600.0

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

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