PREVIEW / etf_30min / 2015-07-08

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-08.parquet
  size:    399 KB
  rows:    13,416

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-07-08 04:00:00	SPY	ETF	205.88	206.32	205.42	205.6	65983.0
2015-07-08 04:30:00	SPY	ETF	205.54	205.88	205.27	205.84	71316.0
2015-07-08 05:00:00	SPY	ETF	205.87	205.94	205.49	205.84	41923.0
2015-07-08 05:30:00	SPY	ETF	205.75	205.88	205.58	205.86	75827.0
2015-07-08 06:00:00	SPY	ETF	205.9	206.11	205.76	206.02	133345.0
2015-07-08 06:30:00	SPY	ETF	206.04	206.54	205.99	206.44	229090.0
2015-07-08 07:00:00	SPY	ETF	206.44	206.94	206.43	206.57	579593.0
2015-07-08 07:30:00	SPY	ETF	206.65	206.75	206.28	206.39	552479.0
2015-07-08 08:00:00	SPY	ETF	206.39	206.94	206.38	206.63	510681.0
2015-07-08 08:30:00	SPY	ETF	206.63	206.65	206.19	206.44	692298.0
2015-07-08 09:00:00	SPY	ETF	206.45	206.55	206.25	206.41	904793.0
2015-07-08 09:30:00	SPY	ETF	206.42	206.76	205.74	205.98	15972013.0
2015-07-08 10:00:00	SPY	ETF	205.97	206.02	205.44	205.82	10400600.0
2015-07-08 10:30:00	SPY	ETF	205.81	206.38	205.33	206.23	12116475.0
2015-07-08 11:00:00	SPY	ETF	206.21	206.7645	205.38	205.515	8203362.0
2015-07-08 11:30:00	SPY	ETF	205.51	205.79	204.92	205.18	12014987.0
2015-07-08 12:00:00	SPY	ETF	205.18	205.52	205.08	205.39	7693257.0
2015-07-08 12:30:00	SPY	ETF	205.39	205.77	205.05	205.71	5065734.0
2015-07-08 13:00:00	SPY	ETF	205.71	205.835	205.32	205.705	7270352.0
2015-07-08 13:30:00	SPY	ETF	205.71	205.8959	205.45	205.705	5341338.0
2015-07-08 14:00:00	SPY	ETF	205.72	205.77	205.05	205.2242	11174787.0
2015-07-08 14:30:00	SPY	ETF	205.23	205.24	204.25	204.51	14261552.0
2015-07-08 15:00:00	SPY	ETF	204.51	205.32	204.42	204.42	16737752.0
2015-07-08 15:30:00	SPY	ETF	204.41	205.05	204.4	204.48	22821665.0
2015-07-08 16:00:00	SPY	ETF	204.5	205.6	204.38	204.48	5630895.0
2015-07-08 16:30:00	SPY	ETF	204.49	207.9465	204.45	204.487	2338920.0
2015-07-08 17:00:00	SPY	ETF	204.483	204.55	204.46	204.52	193754.0
2015-07-08 17:30:00	SPY	ETF	204.52	204.9	204.51	204.55	929180.0
2015-07-08 18:00:00	SPY	ETF	204.56	204.86	204.55	204.77	181688.0
2015-07-08 18:30:00	SPY	ETF	204.86	204.89	204.73	204.88	75578.0
2015-07-08 19:00:00	SPY	ETF	204.86	204.98	204.83	204.98	85823.0
2015-07-08 19:30:00	SPY	ETF	204.96	205.04	204.89	205.04	91751.0
2015-07-08 04:00:00	QQQ	ETF	106.81	106.93	106.55	106.56	1373.0
2015-07-08 04:30:00	QQQ	ETF	106.76	106.76	106.5	106.5	5350.0
2015-07-08 05:30:00	QQQ	ETF	106.82	106.82	106.82	106.82	100.0
2015-07-08 06:00:00	QQQ	ETF	106.9	106.96	106.86	106.96	11900.0
2015-07-08 06:30:00	QQQ	ETF	106.98	107.17	106.98	107.16	10600.0
2015-07-08 07:00:00	QQQ	ETF	107.17	107.46	107.16	107.26	53035.0
2015-07-08 07:30:00	QQQ	ETF	107.3	107.33	107.1	107.15	30037.0
2015-07-08 08:00:00	QQQ	ETF	107.17	107.4	106.6933	107.31	343449.0
2015-07-08 08:30:00	QQQ	ETF	107.29	107.29	107.07	107.23	150582.0
2015-07-08 09:00:00	QQQ	ETF	107.22	107.23	106.99	107.19	356891.0
2015-07-08 09:30:00	QQQ	ETF	107.19	107.33	106.55	106.7	4270877.0
2015-07-08 10:00:00	QQQ	ETF	106.7085	106.79	106.379	106.65	2249819.0
2015-07-08 10:30:00	QQQ	ETF	106.64	107.0556	106.34	106.97	3462762.0
2015-07-08 11:00:00	QQQ	ETF	106.9701	106.9701	106.42	106.53	1439138.0
2015-07-08 11:30:00	QQQ	ETF	106.53	106.72	106.17	106.32	2709225.0
2015-07-08 12:00:00	QQQ	ETF	106.32	106.54	106.28	106.49	1496891.0
2015-07-08 12:30:00	QQQ	ETF	106.48	106.6901	106.27	106.65	1147101.0
2015-07-08 13:00:00	QQQ	ETF	106.65	106.77	106.46	106.7	1094807.0

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

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