PREVIEW / etf_30min / 2015-12-28

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-28.parquet
  size:    392 KB
  rows:    13,177

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-12-28 04:00:00	SPY	ETF	205.75	205.75	205.05	205.08	1850.0
2015-12-28 04:30:00	SPY	ETF	205.05	205.08	204.91	205.06	5703.0
2015-12-28 05:00:00	SPY	ETF	204.9	204.95	204.83	204.91	1784.0
2015-12-28 05:30:00	SPY	ETF	204.85	204.96	204.83	204.84	7500.0
2015-12-28 06:00:00	SPY	ETF	204.87	204.9	204.75	204.83	12462.0
2015-12-28 06:30:00	SPY	ETF	204.83	204.88	204.76	204.8	17584.0
2015-12-28 07:00:00	SPY	ETF	204.8	204.85	204.48	204.5	91928.0
2015-12-28 07:30:00	SPY	ETF	204.5	204.59	204.42	204.59	50343.0
2015-12-28 08:00:00	SPY	ETF	204.76	204.76	204.5	204.68	323216.0
2015-12-28 08:30:00	SPY	ETF	204.7	204.82	204.7	204.73	233809.0
2015-12-28 09:00:00	SPY	ETF	204.72	204.94	204.69	204.86	252658.0
2015-12-28 09:30:00	SPY	ETF	204.86	205.05	204.53	204.73	7381194.0
2015-12-28 10:00:00	SPY	ETF	204.73	204.74	204.18	204.425	6906509.0
2015-12-28 10:30:00	SPY	ETF	204.42	204.46	203.94	204.06	3607631.0
2015-12-28 11:00:00	SPY	ETF	204.065	204.37	203.99	204.219	4334506.0
2015-12-28 11:30:00	SPY	ETF	204.21	204.68	204.13	204.46	4989026.0
2015-12-28 12:00:00	SPY	ETF	204.465	204.69	204.325	204.57	4111302.0
2015-12-28 12:30:00	SPY	ETF	204.57	204.64	204.4	204.45	3479296.0
2015-12-28 13:00:00	SPY	ETF	204.45	205.03	204.44	204.9499	3482372.0
2015-12-28 13:30:00	SPY	ETF	204.95	205.26	204.68	204.72	4550433.0
2015-12-28 14:00:00	SPY	ETF	204.72	204.96	204.68	204.95	2887313.0
2015-12-28 14:30:00	SPY	ETF	204.945	205.07	204.8	205.005	2633726.0
2015-12-28 15:00:00	SPY	ETF	205.0	205.15	204.8	205.1	4818554.0
2015-12-28 15:30:00	SPY	ETF	205.11	205.23	204.99	205.19	7981313.0
2015-12-28 16:00:00	SPY	ETF	205.19	205.38	204.6975	205.37	3068577.0
2015-12-28 16:30:00	SPY	ETF	205.36	205.51	205.34	205.42	136828.0
2015-12-28 17:00:00	SPY	ETF	205.43	205.43	205.37	205.37	30561.0
2015-12-28 17:30:00	SPY	ETF	205.38	205.38	205.22	205.38	22751.0
2015-12-28 18:00:00	SPY	ETF	205.39	205.44	205.32	205.33	56880.0
2015-12-28 18:30:00	SPY	ETF	205.32	205.34	205.28	205.31	35761.0
2015-12-28 19:00:00	SPY	ETF	205.31	205.38	205.2	205.21	52251.0
2015-12-28 19:30:00	SPY	ETF	205.23	205.31	205.2	205.31	14248.0
2015-12-28 04:00:00	QQQ	ETF	112.4	112.4	112.35	112.35	300.0
2015-12-28 05:30:00	QQQ	ETF	112.19	112.19	112.17	112.17	900.0
2015-12-28 06:00:00	QQQ	ETF	112.23	112.23	112.1	112.1	1524.0
2015-12-28 07:00:00	QQQ	ETF	112.14	112.14	112.0	112.0	5500.0
2015-12-28 07:30:00	QQQ	ETF	112.0	112.08	111.99	112.07	4025.0
2015-12-28 08:00:00	QQQ	ETF	112.1	112.2	112.05	112.2	169701.0
2015-12-28 08:30:00	QQQ	ETF	112.21	112.24	112.18	112.21	16026.0
2015-12-28 09:00:00	QQQ	ETF	112.21	112.31	112.18	112.29	146807.0
2015-12-28 09:30:00	QQQ	ETF	112.32	112.37	112.11	112.19	3065732.0
2015-12-28 10:00:00	QQQ	ETF	112.191	112.2	111.85	111.9354	2378629.0
2015-12-28 10:30:00	QQQ	ETF	111.93	111.94	111.51	111.58	1392810.0
2015-12-28 11:00:00	QQQ	ETF	111.57	111.809	111.53	111.76	910474.0
2015-12-28 11:30:00	QQQ	ETF	111.759	112.07	111.705	111.95	919960.0
2015-12-28 12:00:00	QQQ	ETF	111.95	112.06	111.82	111.98	796691.0
2015-12-28 12:30:00	QQQ	ETF	111.985	112.06	111.895	111.98	417208.0
2015-12-28 13:00:00	QQQ	ETF	111.971	112.32	111.97	112.25	727923.0
2015-12-28 13:30:00	QQQ	ETF	112.251	112.42	112.1585	112.18	852728.0
2015-12-28 14:00:00	QQQ	ETF	112.18	112.38	112.17	112.36	641418.0

> showing 50 of 13,177 rows — these rows as CSV

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