PREVIEW / etf_30min / 2017-10-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-10.parquet
  size:    431 KB
  rows:    14,918

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
2017-10-10 04:00:00	SPY	ETF	254.25	254.25	254.15	254.17	900.0
2017-10-10 04:30:00	SPY	ETF	254.23	254.23	254.23	254.23	106.0
2017-10-10 05:00:00	SPY	ETF	254.22	254.22	254.22	254.22	500.0
2017-10-10 05:30:00	SPY	ETF	254.27	254.42	254.27	254.42	2163.0
2017-10-10 06:00:00	SPY	ETF	254.39	254.48	254.39	254.47	25285.0
2017-10-10 06:30:00	SPY	ETF	254.46	254.5	254.45	254.45	5052.0
2017-10-10 07:00:00	SPY	ETF	254.46	254.48	254.36	254.36	18243.0
2017-10-10 07:30:00	SPY	ETF	254.38	254.48	254.38	254.48	47486.0
2017-10-10 08:00:00	SPY	ETF	254.45	254.54	254.45	254.54	43048.0
2017-10-10 08:30:00	SPY	ETF	254.52	254.59	254.47	254.58	102585.0
2017-10-10 09:00:00	SPY	ETF	254.58	254.63	254.55	254.61	165123.0
2017-10-10 09:30:00	SPY	ETF	254.6	255.05	254.52	254.73	5969194.0
2017-10-10 10:00:00	SPY	ETF	254.7201	254.74	254.03	254.36	3636345.0
2017-10-10 10:30:00	SPY	ETF	254.3647	254.4	254.19	254.36	1840706.0
2017-10-10 11:00:00	SPY	ETF	254.36	254.41	254.17	254.24	2725095.0
2017-10-10 11:30:00	SPY	ETF	254.24	254.37	254.09	254.16	2893035.0
2017-10-10 12:00:00	SPY	ETF	254.16	254.23	253.98	254.2	1609880.0
2017-10-10 12:30:00	SPY	ETF	254.2	254.41	254.19	254.32	1925563.0
2017-10-10 13:00:00	SPY	ETF	254.325	254.52	254.3	254.35	1057507.0
2017-10-10 13:30:00	SPY	ETF	254.35	254.55	254.27	254.34	1579637.0
2017-10-10 14:00:00	SPY	ETF	254.34	254.4475	254.24	254.33	1505173.0
2017-10-10 14:30:00	SPY	ETF	254.33	254.39	254.3	254.32	882730.0
2017-10-10 15:00:00	SPY	ETF	254.32	254.46	254.31	254.365	1350234.0
2017-10-10 15:30:00	SPY	ETF	254.365	254.6	254.32	254.6	7936117.0
2017-10-10 16:00:00	SPY	ETF	254.59	254.63	254.52	254.55	4357666.0
2017-10-10 16:30:00	SPY	ETF	254.55	254.62	254.53	254.61	201641.0
2017-10-10 17:00:00	SPY	ETF	254.6	254.61	254.57	254.58	57688.0
2017-10-10 17:30:00	SPY	ETF	254.58	254.6	254.51	254.52	104018.0
2017-10-10 18:00:00	SPY	ETF	254.53	254.55	254.5	254.51	54456.0
2017-10-10 18:30:00	SPY	ETF	254.51	254.54	254.48	254.53	43601.0
2017-10-10 19:00:00	SPY	ETF	254.53	254.6	254.48	254.56	37099.0
2017-10-10 19:30:00	SPY	ETF	254.55	254.56	254.53	254.55	16124.0
2017-10-10 04:00:00	QQQ	ETF	147.73	147.75	147.65	147.65	11200.0
2017-10-10 04:30:00	QQQ	ETF	147.64	147.71	147.64	147.71	5397.0
2017-10-10 05:00:00	QQQ	ETF	147.7	147.7	147.7	147.7	400.0
2017-10-10 05:30:00	QQQ	ETF	147.79	147.79	147.79	147.79	4200.0
2017-10-10 06:30:00	QQQ	ETF	147.76	147.76	147.76	147.76	900.0
2017-10-10 07:00:00	QQQ	ETF	147.76	147.82	147.75	147.75	1799.0
2017-10-10 07:30:00	QQQ	ETF	147.8	147.83	147.79	147.83	8299.0
2017-10-10 08:00:00	QQQ	ETF	147.76	147.87	147.76	147.87	11866.0
2017-10-10 08:30:00	QQQ	ETF	147.85	147.94	147.85	147.93	101695.0
2017-10-10 09:00:00	QQQ	ETF	147.92	148.0	147.91	147.98	113717.0
2017-10-10 09:30:00	QQQ	ETF	147.98	148.14	147.69	147.73	2175857.0
2017-10-10 10:00:00	QQQ	ETF	147.74	147.74	147.2001	147.5	2294467.0
2017-10-10 10:30:00	QQQ	ETF	147.5	147.63	147.41	147.55	919443.0
2017-10-10 11:00:00	QQQ	ETF	147.545	147.57	147.26	147.33	754234.0
2017-10-10 11:30:00	QQQ	ETF	147.34	147.49	147.09	147.22	923732.0
2017-10-10 12:00:00	QQQ	ETF	147.21	147.23	146.95	147.16	2182952.0
2017-10-10 12:30:00	QQQ	ETF	147.16	147.4	147.15	147.33	939114.0
2017-10-10 13:00:00	QQQ	ETF	147.33	147.53	147.31	147.37	713337.0

> showing 50 of 14,918 rows — these rows as CSV

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