PREVIEW / etf_30min / 2015-06-03

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-03.parquet
  size:    380 KB
  rows:    12,735

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-03 04:00:00	SPY	ETF	211.64	211.8	211.57	211.66	3686.0
2015-06-03 04:30:00	SPY	ETF	211.57	211.61	211.39	211.5	6500.0
2015-06-03 05:00:00	SPY	ETF	211.58	211.61	211.52	211.61	1580.0
2015-06-03 05:30:00	SPY	ETF	211.6	211.61	211.47	211.61	26240.0
2015-06-03 06:00:00	SPY	ETF	211.66	211.7	211.62	211.69	5060.0
2015-06-03 06:30:00	SPY	ETF	211.7	211.95	211.69	211.86	56870.0
2015-06-03 07:00:00	SPY	ETF	211.74	212.38	211.74	212.27	391439.0
2015-06-03 07:30:00	SPY	ETF	212.27	212.56	212.17	212.43	419668.0
2015-06-03 08:00:00	SPY	ETF	211.67	212.5	211.67	212.21	564347.0
2015-06-03 08:30:00	SPY	ETF	212.25	212.32	211.94	212.01	458278.0
2015-06-03 09:00:00	SPY	ETF	212.02	212.06	211.78	211.98	885169.0
2015-06-03 09:30:00	SPY	ETF	212.0	212.16	211.3301	211.96	11367197.0
2015-06-03 10:00:00	SPY	ETF	211.95	212.54	211.571	212.4734	9492232.0
2015-06-03 10:30:00	SPY	ETF	212.48	212.67	212.35	212.55	4854024.0
2015-06-03 11:00:00	SPY	ETF	212.54	212.63	212.22	212.28	4507148.0
2015-06-03 11:30:00	SPY	ETF	212.28	212.4	211.69	211.91	7137728.0
2015-06-03 12:00:00	SPY	ETF	211.91	211.97	211.51	211.6908	5565708.0
2015-06-03 12:30:00	SPY	ETF	211.69	211.85	211.5	211.822	5355158.0
2015-06-03 13:00:00	SPY	ETF	211.83	211.96	211.75	211.86	3757898.0
2015-06-03 13:30:00	SPY	ETF	211.85	211.94	211.68	211.895	2179607.0
2015-06-03 14:00:00	SPY	ETF	211.9	212.25	211.895	212.18	5354034.0
2015-06-03 14:30:00	SPY	ETF	212.19	212.23	211.93	211.98	2537914.0
2015-06-03 15:00:00	SPY	ETF	211.98	212.1	211.74	211.84	7349099.0
2015-06-03 15:30:00	SPY	ETF	211.84	212.03	211.78	211.93	8637140.0
2015-06-03 16:00:00	SPY	ETF	211.93	212.25	211.8549	212.22	5131996.0
2015-06-03 16:30:00	SPY	ETF	212.22	212.24	212.16	212.17	1202798.0
2015-06-03 17:00:00	SPY	ETF	212.2	212.23	212.17	212.2	57607.0
2015-06-03 17:30:00	SPY	ETF	212.2	212.22	212.2	212.22	26440.0
2015-06-03 18:00:00	SPY	ETF	212.2	212.2	212.13	212.14	31214.0
2015-06-03 18:30:00	SPY	ETF	212.14	212.16	212.14	212.14	4535.0
2015-06-03 19:00:00	SPY	ETF	212.18	212.2	212.15	212.17	2960.0
2015-06-03 19:30:00	SPY	ETF	212.17	212.18	212.14	212.18	52653.0
2015-06-03 04:00:00	QQQ	ETF	110.15	110.25	110.15	110.25	700.0
2015-06-03 05:30:00	QQQ	ETF	110.11	110.11	110.11	110.11	500.0
2015-06-03 06:00:00	QQQ	ETF	110.23	110.23	110.23	110.23	6500.0
2015-06-03 06:30:00	QQQ	ETF	110.24	110.31	110.23	110.28	22900.0
2015-06-03 07:00:00	QQQ	ETF	110.29	110.62	110.27	110.61	38250.0
2015-06-03 07:30:00	QQQ	ETF	110.6	110.84	110.58	110.75	196227.0
2015-06-03 08:00:00	QQQ	ETF	110.74	110.82	110.47	110.7	163427.0
2015-06-03 08:30:00	QQQ	ETF	110.73	110.75	110.61	110.64	77949.0
2015-06-03 09:00:00	QQQ	ETF	110.63	110.66	110.51	110.58	146733.0
2015-06-03 09:30:00	QQQ	ETF	110.57	110.7	110.19	110.51	3447073.0
2015-06-03 10:00:00	QQQ	ETF	110.525	110.81	110.3	110.7365	2555046.0
2015-06-03 10:30:00	QQQ	ETF	110.75	110.8	110.65	110.7499	1329184.0
2015-06-03 11:00:00	QQQ	ETF	110.74	110.79	110.515	110.545	1125926.0
2015-06-03 11:30:00	QQQ	ETF	110.545	110.65	110.28	110.41	1301292.0
2015-06-03 12:00:00	QQQ	ETF	110.4	110.45	110.18	110.2749	1190095.0
2015-06-03 12:30:00	QQQ	ETF	110.27	110.33	110.13	110.32	796169.0
2015-06-03 13:00:00	QQQ	ETF	110.3	110.4	110.26	110.3432	916886.0
2015-06-03 13:30:00	QQQ	ETF	110.34	110.42	110.24	110.38	1019083.0

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

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