PREVIEW / etf_30min / 2015-05-18

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-18.parquet
  size:    373 KB
  rows:    12,651

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-05-18 04:00:00	SPY	ETF	212.3	212.31	212.25	212.28	52136.0
2015-05-18 04:30:00	SPY	ETF	212.2	212.46	212.2	212.45	7500.0
2015-05-18 05:00:00	SPY	ETF	212.51	212.51	212.4	212.4	210.0
2015-05-18 05:30:00	SPY	ETF	212.48	212.48	212.26	212.26	12859.0
2015-05-18 06:00:00	SPY	ETF	212.27	212.27	211.94	212.08	10752.0
2015-05-18 06:30:00	SPY	ETF	212.08	212.24	212.0	212.24	16689.0
2015-05-18 07:00:00	SPY	ETF	212.19	212.25	211.92	211.98	157534.0
2015-05-18 07:30:00	SPY	ETF	211.98	212.06	211.87	212.03	138710.0
2015-05-18 08:00:00	SPY	ETF	212.03	212.2	211.93	212.079	282960.0
2015-05-18 08:30:00	SPY	ETF	212.07	212.18	211.97	212.12	196589.0
2015-05-18 09:00:00	SPY	ETF	212.15	212.25	212.02	212.24	625701.0
2015-05-18 09:30:00	SPY	ETF	212.24	212.6	212.16	212.5499	8128620.0
2015-05-18 10:00:00	SPY	ETF	212.55	212.604	212.25	212.4	5933259.0
2015-05-18 10:30:00	SPY	ETF	212.41	212.585	212.32	212.425	6672055.0
2015-05-18 11:00:00	SPY	ETF	212.43	212.79	212.43	212.775	4843998.0
2015-05-18 11:30:00	SPY	ETF	212.78	212.99	212.775	212.898	4967516.0
2015-05-18 12:00:00	SPY	ETF	212.8901	212.99	212.561	212.88	2359361.0
2015-05-18 12:30:00	SPY	ETF	212.89	212.93	212.81	212.895	1547850.0
2015-05-18 13:00:00	SPY	ETF	212.89	213.01	212.885	212.97	2505829.0
2015-05-18 13:30:00	SPY	ETF	212.9657	213.2	212.96	213.14	2940859.0
2015-05-18 14:00:00	SPY	ETF	213.15	213.28	213.09	213.1282	4687678.0
2015-05-18 14:30:00	SPY	ETF	213.13	213.27	213.11	213.235	2302121.0
2015-05-18 15:00:00	SPY	ETF	213.235	213.4	213.23	213.27	4613591.0
2015-05-18 15:30:00	SPY	ETF	213.27	213.33	213.06	213.09	9565983.0
2015-05-18 16:00:00	SPY	ETF	213.08	213.21	212.81	213.21	4202055.0
2015-05-18 16:30:00	SPY	ETF	213.2	213.22	212.22	213.21	1446801.0
2015-05-18 17:00:00	SPY	ETF	213.2	213.22	213.18	213.19	170614.0
2015-05-18 17:30:00	SPY	ETF	213.2	213.24	213.2	213.23	22880.0
2015-05-18 18:00:00	SPY	ETF	213.22	213.22	213.18	213.21	64883.0
2015-05-18 18:30:00	SPY	ETF	213.19	213.24	213.19	213.21	7632.0
2015-05-18 19:00:00	SPY	ETF	213.2	213.21	213.16	213.17	21900.0
2015-05-18 19:30:00	SPY	ETF	213.19	213.25	213.17	213.25	53030.0
2015-05-18 04:00:00	QQQ	ETF	109.45	109.45	109.4	109.4	49100.0
2015-05-18 06:00:00	QQQ	ETF	109.38	109.39	109.24	109.3	12500.0
2015-05-18 06:30:00	QQQ	ETF	109.3	109.33	109.26	109.33	3800.0
2015-05-18 07:00:00	QQQ	ETF	109.38	109.38	109.22	109.23	91479.0
2015-05-18 07:30:00	QQQ	ETF	109.23	109.23	109.13	109.23	72320.0
2015-05-18 08:00:00	QQQ	ETF	109.24	109.31	109.23	109.25	33209.0
2015-05-18 08:30:00	QQQ	ETF	109.24	109.32	109.2	109.3	42407.0
2015-05-18 09:00:00	QQQ	ETF	109.3	109.39	109.25	109.38	85989.0
2015-05-18 09:30:00	QQQ	ETF	109.4	109.64	109.32	109.6	2349887.0
2015-05-18 10:00:00	QQQ	ETF	109.6	109.6801	109.42	109.5	1117360.0
2015-05-18 10:30:00	QQQ	ETF	109.51	109.62	109.43	109.475	948832.0
2015-05-18 11:00:00	QQQ	ETF	109.48	109.8173	109.48	109.81	1181499.0
2015-05-18 11:30:00	QQQ	ETF	109.81	109.98	109.81	109.89	1104816.0
2015-05-18 12:00:00	QQQ	ETF	109.8855	109.93	109.84	109.857	512134.0
2015-05-18 12:30:00	QQQ	ETF	109.8567	109.94	109.82	109.92	513965.0
2015-05-18 13:00:00	QQQ	ETF	109.92	110.0	109.915	109.98	801264.0
2015-05-18 13:30:00	QQQ	ETF	109.99	110.15	109.97	110.13	806588.0
2015-05-18 14:00:00	QQQ	ETF	110.12	110.22	110.07	110.07	646917.0

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

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