PREVIEW / etf_30min / 2015-06-08

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-08.parquet
  size:    370 KB
  rows:    12,514

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-06-08 04:00:00	SPY	ETF	209.79	209.9	209.49	209.66	14995.0
2015-06-08 04:30:00	SPY	ETF	209.63	209.93	209.63	209.93	15649.0
2015-06-08 05:00:00	SPY	ETF	209.91	209.91	209.62	209.78	4444.0
2015-06-08 05:30:00	SPY	ETF	209.69	209.79	209.68	209.68	700.0
2015-06-08 06:00:00	SPY	ETF	209.63	209.63	209.54	209.58	32513.0
2015-06-08 06:30:00	SPY	ETF	209.62	209.64	209.47	209.62	9099.0
2015-06-08 07:00:00	SPY	ETF	209.7	209.76	209.52	209.62	50802.0
2015-06-08 07:30:00	SPY	ETF	209.56	209.7	209.56	209.63	72319.0
2015-06-08 08:00:00	SPY	ETF	209.63	209.92	209.55	209.75	155248.0
2015-06-08 08:30:00	SPY	ETF	209.77	209.83	209.45	209.5	167508.0
2015-06-08 09:00:00	SPY	ETF	209.49	209.65	209.38	209.64	602832.0
2015-06-08 09:30:00	SPY	ETF	209.64	209.82	209.17	209.33	10622084.0
2015-06-08 10:00:00	SPY	ETF	209.33	209.49	209.15	209.385	6419536.0
2015-06-08 10:30:00	SPY	ETF	209.38	209.51	209.2	209.23	4387769.0
2015-06-08 11:00:00	SPY	ETF	209.23	209.47	209.12	209.1595	4617769.0
2015-06-08 11:30:00	SPY	ETF	209.15	209.26	208.96	209.04	5514045.0
2015-06-08 12:00:00	SPY	ETF	209.035	209.16	208.99	209.09	2628208.0
2015-06-08 12:30:00	SPY	ETF	209.09	209.19	208.77	208.78	4112398.0
2015-06-08 13:00:00	SPY	ETF	208.78	208.88	208.69	208.69	3052110.0
2015-06-08 13:30:00	SPY	ETF	208.69	208.81	208.42	208.69	6278476.0
2015-06-08 14:00:00	SPY	ETF	208.7	208.77	208.47	208.77	3206713.0
2015-06-08 14:30:00	SPY	ETF	208.77	209.26	208.765	209.13	7669838.0
2015-06-08 15:00:00	SPY	ETF	209.12	209.15	208.74	208.875	5034360.0
2015-06-08 15:30:00	SPY	ETF	208.87	208.95	208.39	208.47	13214317.0
2015-06-08 16:00:00	SPY	ETF	208.47	209.3201	208.27	208.52	3986920.0
2015-06-08 16:30:00	SPY	ETF	208.52	208.63	208.48	208.63	2492201.0
2015-06-08 17:00:00	SPY	ETF	208.62	208.65	208.48	208.64	718714.0
2015-06-08 17:30:00	SPY	ETF	208.64	208.65	208.6	208.65	77748.0
2015-06-08 18:00:00	SPY	ETF	208.65	208.75	208.63	208.63	88293.0
2015-06-08 18:30:00	SPY	ETF	208.67	208.7	208.62	208.67	29257.0
2015-06-08 19:00:00	SPY	ETF	208.68	208.72	208.66	208.68	5552.0
2015-06-08 19:30:00	SPY	ETF	208.68	208.75	208.66	208.68	21819.0
2015-06-08 04:00:00	QQQ	ETF	109.36	109.36	109.36	109.36	200.0
2015-06-08 05:30:00	QQQ	ETF	109.23	109.28	109.23	109.28	729.0
2015-06-08 06:30:00	QQQ	ETF	109.28	109.28	109.23	109.23	907.0
2015-06-08 07:00:00	QQQ	ETF	109.32	109.33	109.27	109.3	8900.0
2015-06-08 07:30:00	QQQ	ETF	109.32	109.34	109.28	109.28	1200.0
2015-06-08 08:00:00	QQQ	ETF	109.3	109.361	109.29	109.36	14900.0
2015-06-08 08:30:00	QQQ	ETF	109.38	109.4	109.22	109.22	8681.0
2015-06-08 09:00:00	QQQ	ETF	109.2	109.28	109.16	109.24	69230.0
2015-06-08 09:30:00	QQQ	ETF	109.25	109.33	108.84	108.91	2310631.0
2015-06-08 10:00:00	QQQ	ETF	108.9	108.98	108.76	108.89	1517858.0
2015-06-08 10:30:00	QQQ	ETF	108.89	109.01	108.73	108.7772	1623840.0
2015-06-08 11:00:00	QQQ	ETF	108.78	108.94	108.69	108.72	2045547.0
2015-06-08 11:30:00	QQQ	ETF	108.72	108.75	108.55	108.56	1180646.0
2015-06-08 12:00:00	QQQ	ETF	108.57	108.64	108.48	108.5524	551320.0
2015-06-08 12:30:00	QQQ	ETF	108.55	108.59	108.22	108.23	925190.0
2015-06-08 13:00:00	QQQ	ETF	108.23	108.296	108.1	108.1	1138646.0
2015-06-08 13:30:00	QQQ	ETF	108.1	108.17	107.97	108.13	1656395.0
2015-06-08 14:00:00	QQQ	ETF	108.13	108.22	107.98	108.22	1426746.0

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

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