PREVIEW / etf_30min / 2015-12-30

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-30.parquet
  size:    395 KB
  rows:    13,409

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-30 04:00:00	SPY	ETF	207.28	207.38	207.15	207.16	9099.0
2015-12-30 04:30:00	SPY	ETF	207.18	207.28	207.18	207.28	3300.0
2015-12-30 05:30:00	SPY	ETF	207.38	207.39	207.33	207.33	602.0
2015-12-30 06:00:00	SPY	ETF	207.3	207.32	207.28	207.32	311.0
2015-12-30 06:30:00	SPY	ETF	207.35	207.39	207.29	207.39	8904.0
2015-12-30 07:00:00	SPY	ETF	207.4	207.44	207.15	207.21	96237.0
2015-12-30 07:30:00	SPY	ETF	207.21	207.29	207.14	207.17	83712.0
2015-12-30 08:00:00	SPY	ETF	207.19	207.32	207.07	207.14	102864.0
2015-12-30 08:30:00	SPY	ETF	207.15	207.18	207.04	207.09	138661.0
2015-12-30 09:00:00	SPY	ETF	207.09	207.22	207.04	207.11	409766.0
2015-12-30 09:30:00	SPY	ETF	207.11	207.21	206.72	206.895	5280219.0
2015-12-30 10:00:00	SPY	ETF	206.89	207.1	206.58	206.6	4512793.0
2015-12-30 10:30:00	SPY	ETF	206.59	206.92	206.51	206.79	4317802.0
2015-12-30 11:00:00	SPY	ETF	206.8	207.02	206.7	206.9499	4569698.0
2015-12-30 11:30:00	SPY	ETF	206.95	206.96	206.68	206.76	2447926.0
2015-12-30 12:00:00	SPY	ETF	206.76	206.89	206.69	206.7751	2629526.0
2015-12-30 12:30:00	SPY	ETF	206.77	206.79	206.59	206.675	1855047.0
2015-12-30 13:00:00	SPY	ETF	206.675	206.79	206.52	206.6499	3124135.0
2015-12-30 13:30:00	SPY	ETF	206.645	206.91	206.64	206.8069	2222629.0
2015-12-30 14:00:00	SPY	ETF	206.8001	206.92	206.72	206.76	3746627.0
2015-12-30 14:30:00	SPY	ETF	206.77	206.83	206.59	206.6439	2347331.0
2015-12-30 15:00:00	SPY	ETF	206.64	206.75	206.56	206.59	4478052.0
2015-12-30 15:30:00	SPY	ETF	206.59	206.595	205.76	205.94	14917219.0
2015-12-30 16:00:00	SPY	ETF	205.94	207.4498	205.78	205.78	3750826.0
2015-12-30 16:30:00	SPY	ETF	205.8	207.4498	205.79	205.97	1376373.0
2015-12-30 17:00:00	SPY	ETF	205.92	206.02	205.92	206.0	5393.0
2015-12-30 17:30:00	SPY	ETF	206.01	206.05	205.93	205.93	14464.0
2015-12-30 18:00:00	SPY	ETF	205.97	206.03	205.9	206.03	19581.0
2015-12-30 18:30:00	SPY	ETF	206.03	206.1	206.02	206.05	21520.0
2015-12-30 19:00:00	SPY	ETF	206.09	206.11	206.04	206.04	14700.0
2015-12-30 19:30:00	SPY	ETF	206.09	206.14	206.06	206.06	16342.0
2015-12-30 04:00:00	QQQ	ETF	114.1	114.22	114.1	114.15	2800.0
2015-12-30 05:30:00	QQQ	ETF	114.24	114.24	114.22	114.22	300.0
2015-12-30 06:00:00	QQQ	ETF	114.28	114.3	114.28	114.3	700.0
2015-12-30 06:30:00	QQQ	ETF	114.26	114.26	114.26	114.26	200.0
2015-12-30 07:00:00	QQQ	ETF	114.29	114.29	114.15	114.19	10967.0
2015-12-30 07:30:00	QQQ	ETF	114.18	114.19	114.17	114.19	1200.0
2015-12-30 08:00:00	QQQ	ETF	114.2001	114.2001	114.13	114.17	28554.0
2015-12-30 08:30:00	QQQ	ETF	114.18	114.18	114.12	114.14	18298.0
2015-12-30 09:00:00	QQQ	ETF	114.18	114.22	114.14	114.16	45438.0
2015-12-30 09:30:00	QQQ	ETF	114.16	114.24	113.67	113.72	2290882.0
2015-12-30 10:00:00	QQQ	ETF	113.71	113.91	113.5701	113.61	1590770.0
2015-12-30 10:30:00	QQQ	ETF	113.6	113.88	113.57	113.77	1153231.0
2015-12-30 11:00:00	QQQ	ETF	113.7722	113.905	113.64	113.81	698769.0
2015-12-30 11:30:00	QQQ	ETF	113.8	113.81	113.69	113.76	686632.0
2015-12-30 12:00:00	QQQ	ETF	113.76	113.86	113.75	113.848	426875.0
2015-12-30 12:30:00	QQQ	ETF	113.84	113.84	113.71	113.76	363958.0
2015-12-30 13:00:00	QQQ	ETF	113.76	113.81	113.68	113.77	498758.0
2015-12-30 13:30:00	QQQ	ETF	113.765	113.96	113.75	113.85	640642.0
2015-12-30 14:00:00	QQQ	ETF	113.855	113.91	113.73	113.7714	626131.0

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

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