PREVIEW / etf_30min / 2012-10-04

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-04.parquet
  size:    282 KB
  rows:    9,543

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
2012-10-04 04:00:00	SPY	ETF	145.77	145.77	145.46	145.46	27080.0
2012-10-04 04:30:00	SPY	ETF	145.37	145.37	145.37	145.37	10000.0
2012-10-04 05:00:00	SPY	ETF	145.38	145.38	145.37	145.37	400.0
2012-10-04 05:30:00	SPY	ETF	145.42	145.5	145.42	145.5	5800.0
2012-10-04 06:00:00	SPY	ETF	145.5	145.73	145.5	145.73	18615.0
2012-10-04 06:30:00	SPY	ETF	145.73	145.76	145.69	145.74	33250.0
2012-10-04 07:00:00	SPY	ETF	145.66	145.69	145.52	145.58	73975.0
2012-10-04 07:30:00	SPY	ETF	145.62	145.73	145.54	145.67	171601.0
2012-10-04 08:00:00	SPY	ETF	145.67	145.94	145.57	145.66	665918.0
2012-10-04 08:30:00	SPY	ETF	145.7	145.85	145.0826	145.71	1410391.0
2012-10-04 09:00:00	SPY	ETF	145.7	145.86	145.58	145.64	511349.0
2012-10-04 09:30:00	SPY	ETF	145.64	145.74	145.44	145.66	11182054.0
2012-10-04 10:00:00	SPY	ETF	145.65	146.34	145.53	146.14	13685057.0
2012-10-04 10:30:00	SPY	ETF	146.14	146.17	145.96	146.101	8137688.0
2012-10-04 11:00:00	SPY	ETF	146.1	146.16	145.71	145.75	11956028.0
2012-10-04 11:30:00	SPY	ETF	145.75	145.88	145.64	145.83	6146328.0
2012-10-04 12:00:00	SPY	ETF	145.83	146.12	145.7917	146.02	6336970.0
2012-10-04 12:30:00	SPY	ETF	146.02	146.09	145.82	145.92	3950914.0
2012-10-04 13:00:00	SPY	ETF	145.925	146.15	145.91	146.1	4132340.0
2012-10-04 13:30:00	SPY	ETF	146.1	146.24	145.696	146.16	5561132.0
2012-10-04 14:00:00	SPY	ETF	146.17	146.19	145.9	146.04	11157602.0
2012-10-04 14:30:00	SPY	ETF	146.038	146.18	145.98	146.11	7395274.0
2012-10-04 15:00:00	SPY	ETF	146.11	146.25	146.04	146.09	6748548.0
2012-10-04 15:30:00	SPY	ETF	146.085	146.2	145.95	146.2	14381886.0
2012-10-04 16:00:00	SPY	ETF	146.21	146.27	145.0826	146.15	6649051.0
2012-10-04 16:30:00	SPY	ETF	146.15	146.19	146.1	146.18	352572.0
2012-10-04 17:00:00	SPY	ETF	146.19	146.2	146.15	146.15	19725.0
2012-10-04 17:30:00	SPY	ETF	146.16	146.24	146.15	146.21	86915.0
2012-10-04 18:00:00	SPY	ETF	146.2	146.24	146.18	146.22	26965.0
2012-10-04 18:30:00	SPY	ETF	146.22	146.22	146.19	146.22	9780.0
2012-10-04 19:00:00	SPY	ETF	146.22	146.24	146.2	146.23	18950.0
2012-10-04 19:30:00	SPY	ETF	146.22	146.23	146.2	146.22	12237.0
2012-10-04 04:30:00	QQQ	ETF	69.16	69.16	69.15	69.15	10000.0
2012-10-04 06:00:00	QQQ	ETF	69.31	69.37	69.31	69.36	14750.0
2012-10-04 06:30:00	QQQ	ETF	69.37	69.37	69.37	69.37	300.0
2012-10-04 07:00:00	QQQ	ETF	69.31	69.34	69.31	69.32	500.0
2012-10-04 07:30:00	QQQ	ETF	69.32	69.37	69.3	69.33	68000.0
2012-10-04 08:00:00	QQQ	ETF	69.34	69.36	69.3	69.32	322013.0
2012-10-04 08:30:00	QQQ	ETF	69.31	69.4	69.21	69.3	411505.0
2012-10-04 09:00:00	QQQ	ETF	69.27	69.34	69.21	69.23	426857.0
2012-10-04 09:30:00	QQQ	ETF	69.23	69.26	69.0	69.13	3397326.0
2012-10-04 10:00:00	QQQ	ETF	69.13	69.46	69.06	69.37	2929349.0
2012-10-04 10:30:00	QQQ	ETF	69.37	69.39	69.25	69.3384	1670816.0
2012-10-04 11:00:00	QQQ	ETF	69.34	69.36	69.09	69.11	1795249.0
2012-10-04 11:30:00	QQQ	ETF	69.11	69.22	69.06	69.21	969649.0
2012-10-04 12:00:00	QQQ	ETF	69.21	69.35	69.16	69.29	1106384.0
2012-10-04 12:30:00	QQQ	ETF	69.285	69.31	69.17	69.22	601170.0
2012-10-04 13:00:00	QQQ	ETF	69.23	69.33	69.21	69.3	646247.0
2012-10-04 13:30:00	QQQ	ETF	69.3	69.35	69.225	69.3301	680192.0
2012-10-04 14:00:00	QQQ	ETF	69.33	69.34	69.19	69.268	1498443.0

> showing 50 of 9,543 rows — these rows as CSV

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