PREVIEW / etf_30min / 2015-12-07

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-07.parquet
  size:    389 KB
  rows:    13,026

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-07 04:00:00	SPY	ETF	209.9	210.2	209.86	209.86	34739.0
2015-12-07 04:30:00	SPY	ETF	209.91	210.25	209.91	210.06	15724.0
2015-12-07 05:00:00	SPY	ETF	209.95	210.0	209.91	209.91	4520.0
2015-12-07 05:30:00	SPY	ETF	209.98	210.08	209.98	210.04	1520.0
2015-12-07 06:00:00	SPY	ETF	209.95	210.03	209.83	209.83	17530.0
2015-12-07 06:30:00	SPY	ETF	209.85	210.04	209.78	209.95	25617.0
2015-12-07 07:00:00	SPY	ETF	210.0	210.15	209.94	210.03	80755.0
2015-12-07 07:30:00	SPY	ETF	210.07	210.1	209.85	209.87	118094.0
2015-12-07 08:00:00	SPY	ETF	210.0	210.08	209.33	209.35	322015.0
2015-12-07 08:30:00	SPY	ETF	209.36	209.42	209.08	209.16	666983.0
2015-12-07 09:00:00	SPY	ETF	209.15	209.32	209.11	209.21	530829.0
2015-12-07 09:30:00	SPY	ETF	209.23	209.25	208.575	208.6445	15040195.0
2015-12-07 10:00:00	SPY	ETF	208.64	208.68	208.14	208.27	8283998.0
2015-12-07 10:30:00	SPY	ETF	208.26	208.5222	207.5	207.8002	11575317.0
2015-12-07 11:00:00	SPY	ETF	207.8	209.7295	207.2	207.31	7655036.0
2015-12-07 11:30:00	SPY	ETF	207.31	209.7295	207.26	208.08	6268283.0
2015-12-07 12:00:00	SPY	ETF	208.08	208.11	207.78	207.875	4232622.0
2015-12-07 12:30:00	SPY	ETF	207.88	207.89	207.32	207.4799	4412790.0
2015-12-07 13:00:00	SPY	ETF	207.48	209.7295	207.285	207.89	5381753.0
2015-12-07 13:30:00	SPY	ETF	207.89	207.915	207.41	207.84	3774245.0
2015-12-07 14:00:00	SPY	ETF	207.835	208.19	207.71	208.0	4416701.0
2015-12-07 14:30:00	SPY	ETF	208.0	208.17	207.55	207.575	4190306.0
2015-12-07 15:00:00	SPY	ETF	207.58	209.7295	207.34	207.89	5273377.0
2015-12-07 15:30:00	SPY	ETF	207.885	208.508	207.75	208.29	13621720.0
2015-12-07 16:00:00	SPY	ETF	208.29	208.88	208.27	208.86	4757912.0
2015-12-07 16:30:00	SPY	ETF	208.88	208.92	208.79	208.85	315703.0
2015-12-07 17:00:00	SPY	ETF	208.81	208.83	208.74	208.77	78292.0
2015-12-07 17:30:00	SPY	ETF	208.76	208.85	208.71	208.71	93740.0
2015-12-07 18:00:00	SPY	ETF	208.71	208.85	208.71	208.72	127238.0
2015-12-07 18:30:00	SPY	ETF	208.72	208.72	208.6	208.6	66225.0
2015-12-07 19:00:00	SPY	ETF	208.6	208.62	208.52	208.53	39595.0
2015-12-07 19:30:00	SPY	ETF	208.54	208.57	208.48	208.52	40261.0
2015-12-07 05:00:00	QQQ	ETF	115.33	115.33	115.33	115.33	500.0
2015-12-07 06:30:00	QQQ	ETF	115.32	115.32	115.32	115.32	300.0
2015-12-07 07:00:00	QQQ	ETF	115.33	115.45	115.33	115.42	6825.0
2015-12-07 07:30:00	QQQ	ETF	115.41	115.42	115.37	115.38	32885.0
2015-12-07 08:00:00	QQQ	ETF	115.31	115.39	115.15	115.18	51264.0
2015-12-07 08:30:00	QQQ	ETF	115.15	115.19	115.05	115.1	96752.0
2015-12-07 09:00:00	QQQ	ETF	115.1	115.22	115.07	115.22	157038.0
2015-12-07 09:30:00	QQQ	ETF	115.22	115.29	114.64	114.82	3791691.0
2015-12-07 10:00:00	QQQ	ETF	114.82	114.89	114.54	114.67	2392080.0
2015-12-07 10:30:00	QQQ	ETF	114.67	114.68	114.28	114.43	1950857.0
2015-12-07 11:00:00	QQQ	ETF	114.43	114.51	114.09	114.13	1712476.0
2015-12-07 11:30:00	QQQ	ETF	114.13	114.65	114.11	114.58	1895056.0
2015-12-07 12:00:00	QQQ	ETF	114.57	114.59	114.4199	114.485	749429.0
2015-12-07 12:30:00	QQQ	ETF	114.47	115.1688	114.14	114.165	1358444.0
2015-12-07 13:00:00	QQQ	ETF	114.175	114.475	114.07	114.46	1296880.0
2015-12-07 13:30:00	QQQ	ETF	114.46	114.49	114.2	114.435	1500717.0
2015-12-07 14:00:00	QQQ	ETF	114.44	114.684	114.3325	114.51	1340720.0
2015-12-07 14:30:00	QQQ	ETF	114.52	114.62	114.199	114.21	998299.0

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

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