PREVIEW / etf_30min / 2013-12-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-17.parquet
  size:    326 KB
  rows:    11,032

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
2013-12-17 04:00:00	SPY	ETF	179.11	179.11	178.97	178.97	10900.0
2013-12-17 04:30:00	SPY	ETF	178.98	179.1	178.98	179.1	2129.0
2013-12-17 05:00:00	SPY	ETF	179.1	179.1	179.02	179.04	12534.0
2013-12-17 05:30:00	SPY	ETF	179.05	179.17	179.05	179.17	30759.0
2013-12-17 06:00:00	SPY	ETF	179.17	179.17	179.08	179.11	5600.0
2013-12-17 06:30:00	SPY	ETF	179.13	179.15	179.12	179.15	3177.0
2013-12-17 07:00:00	SPY	ETF	179.15	179.38	179.15	179.35	121678.0
2013-12-17 07:30:00	SPY	ETF	179.33	179.35	179.24	179.34	18444.0
2013-12-17 08:00:00	SPY	ETF	179.32	179.33	179.22	179.28	1070920.0
2013-12-17 08:30:00	SPY	ETF	179.29	179.46	179.29	179.33	1250826.0
2013-12-17 09:00:00	SPY	ETF	179.32	179.39	179.23	179.36	853777.0
2013-12-17 09:30:00	SPY	ETF	179.36	179.41	178.62	178.98	10198236.0
2013-12-17 10:00:00	SPY	ETF	178.98	179.0875	178.8	178.85	7533141.0
2013-12-17 10:30:00	SPY	ETF	178.85	178.96	178.37	178.48	7037827.0
2013-12-17 11:00:00	SPY	ETF	178.47	178.5	178.25	178.29	5330185.0
2013-12-17 11:30:00	SPY	ETF	178.3	179.2163	178.25	178.5	6771335.0
2013-12-17 12:00:00	SPY	ETF	178.5	178.625	178.4	178.542	4469532.0
2013-12-17 12:30:00	SPY	ETF	178.55	178.77	178.51	178.7195	3243882.0
2013-12-17 13:00:00	SPY	ETF	178.72	178.77	178.65	178.73	2898256.0
2013-12-17 13:30:00	SPY	ETF	178.73	178.81	178.56	178.689	3963040.0
2013-12-17 14:00:00	SPY	ETF	178.689	179.12	178.66	179.0	5234726.0
2013-12-17 14:30:00	SPY	ETF	179.005	179.01	178.725	178.81	6470021.0
2013-12-17 15:00:00	SPY	ETF	178.805	179.01	178.79	178.91	3667279.0
2013-12-17 15:30:00	SPY	ETF	178.91	178.98	178.62	178.63	9599361.0
2013-12-17 16:00:00	SPY	ETF	178.61	178.7823	178.43	178.49	4117032.0
2013-12-17 16:30:00	SPY	ETF	178.49	178.73	178.37	178.42	840801.0
2013-12-17 17:00:00	SPY	ETF	178.41	178.46	178.4	178.42	41874.0
2013-12-17 17:30:00	SPY	ETF	178.42	178.44	178.39	178.41	2527295.0
2013-12-17 18:00:00	SPY	ETF	178.45	178.55	178.45	178.55	165601.0
2013-12-17 18:30:00	SPY	ETF	178.55	178.59	178.54	178.58	26975.0
2013-12-17 19:00:00	SPY	ETF	178.58	178.73	178.58	178.73	161310.0
2013-12-17 19:30:00	SPY	ETF	178.71	178.83	178.7	178.74	165878.0
2013-12-17 04:00:00	QQQ	ETF	85.14	85.18	85.14	85.18	1200.0
2013-12-17 04:30:00	QQQ	ETF	85.2	85.2	85.2	85.2	400.0
2013-12-17 05:00:00	QQQ	ETF	85.22	85.24	85.2	85.22	3000.0
2013-12-17 05:30:00	QQQ	ETF	85.24	85.28	85.24	85.28	1200.0
2013-12-17 06:00:00	QQQ	ETF	85.26	85.26	85.26	85.26	600.0
2013-12-17 06:30:00	QQQ	ETF	85.26	85.28	85.26	85.28	1820.0
2013-12-17 07:00:00	QQQ	ETF	85.3	85.39	85.3	85.39	10000.0
2013-12-17 07:30:00	QQQ	ETF	85.36	85.37	85.32	85.37	27853.0
2013-12-17 08:00:00	QQQ	ETF	85.35	85.37	85.35	85.37	6497.0
2013-12-17 08:30:00	QQQ	ETF	85.37	85.42	85.35	85.35	120699.0
2013-12-17 09:00:00	QQQ	ETF	85.35	85.35	85.31	85.34	357775.0
2013-12-17 09:30:00	QQQ	ETF	85.33	85.36	85.05	85.21	3397401.0
2013-12-17 10:00:00	QQQ	ETF	85.21	85.34	85.17	85.26	2528823.0
2013-12-17 10:30:00	QQQ	ETF	85.25	85.32	85.04	85.0871	2111174.0
2013-12-17 11:00:00	QQQ	ETF	85.09	85.149	84.99	85.03	1864588.0
2013-12-17 11:30:00	QQQ	ETF	85.04	85.18	85.01	85.13	1046019.0
2013-12-17 12:00:00	QQQ	ETF	85.13	85.239	85.08	85.209	1589624.0
2013-12-17 12:30:00	QQQ	ETF	85.21	85.33	85.18	85.27	1696572.0

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

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