PREVIEW / etf_30min / 2011-08-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-25.parquet
  size:    280 KB
  rows:    9,480

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-08-25 04:00:00	SPY	ETF	117.78	118.08	117.78	118.0	82421.0
2011-08-25 04:30:00	SPY	ETF	117.88	118.06	117.88	117.98	7500.0
2011-08-25 05:00:00	SPY	ETF	117.97	117.97	117.7	117.73	7200.0
2011-08-25 05:30:00	SPY	ETF	117.65	117.65	117.44	117.48	15060.0
2011-08-25 06:00:00	SPY	ETF	117.56	117.9	117.56	117.86	5800.0
2011-08-25 06:30:00	SPY	ETF	117.88	118.08	117.88	117.93	9660.0
2011-08-25 07:00:00	SPY	ETF	117.9	118.06	117.8	118.0	402911.0
2011-08-25 07:30:00	SPY	ETF	118.03	118.17	117.91	118.13	497989.0
2011-08-25 08:00:00	SPY	ETF	118.09	118.25	117.66	118.05	903495.0
2011-08-25 08:30:00	SPY	ETF	117.97	118.15	117.68	117.71	2578606.0
2011-08-25 09:00:00	SPY	ETF	117.73	119.09	117.58	118.74	9116887.0
2011-08-25 09:30:00	SPY	ETF	118.73	119.4	117.82	118.08	37876251.0
2011-08-25 10:00:00	SPY	ETF	118.08	118.12	116.88	117.22	36252925.0
2011-08-25 10:30:00	SPY	ETF	117.22	117.42	116.25	116.875	29099036.0
2011-08-25 11:00:00	SPY	ETF	116.875	117.319	116.57	117.08	18870974.0
2011-08-25 11:30:00	SPY	ETF	117.08	117.22	116.55	117.013	10589752.0
2011-08-25 12:00:00	SPY	ETF	117.0	117.14	116.44	116.68	13313970.0
2011-08-25 12:30:00	SPY	ETF	116.68	116.69	115.91	116.35	14364446.0
2011-08-25 13:00:00	SPY	ETF	116.36	116.89	116.27	116.85	11560296.0
2011-08-25 13:30:00	SPY	ETF	116.85	117.0	116.49	116.91	11328901.0
2011-08-25 14:00:00	SPY	ETF	116.92	117.12	116.58	116.86	14832762.0
2011-08-25 14:30:00	SPY	ETF	116.85	117.1	116.34	116.36	11118823.0
2011-08-25 15:00:00	SPY	ETF	116.35	117.06	116.15	116.62	22150671.0
2011-08-25 15:30:00	SPY	ETF	116.62	116.72	115.87	116.32	38542943.0
2011-08-25 16:00:00	SPY	ETF	116.33	118.1056	115.35	116.33	23272998.0
2011-08-25 16:30:00	SPY	ETF	116.32	116.39	116.02	116.09	2404346.0
2011-08-25 17:00:00	SPY	ETF	116.16	116.23	116.12	116.19	88285.0
2011-08-25 17:30:00	SPY	ETF	116.1	116.22	116.07	116.15	20126.0
2011-08-25 18:00:00	SPY	ETF	116.17	116.22	116.11	116.22	50802.0
2011-08-25 18:30:00	SPY	ETF	116.2	116.36	116.19	116.31	69958.0
2011-08-25 19:00:00	SPY	ETF	116.3	116.48	116.29	116.45	170917.0
2011-08-25 19:30:00	SPY	ETF	116.45	116.68	116.41	116.65	291243.0
2011-08-25 04:00:00	QQQ	ETF	52.33	52.42	52.33	52.41	1423.0
2011-08-25 04:30:00	QQQ	ETF	52.41	52.41	52.35	52.36	1400.0
2011-08-25 05:00:00	QQQ	ETF	52.36	52.36	52.21	52.21	6400.0
2011-08-25 05:30:00	QQQ	ETF	52.21	52.23	52.21	52.23	732.0
2011-08-25 06:00:00	QQQ	ETF	52.32	52.33	52.31	52.33	4601.0
2011-08-25 06:30:00	QQQ	ETF	52.4	52.4	52.31	52.31	5100.0
2011-08-25 07:00:00	QQQ	ETF	52.36	52.49	52.35	52.46	217701.0
2011-08-25 07:30:00	QQQ	ETF	52.48	52.55	52.42	52.54	104840.0
2011-08-25 08:00:00	QQQ	ETF	52.51	52.57	52.44	52.51	733911.0
2011-08-25 08:30:00	QQQ	ETF	52.58	52.58	52.33	52.34	502580.0
2011-08-25 09:00:00	QQQ	ETF	52.34	52.82	52.29	52.64	2096503.0
2011-08-25 09:30:00	QQQ	ETF	52.64	52.905	52.42	52.54	13348797.0
2011-08-25 10:00:00	QQQ	ETF	52.54	52.58	52.04	52.23	10722202.0
2011-08-25 10:30:00	QQQ	ETF	52.23	52.315	51.89	51.93	10878968.0
2011-08-25 11:00:00	QQQ	ETF	51.93	52.37	51.93	52.25	5306896.0
2011-08-25 11:30:00	QQQ	ETF	52.25	52.3	52.04	52.25	2799311.0
2011-08-25 12:00:00	QQQ	ETF	52.26	52.32	51.97	52.08	2743245.0
2011-08-25 12:30:00	QQQ	ETF	52.08	52.09	51.74	51.92	4248874.0

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

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