PREVIEW / etf_30min / 2013-12-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-13.parquet
  size:    315 KB
  rows:    10,811

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-13 04:00:00	SPY	ETF	178.66	178.68	178.4	178.61	23435.0
2013-12-13 04:30:00	SPY	ETF	178.65	178.77	178.65	178.77	47319.0
2013-12-13 05:00:00	SPY	ETF	178.75	178.75	178.53	178.57	2592.0
2013-12-13 05:30:00	SPY	ETF	178.56	178.69	178.51	178.66	11909.0
2013-12-13 06:00:00	SPY	ETF	178.68	178.85	178.68	178.81	23629.0
2013-12-13 06:30:00	SPY	ETF	178.84	178.85	178.76	178.77	102981.0
2013-12-13 07:00:00	SPY	ETF	178.77	178.83	178.7	178.75	57977.0
2013-12-13 07:30:00	SPY	ETF	178.75	178.78	178.7	178.7	173072.0
2013-12-13 08:00:00	SPY	ETF	178.7	178.76	178.57	178.57	463165.0
2013-12-13 08:30:00	SPY	ETF	178.57	178.68	178.28	178.43	1267040.0
2013-12-13 09:00:00	SPY	ETF	178.43	178.57	178.3	178.5	1371959.0
2013-12-13 09:30:00	SPY	ETF	178.5	178.66	178.0	178.04	10512587.0
2013-12-13 10:00:00	SPY	ETF	178.05	178.26	177.77	177.96	8109770.0
2013-12-13 10:30:00	SPY	ETF	177.969	178.19	177.969	178.085	5328005.0
2013-12-13 11:00:00	SPY	ETF	178.08	178.21	177.88	178.0	5518789.0
2013-12-13 11:30:00	SPY	ETF	178.01	178.16	177.94	178.15	3568412.0
2013-12-13 12:00:00	SPY	ETF	178.14	178.38	178.02	178.38	5333207.0
2013-12-13 12:30:00	SPY	ETF	178.38	178.42	178.2	178.28	3019766.0
2013-12-13 13:00:00	SPY	ETF	178.29	178.4	178.27	178.382	2668054.0
2013-12-13 13:30:00	SPY	ETF	178.39	178.53	178.28	178.29	4268421.0
2013-12-13 14:00:00	SPY	ETF	178.29	178.3	177.79	177.88	7112338.0
2013-12-13 14:30:00	SPY	ETF	177.88	178.24	177.87	178.22	5736367.0
2013-12-13 15:00:00	SPY	ETF	178.22	178.5	178.21	178.45	6473236.0
2013-12-13 15:30:00	SPY	ETF	178.45	178.52	178.02	178.11	15752709.0
2013-12-13 16:00:00	SPY	ETF	178.11	178.2756	177.92	178.08	16292867.0
2013-12-13 16:30:00	SPY	ETF	178.07	178.11	178.07	178.09	1329312.0
2013-12-13 17:00:00	SPY	ETF	178.09	178.1	177.92	177.95	359205.0
2013-12-13 17:30:00	SPY	ETF	177.96	177.96	177.92	177.95	36380.0
2013-12-13 18:00:00	SPY	ETF	177.93	177.99	177.92	177.97	21166.0
2013-12-13 18:30:00	SPY	ETF	177.97	178.0	177.96	177.98	30424.0
2013-12-13 19:00:00	SPY	ETF	177.95	178.05	177.95	177.97	7317.0
2013-12-13 19:30:00	SPY	ETF	177.98	177.98	177.95	177.97	7656.0
2013-12-13 04:00:00	QQQ	ETF	85.23	85.23	85.23	85.23	1200.0
2013-12-13 04:30:00	QQQ	ETF	85.25	85.28	85.25	85.28	64600.0
2013-12-13 05:00:00	QQQ	ETF	85.26	85.26	85.16	85.16	3400.0
2013-12-13 05:30:00	QQQ	ETF	85.18	85.24	85.18	85.24	2600.0
2013-12-13 06:00:00	QQQ	ETF	85.26	85.28	85.25	85.27	7400.0
2013-12-13 06:30:00	QQQ	ETF	85.27	85.3	85.27	85.28	8605.0
2013-12-13 07:00:00	QQQ	ETF	85.26	85.32	85.26	85.31	8000.0
2013-12-13 07:30:00	QQQ	ETF	85.31	85.32	85.28	85.28	62400.0
2013-12-13 08:00:00	QQQ	ETF	85.28	85.33	85.26	85.26	70835.0
2013-12-13 08:30:00	QQQ	ETF	85.28	85.28	85.13	85.19	316057.0
2013-12-13 09:00:00	QQQ	ETF	85.18	85.39	85.15	85.36	673158.0
2013-12-13 09:30:00	QQQ	ETF	85.36	85.4	84.94	84.96	5135513.0
2013-12-13 10:00:00	QQQ	ETF	84.96	85.14	84.91	84.99	1916410.0
2013-12-13 10:30:00	QQQ	ETF	85.0	85.13	85.0	85.03	1829774.0
2013-12-13 11:00:00	QQQ	ETF	85.03	85.08	84.93	84.96	1517024.0
2013-12-13 11:30:00	QQQ	ETF	84.95	85.019	84.87	84.965	1358557.0
2013-12-13 12:00:00	QQQ	ETF	84.97	85.05	84.91	85.04	2148839.0
2013-12-13 12:30:00	QQQ	ETF	85.04	85.04	84.91	84.9772	952453.0

> showing 50 of 10,811 rows — these rows as CSV

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