PREVIEW / etf_30min / 2011-06-10

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-10.parquet
  size:    290 KB
  rows:    9,525

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-06-10 04:00:00	SPY	ETF	129.07	129.07	128.86	128.93	5886.0
2011-06-10 04:30:00	SPY	ETF	128.97	129.19	128.92	129.17	6228.0
2011-06-10 05:00:00	SPY	ETF	129.17	129.18	129.17	129.18	300.0
2011-06-10 05:30:00	SPY	ETF	129.12	129.12	129.12	129.12	500.0
2011-06-10 06:00:00	SPY	ETF	129.14	129.14	129.14	129.14	100.0
2011-06-10 06:30:00	SPY	ETF	129.1	129.1	128.85	128.9	88908.0
2011-06-10 07:00:00	SPY	ETF	128.92	128.99	128.74	128.84	196842.0
2011-06-10 07:30:00	SPY	ETF	128.84	129.07	128.81	129.02	361261.0
2011-06-10 08:00:00	SPY	ETF	129.03	129.23	128.95	128.95	638717.0
2011-06-10 08:30:00	SPY	ETF	128.96	129.12	128.761	128.81	1186259.0
2011-06-10 09:00:00	SPY	ETF	128.81	128.88	128.64	128.85	1698625.0
2011-06-10 09:30:00	SPY	ETF	128.85	128.93	128.19	128.295	23299660.0
2011-06-10 10:00:00	SPY	ETF	128.3	128.37	128.0	128.29	21419227.0
2011-06-10 10:30:00	SPY	ETF	128.28	128.3	127.73	127.87	16069262.0
2011-06-10 11:00:00	SPY	ETF	127.87	127.92	127.52	127.78	15520116.0
2011-06-10 11:30:00	SPY	ETF	127.8	127.92	127.63	127.85	9090014.0
2011-06-10 12:00:00	SPY	ETF	127.85	127.95	127.67	127.831	7507122.0
2011-06-10 12:30:00	SPY	ETF	127.84	128.02	127.8	127.87	6577688.0
2011-06-10 13:00:00	SPY	ETF	127.87	127.88	127.58	127.7	8249961.0
2011-06-10 13:30:00	SPY	ETF	127.7	127.74	127.26	127.399	11050928.0
2011-06-10 14:00:00	SPY	ETF	127.4	128.2	127.39	127.98	21582965.0
2011-06-10 14:30:00	SPY	ETF	127.99	128.37	127.79	128.35	15063337.0
2011-06-10 15:00:00	SPY	ETF	128.35	128.43	128.02	128.07	15714873.0
2011-06-10 15:30:00	SPY	ETF	128.07	128.19	127.5	127.53	33001231.0
2011-06-10 16:00:00	SPY	ETF	127.53	129.3578	127.36	127.5	19281234.0
2011-06-10 16:30:00	SPY	ETF	127.5	129.3579	127.49	127.55	3241316.0
2011-06-10 17:00:00	SPY	ETF	127.55	127.57	127.45	127.54	276903.0
2011-06-10 17:30:00	SPY	ETF	127.54	127.56	127.5	127.53	43232.0
2011-06-10 18:00:00	SPY	ETF	127.53	127.57	127.5	127.56	177258.0
2011-06-10 18:30:00	SPY	ETF	127.54	127.55	127.5	127.54	3362.0
2011-06-10 19:00:00	SPY	ETF	127.51	127.53	127.46	127.47	7845.0
2011-06-10 19:30:00	SPY	ETF	127.53	127.56	127.49	127.56	29165.0
2011-06-10 04:00:00	QQQ	ETF	55.3	55.3	55.3	55.3	100.0
2011-06-10 04:30:00	QQQ	ETF	55.31	55.39	55.3	55.39	10400.0
2011-06-10 06:30:00	QQQ	ETF	55.25	55.25	55.23	55.24	750.0
2011-06-10 07:00:00	QQQ	ETF	55.25	55.27	55.21	55.23	8960.0
2011-06-10 07:30:00	QQQ	ETF	55.25	55.27	55.25	55.27	3000.0
2011-06-10 08:00:00	QQQ	ETF	55.28	55.35	55.27	55.29	43823.0
2011-06-10 08:30:00	QQQ	ETF	55.28	55.33	55.22	55.24	105500.0
2011-06-10 09:00:00	QQQ	ETF	55.23	55.26	55.15	55.24	372078.0
2011-06-10 09:30:00	QQQ	ETF	55.24	55.34	55.13	55.19	5883435.0
2011-06-10 10:00:00	QQQ	ETF	55.19	55.21	54.99	55.08	4976855.0
2011-06-10 10:30:00	QQQ	ETF	55.08	55.1	54.78	54.83	4862773.0
2011-06-10 11:00:00	QQQ	ETF	54.83	54.89	54.68	54.8399	4021050.0
2011-06-10 11:30:00	QQQ	ETF	54.835	54.91	54.78	54.89	1555717.0
2011-06-10 12:00:00	QQQ	ETF	54.89	54.915	54.81	54.8801	1561440.0
2011-06-10 12:30:00	QQQ	ETF	54.88	54.96	54.87	54.911	975328.0
2011-06-10 13:00:00	QQQ	ETF	54.91	54.91	54.77	54.82	1270181.0
2011-06-10 13:30:00	QQQ	ETF	54.82	54.82	54.63	54.71	1948372.0
2011-06-10 14:00:00	QQQ	ETF	54.72	54.97	54.715	54.86	3334950.0

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

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