PREVIEW / etf_30min / 2012-12-04

all etf 30-min files

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

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-12-04 04:00:00	SPY	ETF	141.16	141.49	141.16	141.49	16900.0
2012-12-04 04:30:00	SPY	ETF	141.46	141.46	141.41	141.41	3100.0
2012-12-04 05:00:00	SPY	ETF	141.41	141.44	141.41	141.44	1000.0
2012-12-04 05:30:00	SPY	ETF	141.48	141.6	141.48	141.5	5272.0
2012-12-04 06:00:00	SPY	ETF	141.45	141.5	141.45	141.49	8700.0
2012-12-04 06:30:00	SPY	ETF	141.49	141.54	141.47	141.49	31115.0
2012-12-04 07:00:00	SPY	ETF	141.49	141.6	141.45	141.49	231982.0
2012-12-04 07:30:00	SPY	ETF	141.47	141.65	141.43	141.58	104567.0
2012-12-04 08:00:00	SPY	ETF	141.58	141.64	141.09	141.55	386943.0
2012-12-04 08:30:00	SPY	ETF	141.55	141.59	141.29	141.3	898187.0
2012-12-04 09:00:00	SPY	ETF	141.3	141.46	141.27	141.44	523425.0
2012-12-04 09:30:00	SPY	ETF	141.44	141.76	141.26	141.48	11778335.0
2012-12-04 10:00:00	SPY	ETF	141.48	141.87	141.29	141.37	10477359.0
2012-12-04 10:30:00	SPY	ETF	141.36	141.41	141.21	141.32	9541907.0
2012-12-04 11:00:00	SPY	ETF	141.32	141.35	141.01	141.06	8829222.0
2012-12-04 11:30:00	SPY	ETF	141.06	141.45	141.03	141.33	6931456.0
2012-12-04 12:00:00	SPY	ETF	141.34	141.34	140.935	141.2096	8257741.0
2012-12-04 12:30:00	SPY	ETF	141.209	141.32	141.04	141.09	7323060.0
2012-12-04 13:00:00	SPY	ETF	141.08	141.22	140.87	141.16	7756946.0
2012-12-04 13:30:00	SPY	ETF	141.16	141.49	141.06	141.401	9487006.0
2012-12-04 14:00:00	SPY	ETF	141.41	141.51	141.23	141.245	6787664.0
2012-12-04 14:30:00	SPY	ETF	141.24	141.41	141.17	141.26	7683445.0
2012-12-04 15:00:00	SPY	ETF	141.26	141.57	141.259	141.48	6791257.0
2012-12-04 15:30:00	SPY	ETF	141.48	141.5	141.19	141.21	9854192.0
2012-12-04 16:00:00	SPY	ETF	141.22	141.4759	141.15	141.17	7502305.0
2012-12-04 16:30:00	SPY	ETF	141.17	141.22	141.07	141.075	556139.0
2012-12-04 17:00:00	SPY	ETF	141.08	141.08	140.97	141.0	410451.0
2012-12-04 17:30:00	SPY	ETF	141.2309	141.2309	140.98	140.98	2699173.0
2012-12-04 18:00:00	SPY	ETF	140.98	141.02	140.86	140.94	893776.0
2012-12-04 18:30:00	SPY	ETF	140.94	141.02	140.94	141.02	7771.0
2012-12-04 19:00:00	SPY	ETF	140.99	141.09	140.92	141.06	25720.0
2012-12-04 19:30:00	SPY	ETF	141.05	141.12	141.05	141.07	73682.0
2012-12-04 05:00:00	QQQ	ETF	65.74	65.74	65.74	65.74	100.0
2012-12-04 06:00:00	QQQ	ETF	65.74	65.74	65.74	65.74	400.0
2012-12-04 06:30:00	QQQ	ETF	65.76	65.76	65.76	65.76	6800.0
2012-12-04 07:00:00	QQQ	ETF	65.77	65.78	65.76	65.78	2980.0
2012-12-04 07:30:00	QQQ	ETF	65.74	65.8	65.74	65.77	10200.0
2012-12-04 08:00:00	QQQ	ETF	65.76	65.78	65.73	65.78	87035.0
2012-12-04 08:30:00	QQQ	ETF	65.73	65.74	65.6	65.6	119880.0
2012-12-04 09:00:00	QQQ	ETF	65.59	65.69	65.59	65.68	308603.0
2012-12-04 09:30:00	QQQ	ETF	65.69	65.72	65.52	65.56	4427980.0
2012-12-04 10:00:00	QQQ	ETF	65.56	65.73	65.36	65.4	4718048.0
2012-12-04 10:30:00	QQQ	ETF	65.39	65.43	65.275	65.4	2907114.0
2012-12-04 11:00:00	QQQ	ETF	65.4	65.415	65.2	65.33	2167871.0
2012-12-04 11:30:00	QQQ	ETF	65.32	65.62	65.29	65.53	2349564.0
2012-12-04 12:00:00	QQQ	ETF	65.53	65.53	65.31	65.47	1913434.0
2012-12-04 12:30:00	QQQ	ETF	65.48	65.52	65.37	65.39	1876418.0
2012-12-04 13:00:00	QQQ	ETF	65.4	65.45	65.31	65.43	1271290.0
2012-12-04 13:30:00	QQQ	ETF	65.43	65.66	65.38	65.64	3785814.0
2012-12-04 14:00:00	QQQ	ETF	65.64	65.68	65.5	65.5	1790423.0

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

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