PREVIEW / etf_30min / 2015-01-14

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-14.parquet
  size:    395 KB
  rows:    13,214

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-01-14 04:00:00	SPY	ETF	200.87	201.1	200.84	200.95	434007.0
2015-01-14 04:30:00	SPY	ETF	201.27	201.85	201.1	201.85	198615.0
2015-01-14 05:00:00	SPY	ETF	201.95	202.33	201.47	201.47	36855.0
2015-01-14 05:30:00	SPY	ETF	201.46	201.71	201.33	201.49	40550.0
2015-01-14 06:00:00	SPY	ETF	201.54	201.54	201.2	201.45	179850.0
2015-01-14 06:30:00	SPY	ETF	201.5	201.55	201.03	201.04	38020.0
2015-01-14 07:00:00	SPY	ETF	201.02	201.38	200.92	201.02	380101.0
2015-01-14 07:30:00	SPY	ETF	201.01	201.07	200.7	200.73	237376.0
2015-01-14 08:00:00	SPY	ETF	201.18	201.3333	200.4	200.56	800149.0
2015-01-14 08:30:00	SPY	ETF	200.58	200.58	198.98	199.66	4827737.0
2015-01-14 09:00:00	SPY	ETF	199.63	201.3691	199.24	199.65	2663531.0
2015-01-14 09:30:00	SPY	ETF	199.65	200.44	199.45	200.13	20423357.0
2015-01-14 10:00:00	SPY	ETF	200.14	201.1	200.12	200.81	17584831.0
2015-01-14 10:30:00	SPY	ETF	200.8	200.8	200.08	200.55	11914128.0
2015-01-14 11:00:00	SPY	ETF	200.56	200.6	199.68	199.78	10478474.0
2015-01-14 11:30:00	SPY	ETF	199.78	200.37	199.62	199.76	10516013.0
2015-01-14 12:00:00	SPY	ETF	199.755	199.99	199.35	199.655	7296141.0
2015-01-14 12:30:00	SPY	ETF	199.655	199.97	199.29	199.63	5260485.0
2015-01-14 13:00:00	SPY	ETF	199.64	199.84	199.15	199.26	6635737.0
2015-01-14 13:30:00	SPY	ETF	199.26	199.264	198.57	199.034	12084247.0
2015-01-14 14:00:00	SPY	ETF	199.04	200.37	198.93	200.28	17037043.0
2015-01-14 14:30:00	SPY	ETF	200.28	200.73	199.7	199.78	13839424.0
2015-01-14 15:00:00	SPY	ETF	199.785	201.05	199.75	200.77	15059658.0
2015-01-14 15:30:00	SPY	ETF	200.76	201.05	200.29	200.9	24034962.0
2015-01-14 16:00:00	SPY	ETF	200.89	201.28	200.81	201.23	6289679.0
2015-01-14 16:30:00	SPY	ETF	201.23	201.48	201.23	201.46	2114764.0
2015-01-14 17:00:00	SPY	ETF	201.45	201.48	201.39	201.39	96973.0
2015-01-14 17:30:00	SPY	ETF	201.39	201.47	201.39	201.4	49833.0
2015-01-14 18:00:00	SPY	ETF	201.39	201.54	201.34	201.39	70824.0
2015-01-14 18:30:00	SPY	ETF	201.39	201.47	201.34	201.4	28589.0
2015-01-14 19:00:00	SPY	ETF	201.4	201.53	201.38	201.45	155638.0
2015-01-14 19:30:00	SPY	ETF	201.44	201.48	201.21	201.28	139721.0
2015-01-14 04:00:00	QQQ	ETF	101.0	101.01	100.82	100.94	6950.0
2015-01-14 04:30:00	QQQ	ETF	101.22	101.25	101.22	101.25	7798.0
2015-01-14 05:00:00	QQQ	ETF	101.25	101.25	101.25	101.25	966.0
2015-01-14 05:30:00	QQQ	ETF	101.31	101.31	101.31	101.31	200.0
2015-01-14 06:00:00	QQQ	ETF	101.18	101.3	101.18	101.3	10800.0
2015-01-14 06:30:00	QQQ	ETF	101.3	101.35	101.2	101.21	4800.0
2015-01-14 07:00:00	QQQ	ETF	101.07	101.26	101.07	101.12	35500.0
2015-01-14 07:30:00	QQQ	ETF	101.07	101.07	100.97	100.97	29450.0
2015-01-14 08:00:00	QQQ	ETF	101.0	101.14	100.82	100.84	55579.0
2015-01-14 08:30:00	QQQ	ETF	100.86	100.86	100.15	100.55	522137.0
2015-01-14 09:00:00	QQQ	ETF	100.54	100.55	100.36	100.5	314388.0
2015-01-14 09:30:00	QQQ	ETF	100.5	101.06	100.35	100.97	6113847.0
2015-01-14 10:00:00	QQQ	ETF	100.971	101.4829	100.9631	101.22	3918457.0
2015-01-14 10:30:00	QQQ	ETF	101.21	101.22	100.79	101.02	2915825.0
2015-01-14 11:00:00	QQQ	ETF	101.03	101.05	100.58	100.68	2651258.0
2015-01-14 11:30:00	QQQ	ETF	100.68	101.0	100.57	100.64	2765030.0
2015-01-14 12:00:00	QQQ	ETF	100.66	100.8	100.43	100.58	2136170.0
2015-01-14 12:30:00	QQQ	ETF	100.58	100.79	100.46	100.651	1711501.0

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

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