PREVIEW / etf_30min / 2015-11-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-06.parquet
  size:    392 KB
  rows:    13,315

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-11-06 04:00:00	SPY	ETF	210.0	210.02	209.95	209.96	650.0
2015-11-06 04:30:00	SPY	ETF	209.97	209.97	209.97	209.97	110.0
2015-11-06 05:30:00	SPY	ETF	209.96	210.01	209.93	210.01	3510.0
2015-11-06 06:00:00	SPY	ETF	209.96	209.96	209.9	209.94	32300.0
2015-11-06 06:30:00	SPY	ETF	209.91	209.99	209.9	209.99	7788.0
2015-11-06 07:00:00	SPY	ETF	209.96	210.17	209.96	209.96	24022.0
2015-11-06 07:30:00	SPY	ETF	210.0	210.32	209.98	210.23	112327.0
2015-11-06 08:00:00	SPY	ETF	210.26	210.46	210.09	210.18	643417.0
2015-11-06 08:30:00	SPY	ETF	210.16	210.54	208.91	209.25	5913647.0
2015-11-06 09:00:00	SPY	ETF	209.27	209.81	209.06	209.74	1764855.0
2015-11-06 09:30:00	SPY	ETF	209.74	210.32	209.03	209.14	15195098.0
2015-11-06 10:00:00	SPY	ETF	209.145	209.18	208.46	209.01	14840049.0
2015-11-06 10:30:00	SPY	ETF	209.01	209.86	208.92	209.4301	10118419.0
2015-11-06 11:00:00	SPY	ETF	209.43	209.53	208.83	209.01	5318648.0
2015-11-06 11:30:00	SPY	ETF	209.01	209.5	209.0	209.2	3870724.0
2015-11-06 12:00:00	SPY	ETF	209.19	209.45	208.85	208.98	3841222.0
2015-11-06 12:30:00	SPY	ETF	208.975	209.14	208.74	209.111	2920011.0
2015-11-06 13:00:00	SPY	ETF	209.11	209.5	209.03	209.32	3979954.0
2015-11-06 13:30:00	SPY	ETF	209.325	209.75	209.14	209.67	3792872.0
2015-11-06 14:00:00	SPY	ETF	209.675	210.07	209.45	209.62	7294228.0
2015-11-06 14:30:00	SPY	ETF	209.61	209.69	209.16	209.49	4921822.0
2015-11-06 15:00:00	SPY	ETF	209.491	209.72	209.44	209.65	4054164.0
2015-11-06 15:30:00	SPY	ETF	209.66	210.07	209.61	210.02	11539333.0
2015-11-06 16:00:00	SPY	ETF	210.02	210.06	209.91	210.06	7594468.0
2015-11-06 16:30:00	SPY	ETF	210.05	210.07	209.99	210.01	713404.0
2015-11-06 17:00:00	SPY	ETF	210.02	210.08	209.99	210.06	1117655.0
2015-11-06 17:30:00	SPY	ETF	210.08	210.1	210.03	210.03	55545.0
2015-11-06 18:00:00	SPY	ETF	210.08	210.1	210.06	210.06	2113.0
2015-11-06 18:30:00	SPY	ETF	210.1	210.12	210.05	210.1	26515.0
2015-11-06 19:00:00	SPY	ETF	210.06	210.12	210.05	210.05	25049.0
2015-11-06 19:30:00	SPY	ETF	210.06	210.12	210.06	210.11	8852.0
2015-11-06 04:00:00	QQQ	ETF	114.71	114.71	114.66	114.69	600.0
2015-11-06 06:00:00	QQQ	ETF	114.69	114.69	114.69	114.69	1226.0
2015-11-06 07:00:00	QQQ	ETF	114.66	114.76	114.66	114.75	600.0
2015-11-06 07:30:00	QQQ	ETF	114.75	114.79	114.75	114.79	6950.0
2015-11-06 08:00:00	QQQ	ETF	114.8265	114.94	114.79	114.84	28888.0
2015-11-06 08:30:00	QQQ	ETF	114.78	114.95	114.1	114.26	555526.0
2015-11-06 09:00:00	QQQ	ETF	114.28	114.65	114.16	114.5	572795.0
2015-11-06 09:30:00	QQQ	ETF	114.49	114.87	114.17	114.24	4455145.0
2015-11-06 10:00:00	QQQ	ETF	114.24	114.38	113.76	114.38	3410027.0
2015-11-06 10:30:00	QQQ	ETF	114.38	114.92	114.331	114.694	2748777.0
2015-11-06 11:00:00	QQQ	ETF	114.69	114.75	114.35	114.45	1755207.0
2015-11-06 11:30:00	QQQ	ETF	114.45	114.75	114.4455	114.59	1787828.0
2015-11-06 12:00:00	QQQ	ETF	114.59	114.69	114.3	114.39	988298.0
2015-11-06 12:30:00	QQQ	ETF	114.38	114.47	114.21	114.43	755009.0
2015-11-06 13:00:00	QQQ	ETF	114.44	114.605	114.38	114.45	792587.0
2015-11-06 13:30:00	QQQ	ETF	114.46	114.68	114.29	114.64	1275424.0
2015-11-06 14:00:00	QQQ	ETF	114.65	114.81	114.45	114.53	1556624.0
2015-11-06 14:30:00	QQQ	ETF	114.52	114.56	114.31	114.511	1256367.0
2015-11-06 15:00:00	QQQ	ETF	114.515	114.62	114.49	114.58	1299442.0

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

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