PREVIEW / etf_30min / 2014-09-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-17.parquet
  size:    340 KB
  rows:    11,429

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
2014-09-17 04:00:00	SPY	ETF	200.48	200.48	200.45	200.45	900.0
2014-09-17 04:30:00	SPY	ETF	200.55	200.55	200.55	200.55	100.0
2014-09-17 05:00:00	SPY	ETF	200.54	200.59	200.54	200.59	643.0
2014-09-17 05:30:00	SPY	ETF	200.54	200.61	200.53	200.61	3943.0
2014-09-17 06:00:00	SPY	ETF	200.6	200.64	200.59	200.59	807.0
2014-09-17 06:30:00	SPY	ETF	200.57	200.64	200.53	200.64	46399.0
2014-09-17 07:00:00	SPY	ETF	200.59	200.62	200.5	200.54	183174.0
2014-09-17 07:30:00	SPY	ETF	200.56	200.61	200.45	200.55	69647.0
2014-09-17 08:00:00	SPY	ETF	200.56	200.61	200.33	200.44	595907.0
2014-09-17 08:30:00	SPY	ETF	200.45	200.74	200.45	200.6	590312.0
2014-09-17 09:00:00	SPY	ETF	200.6	200.81	200.56	200.77	476831.0
2014-09-17 09:30:00	SPY	ETF	200.77	201.0	200.66	200.945	9411352.0
2014-09-17 10:00:00	SPY	ETF	200.95	201.06	200.74	200.8903	7091759.0
2014-09-17 10:30:00	SPY	ETF	200.9	200.91	200.55	200.65	4975122.0
2014-09-17 11:00:00	SPY	ETF	200.64	200.77	200.61	200.715	3366137.0
2014-09-17 11:30:00	SPY	ETF	200.72	200.73	200.46	200.56	4492220.0
2014-09-17 12:00:00	SPY	ETF	200.56	200.66	200.32	200.36	6395254.0
2014-09-17 12:30:00	SPY	ETF	200.37	200.53	200.33	200.43	5591157.0
2014-09-17 13:00:00	SPY	ETF	200.42	200.69	200.3	200.3	2453851.0
2014-09-17 13:30:00	SPY	ETF	200.304	200.76	200.24	200.7	7212888.0
2014-09-17 14:00:00	SPY	ETF	200.7	201.38	199.75	201.33	34225132.0
2014-09-17 14:30:00	SPY	ETF	201.33	201.34	200.73	201.21	13470799.0
2014-09-17 15:00:00	SPY	ETF	201.21	201.68	201.0	201.2699	14012447.0
2014-09-17 15:30:00	SPY	ETF	201.269	201.29	200.52	200.72	16232714.0
2014-09-17 16:00:00	SPY	ETF	200.72	200.84	200.72	200.75	7729133.0
2014-09-17 16:30:00	SPY	ETF	200.76	200.86	200.5099	200.83	9664141.0
2014-09-17 17:00:00	SPY	ETF	200.83	200.94	200.83	200.9	569232.0
2014-09-17 17:30:00	SPY	ETF	200.92	200.93	200.9	200.9	1507142.0
2014-09-17 18:00:00	SPY	ETF	200.9	200.9	200.79	200.8	12150.0
2014-09-17 18:30:00	SPY	ETF	200.81	200.81	200.79	200.79	3183.0
2014-09-17 19:00:00	SPY	ETF	200.81	200.81	200.8	200.8	61900.0
2014-09-17 19:30:00	SPY	ETF	200.8	200.81	200.76	200.76	28888.0
2014-09-17 04:00:00	QQQ	ETF	99.29	99.29	99.29	99.29	2500.0
2014-09-17 05:00:00	QQQ	ETF	99.31	99.31	99.31	99.31	4000.0
2014-09-17 06:00:00	QQQ	ETF	99.32	99.32	99.32	99.32	800.0
2014-09-17 06:30:00	QQQ	ETF	99.31	99.35	99.31	99.35	5477.0
2014-09-17 07:00:00	QQQ	ETF	99.29	99.31	99.26	99.28	34500.0
2014-09-17 07:30:00	QQQ	ETF	99.28	99.32	99.23	99.32	14600.0
2014-09-17 08:00:00	QQQ	ETF	99.3	99.31	99.18	99.23	101844.0
2014-09-17 08:30:00	QQQ	ETF	99.26	99.43	99.26	99.37	236697.0
2014-09-17 09:00:00	QQQ	ETF	99.36	99.41	99.33	99.38	162606.0
2014-09-17 09:30:00	QQQ	ETF	99.37	99.6	99.32	99.465	3811158.0
2014-09-17 10:00:00	QQQ	ETF	99.47	99.54	99.36	99.47	1397007.0
2014-09-17 10:30:00	QQQ	ETF	99.47	99.4899	99.23	99.3172	1824663.0
2014-09-17 11:00:00	QQQ	ETF	99.31	99.425	99.295	99.42	1174717.0
2014-09-17 11:30:00	QQQ	ETF	99.42	99.42	99.3001	99.38	891377.0
2014-09-17 12:00:00	QQQ	ETF	99.39	99.42	99.23	99.24	831315.0
2014-09-17 12:30:00	QQQ	ETF	99.23	99.31	99.21	99.25	792559.0
2014-09-17 13:00:00	QQQ	ETF	99.25	99.29	99.195	99.25	1081752.0
2014-09-17 13:30:00	QQQ	ETF	99.25	99.45	99.23	99.42	1634250.0

> showing 50 of 11,429 rows — these rows as CSV

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