PREVIEW / etf_30min / 2013-02-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-04.parquet
  size:    321 KB
  rows:    10,793

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
2013-02-04 04:00:00	SPY	ETF	151.18	151.18	151.18	151.18	100.0
2013-02-04 04:30:00	SPY	ETF	151.14	151.14	151.14	151.14	400.0
2013-02-04 05:00:00	SPY	ETF	151.05	151.05	150.98	150.98	12800.0
2013-02-04 05:30:00	SPY	ETF	150.89	150.89	150.76	150.79	18434.0
2013-02-04 06:00:00	SPY	ETF	150.81	150.85	150.8	150.8	8900.0
2013-02-04 06:30:00	SPY	ETF	150.83	150.83	150.74	150.74	22450.0
2013-02-04 07:00:00	SPY	ETF	150.76	150.79	150.6	150.62	86749.0
2013-02-04 07:30:00	SPY	ETF	150.62	150.73	150.53	150.73	212645.0
2013-02-04 08:00:00	SPY	ETF	150.71	150.79	150.18	150.31	1789301.0
2013-02-04 08:30:00	SPY	ETF	150.32	150.41	150.24	150.38	2457670.0
2013-02-04 09:00:00	SPY	ETF	150.37	150.5	150.29	150.32	1719006.0
2013-02-04 09:30:00	SPY	ETF	150.32	150.57	150.18	150.49	14415546.0
2013-02-04 10:00:00	SPY	ETF	150.49	150.58	150.23	150.35	9356485.0
2013-02-04 10:30:00	SPY	ETF	150.35	150.35	150.08	150.11	6410536.0
2013-02-04 11:00:00	SPY	ETF	150.12	150.21	149.97	149.99	6400699.0
2013-02-04 11:30:00	SPY	ETF	149.98	150.02	149.73	149.79	9059448.0
2013-02-04 12:00:00	SPY	ETF	149.8	149.84	149.61	149.8	5698641.0
2013-02-04 12:30:00	SPY	ETF	149.8	149.97	149.77	149.84	4280738.0
2013-02-04 13:00:00	SPY	ETF	149.84	149.96	149.81	149.85	3844911.0
2013-02-04 13:30:00	SPY	ETF	149.86	149.88	149.6599	149.745	6030111.0
2013-02-04 14:00:00	SPY	ETF	149.745	149.885	149.68	149.88	5994779.0
2013-02-04 14:30:00	SPY	ETF	149.88	150.07	149.82	150.039	5373650.0
2013-02-04 15:00:00	SPY	ETF	150.03	151.2679	149.8001	149.94	21073568.0
2013-02-04 15:30:00	SPY	ETF	149.94	149.96	149.43	149.54	24528489.0
2013-02-04 16:00:00	SPY	ETF	149.55	151.2679	149.5117	149.72	18751688.0
2013-02-04 16:30:00	SPY	ETF	149.73	151.2679	149.67	149.72	4976498.0
2013-02-04 17:00:00	SPY	ETF	149.7	149.72	149.63	149.69	46680.0
2013-02-04 17:30:00	SPY	ETF	149.68	149.69	149.62	149.63	61951.0
2013-02-04 18:00:00	SPY	ETF	149.64	149.7	149.61	149.67	34922.0
2013-02-04 18:30:00	SPY	ETF	149.67	149.75	149.67	149.74	10849.0
2013-02-04 19:00:00	SPY	ETF	149.74	149.89	149.74	149.88	54034.0
2013-02-04 19:30:00	SPY	ETF	149.88	149.9	149.82	149.85	72050.0
2013-02-04 04:30:00	QQQ	ETF	67.62	67.62	67.62	67.62	600.0
2013-02-04 05:30:00	QQQ	ETF	67.53	67.53	67.53	67.53	10000.0
2013-02-04 06:00:00	QQQ	ETF	67.56	67.56	67.56	67.56	8000.0
2013-02-04 06:30:00	QQQ	ETF	67.57	67.57	67.57	67.57	700.0
2013-02-04 07:00:00	QQQ	ETF	67.53	67.53	67.43	67.44	9928.0
2013-02-04 07:30:00	QQQ	ETF	67.43	67.47	67.41	67.47	16503.0
2013-02-04 08:00:00	QQQ	ETF	67.42	67.47	67.15	67.19	118824.0
2013-02-04 08:30:00	QQQ	ETF	67.18	67.26	67.16	67.26	202017.0
2013-02-04 09:00:00	QQQ	ETF	67.25	67.31	67.2	67.24	100176.0
2013-02-04 09:30:00	QQQ	ETF	67.25	67.4599	67.2	67.39	3260126.0
2013-02-04 10:00:00	QQQ	ETF	67.39	67.42	67.23	67.32	2172277.0
2013-02-04 10:30:00	QQQ	ETF	67.31	67.33	67.18	67.19	1539222.0
2013-02-04 11:00:00	QQQ	ETF	67.19	67.23	67.0	67.02	2562762.0
2013-02-04 11:30:00	QQQ	ETF	67.01	67.01	66.65	66.74	5645606.0
2013-02-04 12:00:00	QQQ	ETF	66.73	66.77	66.59	66.75	1822208.0
2013-02-04 12:30:00	QQQ	ETF	66.748	66.8	66.67	66.6998	1209180.0
2013-02-04 13:00:00	QQQ	ETF	66.7	66.77	66.66	66.66	1056705.0
2013-02-04 13:30:00	QQQ	ETF	66.66	66.68	66.54	66.62	1874798.0

> showing 50 of 10,793 rows — these rows as CSV

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