PREVIEW / etf_30min / 2011-02-03

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-03.parquet
  size:    275 KB
  rows:    9,127

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
2011-02-03 04:00:00	SPY	ETF	130.37	130.37	130.28	130.37	1000.0
2011-02-03 04:30:00	SPY	ETF	130.44	130.44	130.44	130.44	300.0
2011-02-03 05:00:00	SPY	ETF	130.51	130.51	130.51	130.51	15000.0
2011-02-03 05:30:00	SPY	ETF	130.45	130.45	130.45	130.45	200.0
2011-02-03 06:00:00	SPY	ETF	130.36	130.36	130.25	130.25	2600.0
2011-02-03 06:30:00	SPY	ETF	130.27	130.28	130.2	130.24	6900.0
2011-02-03 07:00:00	SPY	ETF	130.24	130.32	130.18	130.25	231599.0
2011-02-03 07:30:00	SPY	ETF	130.24	130.26	130.19	130.21	288875.0
2011-02-03 08:00:00	SPY	ETF	130.21	130.21	130.0	130.1	799556.0
2011-02-03 08:30:00	SPY	ETF	130.12	130.21	130.05	130.08	1832941.0
2011-02-03 09:00:00	SPY	ETF	130.07	130.35	130.07	130.26	2252238.0
2011-02-03 09:30:00	SPY	ETF	130.26	130.53	130.14	130.4	14299297.0
2011-02-03 10:00:00	SPY	ETF	130.39	130.51	129.57	129.91	18573723.0
2011-02-03 10:30:00	SPY	ETF	129.91	130.1	129.76	130.05	9621085.0
2011-02-03 11:00:00	SPY	ETF	130.05	130.1	129.8	130.06	6955101.0
2011-02-03 11:30:00	SPY	ETF	130.07	130.44	130.02	130.38	8085445.0
2011-02-03 12:00:00	SPY	ETF	130.38	130.47	130.26	130.39	6065513.0
2011-02-03 12:30:00	SPY	ETF	130.39	130.42	130.21	130.4	4712388.0
2011-02-03 13:00:00	SPY	ETF	130.4	130.44	130.3	130.39	4090493.0
2011-02-03 13:30:00	SPY	ETF	130.4	130.41	130.22	130.36	7340167.0
2011-02-03 14:00:00	SPY	ETF	130.3582	130.5	130.28	130.42	6246707.0
2011-02-03 14:30:00	SPY	ETF	130.42	130.73	130.41	130.66	9167895.0
2011-02-03 15:00:00	SPY	ETF	130.65	130.88	130.65	130.82	13445492.0
2011-02-03 15:30:00	SPY	ETF	130.82	130.98	130.77	130.78	17966373.0
2011-02-03 16:00:00	SPY	ETF	130.78	130.945	129.665	130.5014	11400860.0
2011-02-03 16:30:00	SPY	ETF	130.74	130.82	130.4996	130.76	1772574.0
2011-02-03 17:00:00	SPY	ETF	130.75	130.78	130.72	130.73	98160.0
2011-02-03 17:30:00	SPY	ETF	130.73	130.767	130.63	130.69	275512.0
2011-02-03 18:00:00	SPY	ETF	130.71	130.76	130.67	130.74	75097.0
2011-02-03 18:30:00	SPY	ETF	130.73	130.77	130.73	130.77	28674.0
2011-02-03 19:00:00	SPY	ETF	130.76	130.8	130.63	130.66	33106.0
2011-02-03 19:30:00	SPY	ETF	130.69	130.78	130.67	130.76	58252.0
2011-02-03 05:00:00	QQQ	ETF	56.98	56.98	56.98	56.98	13000.0
2011-02-03 06:00:00	QQQ	ETF	56.85	56.85	56.85	56.85	100.0
2011-02-03 07:00:00	QQQ	ETF	56.89	56.9	56.85	56.85	44476.0
2011-02-03 07:30:00	QQQ	ETF	56.85	56.85	56.84	56.84	1500.0
2011-02-03 08:00:00	QQQ	ETF	56.84	56.86	56.73	56.82	280154.0
2011-02-03 08:30:00	QQQ	ETF	56.82	56.84	56.77	56.81	171684.0
2011-02-03 09:00:00	QQQ	ETF	56.82	56.93	56.82	56.85	285285.0
2011-02-03 09:30:00	QQQ	ETF	56.85	56.98	56.85	56.93	4087021.0
2011-02-03 10:00:00	QQQ	ETF	56.93	56.98	56.4	56.63	8844215.0
2011-02-03 10:30:00	QQQ	ETF	56.63	56.76	56.55	56.71	2467688.0
2011-02-03 11:00:00	QQQ	ETF	56.7	56.75	56.58	56.72	2171924.0
2011-02-03 11:30:00	QQQ	ETF	56.73	56.99	56.72	56.9675	2463794.0
2011-02-03 12:00:00	QQQ	ETF	56.96	57.03	56.9201	56.97	1939900.0
2011-02-03 12:30:00	QQQ	ETF	56.97	56.975	56.84	56.95	1579981.0
2011-02-03 13:00:00	QQQ	ETF	56.9401	56.97	56.89	56.9301	825847.0
2011-02-03 13:30:00	QQQ	ETF	56.93	56.9395	56.84	56.915	1769519.0
2011-02-03 14:00:00	QQQ	ETF	56.91	56.97	56.875	56.93	1712781.0
2011-02-03 14:30:00	QQQ	ETF	56.93	57.05	56.92	56.9962	1815392.0

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

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