PREVIEW / etf_30min / 2012-10-15

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-15.parquet
  size:    280 KB
  rows:    9,410

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-15 04:00:00	SPY	ETF	143.35	143.36	143.35	143.36	650.0
2012-10-15 04:30:00	SPY	ETF	143.37	143.37	143.37	143.37	2000.0
2012-10-15 05:00:00	SPY	ETF	143.29	143.45	143.29	143.4	1860.0
2012-10-15 05:30:00	SPY	ETF	143.45	143.45	143.37	143.37	2300.0
2012-10-15 06:00:00	SPY	ETF	143.38	143.41	143.31	143.31	5500.0
2012-10-15 06:30:00	SPY	ETF	143.3	143.33	143.3	143.33	9220.0
2012-10-15 07:00:00	SPY	ETF	143.39	143.42	143.32	143.4	74470.0
2012-10-15 07:30:00	SPY	ETF	143.39	143.46	143.34	143.42	200819.0
2012-10-15 08:00:00	SPY	ETF	143.44	143.64	143.34	143.38	649855.0
2012-10-15 08:30:00	SPY	ETF	143.38	143.59	143.23	143.29	582388.0
2012-10-15 09:00:00	SPY	ETF	143.29	143.33	143.16	143.24	594444.0
2012-10-15 09:30:00	SPY	ETF	143.23	143.4	142.95	143.11	12951628.0
2012-10-15 10:00:00	SPY	ETF	143.11	143.28	142.82	142.85	8087244.0
2012-10-15 10:30:00	SPY	ETF	142.85	143.09	142.77	143.02	6766084.0
2012-10-15 11:00:00	SPY	ETF	143.02	143.4	142.93	143.3	6707527.0
2012-10-15 11:30:00	SPY	ETF	143.3	143.7	143.27	143.508	6379016.0
2012-10-15 12:00:00	SPY	ETF	143.51	143.83	143.47	143.8032	4516079.0
2012-10-15 12:30:00	SPY	ETF	143.8001	143.96	143.72	143.8	4917054.0
2012-10-15 13:00:00	SPY	ETF	143.81	143.99	143.72	143.74	3488639.0
2012-10-15 13:30:00	SPY	ETF	143.7487	143.86	143.69	143.802	3025565.0
2012-10-15 14:00:00	SPY	ETF	143.8	143.9	143.76	143.79	4875252.0
2012-10-15 14:30:00	SPY	ETF	143.792	143.8	143.49	143.61	5411621.0
2012-10-15 15:00:00	SPY	ETF	143.615	143.9	143.57	143.88	5849175.0
2012-10-15 15:30:00	SPY	ETF	143.89	144.23	143.795	144.08	17081289.0
2012-10-15 16:00:00	SPY	ETF	144.06	144.2	143.203	144.12	5269259.0
2012-10-15 16:30:00	SPY	ETF	144.14	144.19	143.4707	144.17	808775.0
2012-10-15 17:00:00	SPY	ETF	144.17	144.18	144.1	144.13	63633.0
2012-10-15 17:30:00	SPY	ETF	144.14	144.16	144.1	144.14	7606.0
2012-10-15 18:00:00	SPY	ETF	144.15	144.19	144.12	144.15	58115.0
2012-10-15 18:30:00	SPY	ETF	144.19	144.28	144.18	144.27	36250.0
2012-10-15 19:00:00	SPY	ETF	144.27	144.3	144.19	144.26	112684.0
2012-10-15 19:30:00	SPY	ETF	144.25	144.37	144.25	144.35	33795.0
2012-10-15 04:00:00	QQQ	ETF	67.01	67.01	67.01	67.01	500.0
2012-10-15 04:30:00	QQQ	ETF	66.98	66.98	66.98	66.98	200.0
2012-10-15 05:30:00	QQQ	ETF	67.06	67.06	67.06	67.06	500.0
2012-10-15 06:30:00	QQQ	ETF	66.99	67.0	66.99	67.0	700.0
2012-10-15 07:00:00	QQQ	ETF	67.04	67.04	67.02	67.03	27700.0
2012-10-15 07:30:00	QQQ	ETF	67.04	67.06	67.04	67.05	1200.0
2012-10-15 08:00:00	QQQ	ETF	67.04	67.11	67.02	67.02	27489.0
2012-10-15 08:30:00	QQQ	ETF	67.07	67.1	66.96	66.96	216092.0
2012-10-15 09:00:00	QQQ	ETF	66.97	66.98	66.92	66.92	170807.0
2012-10-15 09:30:00	QQQ	ETF	66.93	67.06	66.76	66.8401	3172516.0
2012-10-15 10:00:00	QQQ	ETF	66.84	66.91	66.57	66.59	2719494.0
2012-10-15 10:30:00	QQQ	ETF	66.58	66.66	66.53	66.62	1629551.0
2012-10-15 11:00:00	QQQ	ETF	66.61	66.8701	66.56	66.81	1352308.0
2012-10-15 11:30:00	QQQ	ETF	66.81	67.03	66.81	66.88	1381297.0
2012-10-15 12:00:00	QQQ	ETF	66.89	67.03	66.82	67.02	1154625.0
2012-10-15 12:30:00	QQQ	ETF	67.02	67.08	66.95	66.98	1139898.0
2012-10-15 13:00:00	QQQ	ETF	66.98	67.08	66.9	66.91	824165.0
2012-10-15 13:30:00	QQQ	ETF	66.92	66.97	66.865	66.91	1100078.0

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

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