PREVIEW / etf_30min / 2015-04-29

all etf 30-min files

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

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-29 04:00:00	SPY	ETF	211.56	211.6	211.53	211.6	925.0
2015-04-29 04:30:00	SPY	ETF	211.71	211.71	211.58	211.69	800.0
2015-04-29 05:00:00	SPY	ETF	211.54	211.54	211.49	211.49	1200.0
2015-04-29 05:30:00	SPY	ETF	211.54	211.57	211.46	211.47	8600.0
2015-04-29 06:00:00	SPY	ETF	211.49	211.49	211.44	211.45	7965.0
2015-04-29 06:30:00	SPY	ETF	211.43	211.55	211.43	211.43	30450.0
2015-04-29 07:00:00	SPY	ETF	211.44	211.5	211.13	211.15	189446.0
2015-04-29 07:30:00	SPY	ETF	211.16	211.37	211.13	211.24	144672.0
2015-04-29 08:00:00	SPY	ETF	211.24	211.42	210.85	211.0	773734.0
2015-04-29 08:30:00	SPY	ETF	211.0	211.09	210.28	210.42	1742919.0
2015-04-29 09:00:00	SPY	ETF	210.42	210.53	210.04	210.35	1328699.0
2015-04-29 09:30:00	SPY	ETF	210.37	211.21	210.32	210.82	11466733.0
2015-04-29 10:00:00	SPY	ETF	210.822	210.98	210.1	210.25	10805945.0
2015-04-29 10:30:00	SPY	ETF	210.25	210.77	210.22	210.56	9841711.0
2015-04-29 11:00:00	SPY	ETF	210.57	210.95	210.5249	210.64	8544782.0
2015-04-29 11:30:00	SPY	ETF	210.63	210.69	210.31	210.46	7705318.0
2015-04-29 12:00:00	SPY	ETF	210.46	210.52	209.72	209.8	8064174.0
2015-04-29 12:30:00	SPY	ETF	209.81	210.24	209.6	210.14	5052141.0
2015-04-29 13:00:00	SPY	ETF	210.15	210.19	209.78	209.925	3845927.0
2015-04-29 13:30:00	SPY	ETF	209.93	210.72	209.925	210.58	7274772.0
2015-04-29 14:00:00	SPY	ETF	210.57	211.0	210.07	210.89	14408431.0
2015-04-29 14:30:00	SPY	ETF	210.88	211.29	210.74	210.83	7760214.0
2015-04-29 15:00:00	SPY	ETF	210.84	210.96	210.28	210.61	7676514.0
2015-04-29 15:30:00	SPY	ETF	210.61	210.97	210.42	210.55	10908582.0
2015-04-29 16:00:00	SPY	ETF	210.56	211.3661	210.29	210.38	6073907.0
2015-04-29 16:30:00	SPY	ETF	210.36	210.46	210.29	210.38	323426.0
2015-04-29 17:00:00	SPY	ETF	210.37	210.39	210.33	210.39	155883.0
2015-04-29 17:30:00	SPY	ETF	210.37	210.39	210.37	210.37	410.0
2015-04-29 18:00:00	SPY	ETF	210.36	210.45	210.31	210.31	38416.0
2015-04-29 18:30:00	SPY	ETF	210.31	210.35	210.28	210.31	42065.0
2015-04-29 19:00:00	SPY	ETF	210.3	210.32	210.28	210.28	9250.0
2015-04-29 19:30:00	SPY	ETF	210.31	210.34	210.22	210.25	27739.0
2015-04-29 06:30:00	QQQ	ETF	109.95	109.98	109.95	109.96	4900.0
2015-04-29 07:00:00	QQQ	ETF	109.94	109.94	109.8	109.81	14690.0
2015-04-29 07:30:00	QQQ	ETF	109.82	109.92	109.82	109.89	5400.0
2015-04-29 08:00:00	QQQ	ETF	109.89	109.89	109.61	109.88	84108.0
2015-04-29 08:30:00	QQQ	ETF	109.72	109.92	109.48	109.53	377269.0
2015-04-29 09:00:00	QQQ	ETF	109.53	109.6	109.29	109.42	321952.0
2015-04-29 09:30:00	QQQ	ETF	109.43	110.07	109.41	109.81	3545560.0
2015-04-29 10:00:00	QQQ	ETF	109.82	109.91	109.35	109.44	3678317.0
2015-04-29 10:30:00	QQQ	ETF	109.44	109.73	109.41	109.5	1980924.0
2015-04-29 11:00:00	QQQ	ETF	109.5	109.75	109.48	109.53	1309186.0
2015-04-29 11:30:00	QQQ	ETF	109.53	109.56	109.35	109.395	1586658.0
2015-04-29 12:00:00	QQQ	ETF	109.4	109.43	108.88	108.93	2778073.0
2015-04-29 12:30:00	QQQ	ETF	108.93	109.1162	108.75	109.06	2375807.0
2015-04-29 13:00:00	QQQ	ETF	109.06	109.13	108.88	108.97	971300.0
2015-04-29 13:30:00	QQQ	ETF	108.98	109.51	108.98	109.4372	1431997.0
2015-04-29 14:00:00	QQQ	ETF	109.44	109.61	109.05	109.55	3360161.0
2015-04-29 14:30:00	QQQ	ETF	109.57	109.83	109.46	109.62	2743475.0
2015-04-29 15:00:00	QQQ	ETF	109.6201	109.68	109.275	109.42	1425881.0

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

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