PREVIEW / etf_30min / 2015-09-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-23.parquet
  size:    371 KB
  rows:    12,530

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-09-23 04:00:00	SPY	ETF	193.58	193.83	193.5	193.7	13050.0
2015-09-23 04:30:00	SPY	ETF	193.81	194.65	193.81	194.4	70836.0
2015-09-23 05:00:00	SPY	ETF	194.43	194.49	194.2	194.25	4515.0
2015-09-23 05:30:00	SPY	ETF	194.22	194.57	194.22	194.44	31547.0
2015-09-23 06:00:00	SPY	ETF	194.33	194.37	194.05	194.1	10669.0
2015-09-23 06:30:00	SPY	ETF	194.15	194.5	194.15	194.49	18438.0
2015-09-23 07:00:00	SPY	ETF	194.53	194.97	194.48	194.75	128959.0
2015-09-23 07:30:00	SPY	ETF	194.76	194.77	193.91	194.14	343413.0
2015-09-23 08:00:00	SPY	ETF	194.14	194.97	192.22	194.53	590540.0
2015-09-23 08:30:00	SPY	ETF	194.46	194.58	194.23	194.24	351430.0
2015-09-23 09:00:00	SPY	ETF	194.23	194.4	193.55	194.13	852627.0
2015-09-23 09:30:00	SPY	ETF	194.11	194.25	193.43	193.83	9620966.0
2015-09-23 10:00:00	SPY	ETF	193.82	194.365	193.76	194.24	5314401.0
2015-09-23 10:30:00	SPY	ETF	194.27	194.67	194.12	194.43	5359143.0
2015-09-23 11:00:00	SPY	ETF	194.435	194.48	193.53	193.62	8651334.0
2015-09-23 11:30:00	SPY	ETF	193.62	193.64	193.05	193.27	7743133.0
2015-09-23 12:00:00	SPY	ETF	193.27	193.29	192.91	193.16	6614949.0
2015-09-23 12:30:00	SPY	ETF	193.16	193.4	193.06	193.33	3114684.0
2015-09-23 13:00:00	SPY	ETF	193.33	193.685	193.11	193.15	3944389.0
2015-09-23 13:30:00	SPY	ETF	193.155	194.03	193.155	193.795	6105696.0
2015-09-23 14:00:00	SPY	ETF	193.79	194.255	193.71	193.76	5183922.0
2015-09-23 14:30:00	SPY	ETF	193.75	193.99	193.35	193.5575	4313505.0
2015-09-23 15:00:00	SPY	ETF	193.55	193.79	193.28	193.58	7294474.0
2015-09-23 15:30:00	SPY	ETF	193.58	193.9	193.37	193.57	10089502.0
2015-09-23 16:00:00	SPY	ETF	193.58	193.81	193.51	193.65	3049410.0
2015-09-23 16:30:00	SPY	ETF	193.65	193.96	193.5663	193.94	698715.0
2015-09-23 17:00:00	SPY	ETF	193.93	193.95	193.9	193.91	122060.0
2015-09-23 17:30:00	SPY	ETF	193.91	193.95	193.89	193.95	35994.0
2015-09-23 18:00:00	SPY	ETF	193.95	194.18	193.88	194.08	78360.0
2015-09-23 18:30:00	SPY	ETF	194.09	194.09	193.88	193.88	26474.0
2015-09-23 19:00:00	SPY	ETF	193.88	193.98	193.86	193.91	12617.0
2015-09-23 19:30:00	SPY	ETF	193.91	193.91	193.7	193.76	93521.0
2015-09-23 04:00:00	QQQ	ETF	104.14	104.29	104.14	104.29	25650.0
2015-09-23 04:30:00	QQQ	ETF	104.34	104.7	104.34	104.63	27500.0
2015-09-23 05:00:00	QQQ	ETF	104.6	104.62	104.46	104.48	21650.0
2015-09-23 05:30:00	QQQ	ETF	104.46	104.64	104.46	104.56	18900.0
2015-09-23 06:00:00	QQQ	ETF	104.56	104.56	104.42	104.42	3940.0
2015-09-23 06:30:00	QQQ	ETF	104.4	104.58	104.4	104.58	8750.0
2015-09-23 07:00:00	QQQ	ETF	104.6	104.86	104.6	104.73	55586.0
2015-09-23 07:30:00	QQQ	ETF	104.73	104.73	104.34	104.41	91308.0
2015-09-23 08:00:00	QQQ	ETF	104.44	104.71	104.37	104.66	114808.0
2015-09-23 08:30:00	QQQ	ETF	104.6	104.67	104.5	104.52	36664.0
2015-09-23 09:00:00	QQQ	ETF	104.5	104.56	104.13	104.41	244157.0
2015-09-23 09:30:00	QQQ	ETF	104.38	104.4	103.775	104.06	2933029.0
2015-09-23 10:00:00	QQQ	ETF	104.08	104.43	104.04	104.365	1783706.0
2015-09-23 10:30:00	QQQ	ETF	104.38	104.66	104.31	104.56	1300198.0
2015-09-23 11:00:00	QQQ	ETF	104.56	104.61	104.08	104.13	1500929.0
2015-09-23 11:30:00	QQQ	ETF	104.14	104.14	103.73	103.91	1368883.0
2015-09-23 12:00:00	QQQ	ETF	103.91	103.92	103.64	103.87	1129474.0
2015-09-23 12:30:00	QQQ	ETF	103.87	104.11	103.83	104.07	703497.0

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

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