PREVIEW / etf_30min / 2015-10-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-06.parquet
  size:    381 KB
  rows:    12,866

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
2015-10-06 04:00:00	SPY	ETF	197.35	197.71	197.13	197.6	42224.0
2015-10-06 04:30:00	SPY	ETF	197.68	198.02	197.68	197.96	23119.0
2015-10-06 05:00:00	SPY	ETF	197.95	198.03	197.77	197.9	20728.0
2015-10-06 05:30:00	SPY	ETF	197.95	197.95	197.66	197.66	17366.0
2015-10-06 06:00:00	SPY	ETF	197.68	197.76	197.62	197.62	15866.0
2015-10-06 06:30:00	SPY	ETF	197.73	198.0	197.69	197.69	91013.0
2015-10-06 07:00:00	SPY	ETF	197.7	197.79	197.5	197.66	245408.0
2015-10-06 07:30:00	SPY	ETF	197.68	197.93	197.56	197.91	233774.0
2015-10-06 08:00:00	SPY	ETF	197.9	197.94	197.66	197.82	435017.0
2015-10-06 08:30:00	SPY	ETF	197.8	198.12	197.61	198.11	526009.0
2015-10-06 09:00:00	SPY	ETF	198.11	198.45	198.04	198.32	712446.0
2015-10-06 09:30:00	SPY	ETF	198.31	198.98	198.0	198.91	11100879.0
2015-10-06 10:00:00	SPY	ETF	198.91	198.93	197.76	197.82	10474988.0
2015-10-06 10:30:00	SPY	ETF	197.83	198.3	197.69	197.89	6792569.0
2015-10-06 11:00:00	SPY	ETF	197.88	198.43	197.85	198.2868	6069623.0
2015-10-06 11:30:00	SPY	ETF	198.28	198.36	197.14	197.33	10211799.0
2015-10-06 12:00:00	SPY	ETF	197.33	197.74	197.3	197.38	5309989.0
2015-10-06 12:30:00	SPY	ETF	197.37	197.48	197.0	197.48	6335643.0
2015-10-06 13:00:00	SPY	ETF	197.48	198.095	197.35	197.9151	6135349.0
2015-10-06 13:30:00	SPY	ETF	197.92	197.92	197.37	197.63	4990168.0
2015-10-06 14:00:00	SPY	ETF	197.62	198.19	197.47	198.11	7655557.0
2015-10-06 14:30:00	SPY	ETF	198.11	198.27	197.605	197.7761	5960899.0
2015-10-06 15:00:00	SPY	ETF	197.77	198.05	197.54	197.965	5052156.0
2015-10-06 15:30:00	SPY	ETF	197.95	198.2	197.645	197.82	13169590.0
2015-10-06 16:00:00	SPY	ETF	197.84	198.0	197.38	197.4	6405144.0
2015-10-06 16:30:00	SPY	ETF	197.4	197.7871	197.02	197.19	820746.0
2015-10-06 17:00:00	SPY	ETF	197.2	197.79	196.8	197.08	175858.0
2015-10-06 17:30:00	SPY	ETF	197.08	197.9122	196.82	196.83	151433.0
2015-10-06 18:00:00	SPY	ETF	196.82	197.02	196.79	197.0	73843.0
2015-10-06 18:30:00	SPY	ETF	196.98	197.12	196.98	197.02	40352.0
2015-10-06 19:00:00	SPY	ETF	197.02	197.23	197.02	197.17	50425.0
2015-10-06 19:30:00	SPY	ETF	197.17	197.3	197.14	197.2	42952.0
2015-10-06 04:00:00	QQQ	ETF	104.81	104.94	104.65	104.88	4880.0
2015-10-06 04:30:00	QQQ	ETF	104.98	105.1	104.98	105.1	3400.0
2015-10-06 05:00:00	QQQ	ETF	105.04	105.13	105.04	105.13	2345.0
2015-10-06 05:30:00	QQQ	ETF	105.05	105.05	104.95	104.95	300.0
2015-10-06 06:00:00	QQQ	ETF	104.95	105.02	104.94	104.99	5000.0
2015-10-06 06:30:00	QQQ	ETF	105.02	105.12	105.02	105.12	3400.0
2015-10-06 07:00:00	QQQ	ETF	105.0	105.0	104.89	104.98	10690.0
2015-10-06 07:30:00	QQQ	ETF	104.96	105.03	104.9	105.03	13049.0
2015-10-06 08:00:00	QQQ	ETF	105.03	105.11	105.02	105.02	32954.0
2015-10-06 08:30:00	QQQ	ETF	105.02	105.22	104.94	105.2	85120.0
2015-10-06 09:00:00	QQQ	ETF	105.24	105.35	105.18	105.26	160629.0
2015-10-06 09:30:00	QQQ	ETF	105.26	105.6	105.06	105.57	3840347.0
2015-10-06 10:00:00	QQQ	ETF	105.56	105.58	104.7821	104.8099	3441596.0
2015-10-06 10:30:00	QQQ	ETF	104.81	105.05	104.67	104.75	2188505.0
2015-10-06 11:00:00	QQQ	ETF	104.7501	104.971	104.64	104.87	1988202.0
2015-10-06 11:30:00	QQQ	ETF	104.87	104.92	104.27	104.39	2732363.0
2015-10-06 12:00:00	QQQ	ETF	104.39	104.6501	104.35	104.43	1937156.0
2015-10-06 12:30:00	QQQ	ETF	104.43	104.51	104.18	104.505	1738251.0

> showing 50 of 12,866 rows — these rows as CSV

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