PREVIEW / etf_30min / 2014-09-26

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-26.parquet
  size:    343 KB
  rows:    11,518

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-09-26 04:00:00	SPY	ETF	196.52	196.75	196.48	196.69	25810.0
2014-09-26 04:30:00	SPY	ETF	196.77	196.77	196.55	196.56	38004.0
2014-09-26 05:00:00	SPY	ETF	196.55	196.99	196.5	196.89	57328.0
2014-09-26 05:30:00	SPY	ETF	196.95	197.03	196.85	196.88	36824.0
2014-09-26 06:00:00	SPY	ETF	196.9	196.93	196.68	196.8	57453.0
2014-09-26 06:30:00	SPY	ETF	196.8	196.9	196.8	196.8	29289.0
2014-09-26 07:00:00	SPY	ETF	196.82	196.9	196.75	196.85	122222.0
2014-09-26 07:30:00	SPY	ETF	196.85	196.94	196.69	196.75	155963.0
2014-09-26 08:00:00	SPY	ETF	196.83	197.2	196.73	197.11	471017.0
2014-09-26 08:30:00	SPY	ETF	197.15	197.15	196.52	196.53	1157605.0
2014-09-26 09:00:00	SPY	ETF	196.52	196.72	196.14	196.69	2926755.0
2014-09-26 09:30:00	SPY	ETF	196.7	196.95	196.42	196.73	12547418.0
2014-09-26 10:00:00	SPY	ETF	196.73	197.33	196.73	196.86	11219432.0
2014-09-26 10:30:00	SPY	ETF	196.86	197.16	196.65	197.03	7499747.0
2014-09-26 11:00:00	SPY	ETF	197.02	197.18	196.65	196.74	6718940.0
2014-09-26 11:30:00	SPY	ETF	196.74	196.77	196.485	196.7	4859398.0
2014-09-26 12:00:00	SPY	ETF	196.7	196.98	196.695	196.92	3106394.0
2014-09-26 12:30:00	SPY	ETF	196.92	197.03	196.77	196.864	2615514.0
2014-09-26 13:00:00	SPY	ETF	196.86	197.18	196.85	197.09	3732829.0
2014-09-26 13:30:00	SPY	ETF	197.095	197.32	197.04	197.27	2271595.0
2014-09-26 14:00:00	SPY	ETF	197.27	198.075	197.255	197.95	10056515.0
2014-09-26 14:30:00	SPY	ETF	197.96	198.39	197.925	198.13	7980464.0
2014-09-26 15:00:00	SPY	ETF	198.13	198.28	197.97	198.07	4278714.0
2014-09-26 15:30:00	SPY	ETF	198.07	198.15	197.8	197.95	11656530.0
2014-09-26 16:00:00	SPY	ETF	197.94	198.12	197.0739	198.0049	5221040.0
2014-09-26 16:30:00	SPY	ETF	198.06	198.1	197.9	198.07	2020599.0
2014-09-26 17:00:00	SPY	ETF	198.07	198.07	197.89	198.06	550464.0
2014-09-26 17:30:00	SPY	ETF	198.06	198.06	197.9	198.0	1354140.0
2014-09-26 18:00:00	SPY	ETF	197.99	198.0	197.95	198.0	2320.0
2014-09-26 18:30:00	SPY	ETF	197.96	197.97	197.85	197.88	16100.0
2014-09-26 19:00:00	SPY	ETF	197.89	197.91	197.86	197.88	9850.0
2014-09-26 19:30:00	SPY	ETF	197.9	197.92	197.88	197.9	7108.0
2014-09-26 04:00:00	QQQ	ETF	97.78	97.78	97.78	97.78	100.0
2014-09-26 05:00:00	QQQ	ETF	98.07	98.21	98.04	98.14	8600.0
2014-09-26 05:30:00	QQQ	ETF	98.15	98.23	98.13	98.18	31800.0
2014-09-26 06:00:00	QQQ	ETF	98.19	98.19	97.89	98.03	72900.0
2014-09-26 06:30:00	QQQ	ETF	98.03	98.07	98.01	98.01	9951.0
2014-09-26 07:00:00	QQQ	ETF	98.01	98.11	98.01	98.05	23000.0
2014-09-26 07:30:00	QQQ	ETF	98.08	98.1	97.98	97.98	47500.0
2014-09-26 08:00:00	QQQ	ETF	98.11	98.23	98.03	98.21	126627.0
2014-09-26 08:30:00	QQQ	ETF	98.18	98.2	97.98	97.98	298831.0
2014-09-26 09:00:00	QQQ	ETF	97.99	98.15	97.84	98.04	1069475.0
2014-09-26 09:30:00	QQQ	ETF	98.05	98.22	97.93	98.14	5563899.0
2014-09-26 10:00:00	QQQ	ETF	98.12	98.38	98.03	98.11	3492628.0
2014-09-26 10:30:00	QQQ	ETF	98.111	98.28	97.98	98.18	5086159.0
2014-09-26 11:00:00	QQQ	ETF	98.19	98.25	98.0	98.04	4238144.0
2014-09-26 11:30:00	QQQ	ETF	98.04	98.05	97.89	98.0	6577685.0
2014-09-26 12:00:00	QQQ	ETF	98.01	98.17	98.0	98.1428	3952071.0
2014-09-26 12:30:00	QQQ	ETF	98.15	98.179	98.06	98.1072	1885209.0
2014-09-26 13:00:00	QQQ	ETF	98.11	98.265	98.11	98.2	1517904.0

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

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