PREVIEW / etf_30min / 2015-04-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-23.parquet
  size:    383 KB
  rows:    12,742

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-23 04:00:00	SPY	ETF	210.35	210.55	209.6	209.67	21034.0
2015-04-23 04:30:00	SPY	ETF	209.55	209.55	209.28	209.5	3154.0
2015-04-23 05:00:00	SPY	ETF	209.85	210.21	209.78	210.15	60805.0
2015-04-23 05:30:00	SPY	ETF	210.08	210.31	209.95	210.17	27470.0
2015-04-23 06:00:00	SPY	ETF	210.06	210.14	209.95	209.99	11587.0
2015-04-23 06:30:00	SPY	ETF	209.97	209.97	209.85	209.95	25623.0
2015-04-23 07:00:00	SPY	ETF	209.99	210.12	209.87	210.12	41000.0
2015-04-23 07:30:00	SPY	ETF	210.02	210.03	209.71	209.94	150087.0
2015-04-23 08:00:00	SPY	ETF	209.93	210.18	209.84	209.99	254774.0
2015-04-23 08:30:00	SPY	ETF	210.0	210.05	209.86	209.98	353605.0
2015-04-23 09:00:00	SPY	ETF	209.99	210.25	209.95	210.15	573489.0
2015-04-23 09:30:00	SPY	ETF	210.15	210.65	210.01	210.62	8677027.0
2015-04-23 10:00:00	SPY	ETF	210.62	210.86	210.165	210.42	7087952.0
2015-04-23 10:30:00	SPY	ETF	210.42	210.64	210.31	210.32	4411592.0
2015-04-23 11:00:00	SPY	ETF	210.31	210.68	210.29	210.64	3670612.0
2015-04-23 11:30:00	SPY	ETF	210.64	211.4	210.52	211.22	8529457.0
2015-04-23 12:00:00	SPY	ETF	211.22	211.35	211.11	211.325	4261440.0
2015-04-23 12:30:00	SPY	ETF	211.32	211.78	211.23	211.735	6696588.0
2015-04-23 13:00:00	SPY	ETF	211.73	211.77	211.54	211.59	4329183.0
2015-04-23 13:30:00	SPY	ETF	211.59	211.68	211.45	211.65	4362381.0
2015-04-23 14:00:00	SPY	ETF	211.65	211.72	211.53	211.57	6512723.0
2015-04-23 14:30:00	SPY	ETF	211.57	211.61	211.41	211.57	3108389.0
2015-04-23 15:00:00	SPY	ETF	211.57	211.94	211.53	211.71	8022094.0
2015-04-23 15:30:00	SPY	ETF	211.71	211.71	211.16	211.18	14040151.0
2015-04-23 16:00:00	SPY	ETF	211.17	211.32	210.3825	211.24	6181491.0
2015-04-23 16:30:00	SPY	ETF	211.24	211.37	210.6574	211.25	2847287.0
2015-04-23 17:00:00	SPY	ETF	211.25	211.35	211.09	211.33	83841.0
2015-04-23 17:30:00	SPY	ETF	211.33	211.36	211.31	211.31	38352.0
2015-04-23 18:00:00	SPY	ETF	211.3	211.32	210.95	211.02	178795.0
2015-04-23 18:30:00	SPY	ETF	211.02	211.05	211.0	211.04	54682.0
2015-04-23 19:00:00	SPY	ETF	211.07	211.17	211.05	211.16	33538.0
2015-04-23 19:30:00	SPY	ETF	211.15	211.16	211.11	211.15	37816.0
2015-04-23 04:00:00	QQQ	ETF	108.02	108.04	108.01	108.04	21000.0
2015-04-23 04:30:00	QQQ	ETF	107.95	108.09	107.84	108.09	9400.0
2015-04-23 05:00:00	QQQ	ETF	108.14	108.34	108.11	108.31	15700.0
2015-04-23 05:30:00	QQQ	ETF	108.19	108.34	108.19	108.34	3700.0
2015-04-23 06:00:00	QQQ	ETF	108.31	108.31	108.22	108.22	2500.0
2015-04-23 06:30:00	QQQ	ETF	108.14	108.22	108.12	108.22	3899.0
2015-04-23 07:00:00	QQQ	ETF	108.24	108.28	108.13	108.27	24150.0
2015-04-23 07:30:00	QQQ	ETF	108.24	108.24	108.1	108.19	28047.0
2015-04-23 08:00:00	QQQ	ETF	108.13	108.36	108.13	108.29	151110.0
2015-04-23 08:30:00	QQQ	ETF	108.25	108.29	108.19	108.22	39183.0
2015-04-23 09:00:00	QQQ	ETF	108.23	108.36	108.23	108.28	113327.0
2015-04-23 09:30:00	QQQ	ETF	108.28	108.7	108.26	108.688	2772860.0
2015-04-23 10:00:00	QQQ	ETF	108.69	108.86	108.51	108.58	2931859.0
2015-04-23 10:30:00	QQQ	ETF	108.57	108.71	108.43	108.44	1239322.0
2015-04-23 11:00:00	QQQ	ETF	108.435	108.64	108.43	108.63	851076.0
2015-04-23 11:30:00	QQQ	ETF	108.62	109.0	108.56	108.905	2068813.0
2015-04-23 12:00:00	QQQ	ETF	108.9	109.02	108.8	109.02	1446555.0
2015-04-23 12:30:00	QQQ	ETF	109.01	109.23	108.95	109.22	1719073.0

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

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