PREVIEW / etf_30min / 2014-12-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-18.parquet
  size:    393 KB
  rows:    13,225

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-12-18 04:00:00	SPY	ETF	202.59	203.75	202.59	203.75	89336.0
2014-12-18 04:30:00	SPY	ETF	203.77	204.17	203.6	203.6	60479.0
2014-12-18 05:00:00	SPY	ETF	203.8	204.81	203.8	204.71	289284.0
2014-12-18 05:30:00	SPY	ETF	204.69	204.72	204.43	204.55	156039.0
2014-12-18 06:00:00	SPY	ETF	204.54	204.57	204.24	204.3	162007.0
2014-12-18 06:30:00	SPY	ETF	204.27	204.29	204.07	204.07	105810.0
2014-12-18 07:00:00	SPY	ETF	204.1	204.4	204.1	204.39	274144.0
2014-12-18 07:30:00	SPY	ETF	204.38	204.52	204.29	204.44	475241.0
2014-12-18 08:00:00	SPY	ETF	204.41	204.51	203.0	204.2	844498.0
2014-12-18 08:30:00	SPY	ETF	204.2	204.74	201.79	204.71	1175726.0
2014-12-18 09:00:00	SPY	ETF	204.71	204.81	204.53	204.73	3038899.0
2014-12-18 09:30:00	SPY	ETF	204.74	205.12	204.2	205.01	23949206.0
2014-12-18 10:00:00	SPY	ETF	205.02	205.35	204.79	204.86	19612258.0
2014-12-18 10:30:00	SPY	ETF	204.87	204.92	204.52	204.543	14095611.0
2014-12-18 11:00:00	SPY	ETF	204.54	204.69	203.92	204.43	15772530.0
2014-12-18 11:30:00	SPY	ETF	204.43	204.99	204.29	204.94	10141005.0
2014-12-18 12:00:00	SPY	ETF	204.94	205.17	204.79	204.995	9954232.0
2014-12-18 12:30:00	SPY	ETF	205.0	205.47	204.93	205.46	11283360.0
2014-12-18 13:00:00	SPY	ETF	205.46	205.52	205.13	205.48	12365444.0
2014-12-18 13:30:00	SPY	ETF	205.48	205.59	205.38	205.44	12451391.0
2014-12-18 14:00:00	SPY	ETF	205.44	205.48	205.0	205.03	17540899.0
2014-12-18 14:30:00	SPY	ETF	205.02	205.46	204.91	205.39	13519135.0
2014-12-18 15:00:00	SPY	ETF	205.39	205.83	205.29	205.71	16874270.0
2014-12-18 15:30:00	SPY	ETF	205.715	212.97	205.71	206.8	43776131.0
2014-12-18 16:00:00	SPY	ETF	206.8	207.31	204.7369	207.04	13490838.0
2014-12-18 16:30:00	SPY	ETF	207.03	207.33	206.7674	207.29	4190872.0
2014-12-18 17:00:00	SPY	ETF	207.29	207.35	207.12	207.16	358477.0
2014-12-18 17:30:00	SPY	ETF	207.16	207.23	207.13	207.14	4928614.0
2014-12-18 18:00:00	SPY	ETF	207.13	207.23	207.08	207.08	232311.0
2014-12-18 18:30:00	SPY	ETF	207.12	207.17	207.1	207.13	62573.0
2014-12-18 19:00:00	SPY	ETF	207.13	207.2	207.13	207.16	49015.0
2014-12-18 19:30:00	SPY	ETF	207.17	207.29	207.16	207.21	274907.0
2014-12-18 04:00:00	QQQ	ETF	102.63	102.69	102.61	102.69	73670.0
2014-12-18 04:30:00	QQQ	ETF	102.8	102.88	102.66	102.66	36250.0
2014-12-18 05:00:00	QQQ	ETF	102.74	103.32	102.74	103.28	21800.0
2014-12-18 05:30:00	QQQ	ETF	103.26	103.28	103.17	103.22	13550.0
2014-12-18 06:00:00	QQQ	ETF	103.21	103.25	103.03	103.03	11100.0
2014-12-18 06:30:00	QQQ	ETF	103.08	103.08	102.98	102.98	15890.0
2014-12-18 07:00:00	QQQ	ETF	102.98	103.15	102.98	103.09	37116.0
2014-12-18 07:30:00	QQQ	ETF	103.11	103.22	103.07	103.14	76141.0
2014-12-18 08:00:00	QQQ	ETF	103.14	103.1701	102.96	103.02	145044.0
2014-12-18 08:30:00	QQQ	ETF	103.08	103.24	102.99	103.24	168965.0
2014-12-18 09:00:00	QQQ	ETF	103.22	103.34	103.13	103.25	336948.0
2014-12-18 09:30:00	QQQ	ETF	103.26	103.48	102.98	103.475	6760120.0
2014-12-18 10:00:00	QQQ	ETF	103.475	103.77	103.34	103.54	5067655.0
2014-12-18 10:30:00	QQQ	ETF	103.53	103.6	103.33	103.44	2455943.0
2014-12-18 11:00:00	QQQ	ETF	103.44	103.51	103.11	103.38	2954840.0
2014-12-18 11:30:00	QQQ	ETF	103.38	103.63	103.26	103.615	1656199.0
2014-12-18 12:00:00	QQQ	ETF	103.61	103.66	103.39	103.5	1125432.0
2014-12-18 12:30:00	QQQ	ETF	103.51	103.76	103.48	103.76	1177210.0

> showing 50 of 13,225 rows — these rows as CSV

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