PREVIEW / etf_30min / 2015-03-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-23.parquet
  size:    378 KB
  rows:    12,853

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-03-23 04:00:00	SPY	ETF	210.47	210.47	210.07	210.45	1380.0
2015-03-23 04:30:00	SPY	ETF	209.95	209.95	209.79	209.79	927.0
2015-03-23 05:00:00	SPY	ETF	209.9	210.0	209.9	210.0	600.0
2015-03-23 05:30:00	SPY	ETF	210.05	210.12	209.85	209.87	8574.0
2015-03-23 06:00:00	SPY	ETF	209.86	209.88	209.74	209.78	39394.0
2015-03-23 06:30:00	SPY	ETF	209.82	209.91	209.8	209.85	51766.0
2015-03-23 07:00:00	SPY	ETF	209.86	210.02	209.84	210.02	99425.0
2015-03-23 07:30:00	SPY	ETF	210.0	210.29	209.99	210.29	92405.0
2015-03-23 08:00:00	SPY	ETF	210.04	210.49	209.9	210.28	160117.0
2015-03-23 08:30:00	SPY	ETF	210.29	210.29	210.15	210.26	276023.0
2015-03-23 09:00:00	SPY	ETF	210.26	210.46	210.24	210.41	255709.0
2015-03-23 09:30:00	SPY	ETF	210.42	210.98	210.33	210.75	8223326.0
2015-03-23 10:00:00	SPY	ETF	210.75	211.11	210.67	210.88	5561225.0
2015-03-23 10:30:00	SPY	ETF	210.881	210.94	210.68	210.81	3040756.0
2015-03-23 11:00:00	SPY	ETF	210.81	210.91	210.66	210.71	4700151.0
2015-03-23 11:30:00	SPY	ETF	210.701	210.81	210.55	210.74	3860370.0
2015-03-23 12:00:00	SPY	ETF	210.73	210.73	210.5	210.65	2192276.0
2015-03-23 12:30:00	SPY	ETF	210.65	210.89	210.62	210.71	2536958.0
2015-03-23 13:00:00	SPY	ETF	210.7055	210.73	210.6	210.61	2558406.0
2015-03-23 13:30:00	SPY	ETF	210.61	210.79	210.55	210.65	1808204.0
2015-03-23 14:00:00	SPY	ETF	210.65	210.98	210.62	210.93	2944176.0
2015-03-23 14:30:00	SPY	ETF	210.929	210.95	210.65	210.72	2216081.0
2015-03-23 15:00:00	SPY	ETF	210.725	210.78	210.53	210.6	3025477.0
2015-03-23 15:30:00	SPY	ETF	210.6	210.65	210.01	210.04	11393403.0
2015-03-23 16:00:00	SPY	ETF	210.04	210.703	209.805	209.88	9213258.0
2015-03-23 16:30:00	SPY	ETF	209.88	209.91	209.83	209.89	278187.0
2015-03-23 17:00:00	SPY	ETF	209.89	209.89	209.8	209.81	70718.0
2015-03-23 17:30:00	SPY	ETF	209.85	209.85	209.79	209.82	29625.0
2015-03-23 18:00:00	SPY	ETF	209.82	209.91	209.82	209.9	50119.0
2015-03-23 18:30:00	SPY	ETF	209.9	209.93	209.9	209.93	22600.0
2015-03-23 19:00:00	SPY	ETF	209.93	209.96	209.91	209.93	10825.0
2015-03-23 19:30:00	SPY	ETF	209.92	209.98	209.92	209.98	53500.0
2015-03-23 04:00:00	QQQ	ETF	108.47	108.48	108.36	108.36	2200.0
2015-03-23 04:30:00	QQQ	ETF	108.4	108.45	108.4	108.45	800.0
2015-03-23 05:00:00	QQQ	ETF	108.45	108.45	108.45	108.45	100.0
2015-03-23 05:30:00	QQQ	ETF	108.49	108.49	108.49	108.49	100.0
2015-03-23 06:30:00	QQQ	ETF	108.39	108.39	108.31	108.31	400.0
2015-03-23 07:00:00	QQQ	ETF	108.3	108.35	108.3	108.35	5000.0
2015-03-23 07:30:00	QQQ	ETF	108.43	108.52	108.42	108.52	54300.0
2015-03-23 08:00:00	QQQ	ETF	108.48	108.53	108.38	108.5	112405.0
2015-03-23 08:30:00	QQQ	ETF	108.5	108.5	108.41	108.47	52417.0
2015-03-23 09:00:00	QQQ	ETF	108.45	108.5	108.39	108.48	211285.0
2015-03-23 09:30:00	QQQ	ETF	108.47	108.64	108.32	108.43	2636300.0
2015-03-23 10:00:00	QQQ	ETF	108.43	108.75	108.39	108.67	1308541.0
2015-03-23 10:30:00	QQQ	ETF	108.668	108.715	108.52	108.57	681350.0
2015-03-23 11:00:00	QQQ	ETF	108.57	108.64	108.4473	108.54	766311.0
2015-03-23 11:30:00	QQQ	ETF	108.54	108.62	108.41	108.57	688129.0
2015-03-23 12:00:00	QQQ	ETF	108.57	108.5768	108.46	108.51	611911.0
2015-03-23 12:30:00	QQQ	ETF	108.52	108.63	108.49	108.5372	653780.0
2015-03-23 13:00:00	QQQ	ETF	108.54	108.6	108.48	108.53	324765.0

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

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