PREVIEW / etf_30min / 2015-04-08

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-08.parquet
  size:    378 KB
  rows:    12,756

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-04-08 04:00:00	SPY	ETF	207.54	207.83	207.54	207.69	5400.0
2015-04-08 04:30:00	SPY	ETF	207.66	207.66	207.55	207.57	15354.0
2015-04-08 05:00:00	SPY	ETF	207.69	207.76	207.55	207.61	7794.0
2015-04-08 05:30:00	SPY	ETF	207.71	207.75	207.66	207.66	32700.0
2015-04-08 06:00:00	SPY	ETF	207.54	207.54	207.4	207.45	7300.0
2015-04-08 06:30:00	SPY	ETF	207.46	207.46	207.24	207.3	18572.0
2015-04-08 07:00:00	SPY	ETF	207.37	207.46	207.35	207.42	68425.0
2015-04-08 07:30:00	SPY	ETF	207.41	207.58	207.41	207.43	51016.0
2015-04-08 08:00:00	SPY	ETF	207.5	207.6	207.41	207.49	227223.0
2015-04-08 08:30:00	SPY	ETF	207.48	207.5	207.37	207.48	192664.0
2015-04-08 09:00:00	SPY	ETF	207.48	207.81	207.48	207.54	744607.0
2015-04-08 09:30:00	SPY	ETF	207.55	208.45	207.52	208.39	9192773.0
2015-04-08 10:00:00	SPY	ETF	208.38	208.51	208.025	208.185	5044878.0
2015-04-08 10:30:00	SPY	ETF	208.18	208.18	207.15	207.6	8819296.0
2015-04-08 11:00:00	SPY	ETF	207.59	208.01	207.45	207.85	4337282.0
2015-04-08 11:30:00	SPY	ETF	207.86	208.24	207.74	208.07	4347282.0
2015-04-08 12:00:00	SPY	ETF	208.08	208.13	207.87	207.88	2748287.0
2015-04-08 12:30:00	SPY	ETF	207.87	208.06	207.8	207.89	2620580.0
2015-04-08 13:00:00	SPY	ETF	207.9	208.03	207.64	207.84	2354260.0
2015-04-08 13:30:00	SPY	ETF	207.83	208.02	207.73	207.95	1782223.0
2015-04-08 14:00:00	SPY	ETF	207.95	208.45	207.08	208.07	14289586.0
2015-04-08 14:30:00	SPY	ETF	208.06	208.14	207.58	207.79	5422745.0
2015-04-08 15:00:00	SPY	ETF	207.79	207.97	207.6	207.79	6681151.0
2015-04-08 15:30:00	SPY	ETF	207.77	208.08	207.69	207.99	12487535.0
2015-04-08 16:00:00	SPY	ETF	207.99	208.13	207.7545	208.1	6947253.0
2015-04-08 16:30:00	SPY	ETF	208.08	208.18	208.02	208.15	136314.0
2015-04-08 17:00:00	SPY	ETF	208.17	208.34	208.16	208.3	123135.0
2015-04-08 17:30:00	SPY	ETF	208.32	208.33	208.28	208.3	17510.0
2015-04-08 18:00:00	SPY	ETF	208.3	208.3	208.18	208.19	56457.0
2015-04-08 18:30:00	SPY	ETF	208.2	208.23	208.2	208.2	5840.0
2015-04-08 19:00:00	SPY	ETF	208.2	208.2	208.19	208.19	1000.0
2015-04-08 19:30:00	SPY	ETF	208.18	208.18	208.16	208.17	17170.0
2015-04-08 04:00:00	QQQ	ETF	106.0	106.0	105.9	105.9	400.0
2015-04-08 07:00:00	QQQ	ETF	105.81	105.85	105.76	105.85	20861.0
2015-04-08 07:30:00	QQQ	ETF	105.86	105.96	105.86	105.9	151966.0
2015-04-08 08:00:00	QQQ	ETF	105.95	105.98	105.87	105.91	9717.0
2015-04-08 08:30:00	QQQ	ETF	105.9	105.9	105.85	105.9	17309.0
2015-04-08 09:00:00	QQQ	ETF	105.92	106.03	105.82	105.86	139102.0
2015-04-08 09:30:00	QQQ	ETF	105.84	106.61	105.83	106.58	3298097.0
2015-04-08 10:00:00	QQQ	ETF	106.59	106.65	106.375	106.46	1362967.0
2015-04-08 10:30:00	QQQ	ETF	106.46	106.47	105.95	106.235	2369033.0
2015-04-08 11:00:00	QQQ	ETF	106.235	106.51	106.14	106.45	2284312.0
2015-04-08 11:30:00	QQQ	ETF	106.46	106.64	106.4	106.551	1107968.0
2015-04-08 12:00:00	QQQ	ETF	106.56	106.62	106.49	106.51	565340.0
2015-04-08 12:30:00	QQQ	ETF	106.5	106.59	106.42	106.45	631180.0
2015-04-08 13:00:00	QQQ	ETF	106.45	106.53	106.31	106.44	634922.0
2015-04-08 13:30:00	QQQ	ETF	106.44	106.54	106.38	106.49	466656.0
2015-04-08 14:00:00	QQQ	ETF	106.48	106.79	106.01	106.57	3572975.0
2015-04-08 14:30:00	QQQ	ETF	106.58	106.63	106.26	106.39	1292788.0
2015-04-08 15:00:00	QQQ	ETF	106.39	106.53	106.28	106.37	977403.0

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

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