PREVIEW / etf_30min / 2011-03-31

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-31.parquet
  size:    274 KB
  rows:    9,346

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-03-31 04:00:00	SPY	ETF	132.72	132.9	132.72	132.87	500.0
2011-03-31 04:30:00	SPY	ETF	132.89	132.95	132.89	132.95	700.0
2011-03-31 05:00:00	SPY	ETF	132.95	132.95	132.94	132.94	5200.0
2011-03-31 05:30:00	SPY	ETF	132.9	132.9	132.85	132.87	6700.0
2011-03-31 06:00:00	SPY	ETF	132.84	132.84	132.66	132.7	19857.0
2011-03-31 06:30:00	SPY	ETF	132.69	132.75	132.69	132.75	16400.0
2011-03-31 07:00:00	SPY	ETF	132.75	132.88	132.74	132.8	235395.0
2011-03-31 07:30:00	SPY	ETF	132.79	132.82	132.6	132.72	410471.0
2011-03-31 08:00:00	SPY	ETF	132.72	132.96	132.65	132.72	390659.0
2011-03-31 08:30:00	SPY	ETF	132.65	132.71	132.51	132.64	1005416.0
2011-03-31 09:00:00	SPY	ETF	132.64	132.64	132.48	132.6	1182983.0
2011-03-31 09:30:00	SPY	ETF	132.6	132.94	132.56	132.67	16467312.0
2011-03-31 10:00:00	SPY	ETF	132.67	132.88	132.49	132.78	10565047.0
2011-03-31 10:30:00	SPY	ETF	132.78	132.96	132.75	132.87	7753302.0
2011-03-31 11:00:00	SPY	ETF	132.87	132.895	132.61	132.615	6916156.0
2011-03-31 11:30:00	SPY	ETF	132.63	132.69	132.45	132.61	7942772.0
2011-03-31 12:00:00	SPY	ETF	132.6	132.835	132.58	132.83	4251118.0
2011-03-31 12:30:00	SPY	ETF	132.83	132.92	132.74	132.89	7294564.0
2011-03-31 13:00:00	SPY	ETF	132.89	132.92	132.83	132.86	2932462.0
2011-03-31 13:30:00	SPY	ETF	132.85	132.95	132.82	132.829	4377587.0
2011-03-31 14:00:00	SPY	ETF	132.83	132.96	132.755	132.77	6277834.0
2011-03-31 14:30:00	SPY	ETF	132.77	132.89	132.73	132.88	3735305.0
2011-03-31 15:00:00	SPY	ETF	132.88	132.88	132.75	132.795	7760052.0
2011-03-31 15:30:00	SPY	ETF	132.8	132.85	132.54	132.57	25885314.0
2011-03-31 16:00:00	SPY	ETF	132.57	132.85	132.48	132.54	11101576.0
2011-03-31 16:30:00	SPY	ETF	132.53	132.8872	132.44	132.58	2169166.0
2011-03-31 17:00:00	SPY	ETF	132.57	132.6	132.5	132.53	214060.0
2011-03-31 17:30:00	SPY	ETF	132.56	132.61	132.56	132.58	53259.0
2011-03-31 18:00:00	SPY	ETF	132.58	132.63	132.5	132.6	72551.0
2011-03-31 18:30:00	SPY	ETF	132.62	132.64	132.58	132.59	21821.0
2011-03-31 19:00:00	SPY	ETF	132.61	132.75	132.61	132.74	31026.0
2011-03-31 19:30:00	SPY	ETF	132.74	132.82	132.51	132.7	92720.0
2011-03-31 05:30:00	QQQ	ETF	57.41	57.41	57.41	57.41	204.0
2011-03-31 06:00:00	QQQ	ETF	57.4	57.4	57.29	57.29	2100.0
2011-03-31 06:30:00	QQQ	ETF	57.31	57.31	57.3	57.3	9987.0
2011-03-31 07:00:00	QQQ	ETF	57.28	57.3	57.28	57.28	25717.0
2011-03-31 07:30:00	QQQ	ETF	57.32	57.32	57.28	57.29	71500.0
2011-03-31 08:00:00	QQQ	ETF	57.34	57.42	57.11	57.29	76250.0
2011-03-31 08:30:00	QQQ	ETF	57.29	57.31	57.22	57.29	234745.0
2011-03-31 09:00:00	QQQ	ETF	57.28	57.3	57.21	57.24	298742.0
2011-03-31 09:30:00	QQQ	ETF	57.24	57.45	57.24	57.28	6211099.0
2011-03-31 10:00:00	QQQ	ETF	57.275	57.37	57.15	57.31	3228166.0
2011-03-31 10:30:00	QQQ	ETF	57.31	57.43	57.31	57.41	4366858.0
2011-03-31 11:00:00	QQQ	ETF	57.41	57.43	57.26	57.27	1678644.0
2011-03-31 11:30:00	QQQ	ETF	57.275	57.285	57.16	57.21	2221976.0
2011-03-31 12:00:00	QQQ	ETF	57.21	57.33	57.205	57.311	1074320.0
2011-03-31 12:30:00	QQQ	ETF	57.31	57.36	57.26	57.34	803644.0
2011-03-31 13:00:00	QQQ	ETF	57.34	57.38	57.335	57.36	1334611.0
2011-03-31 13:30:00	QQQ	ETF	57.37	57.42	57.345	57.35	673956.0
2011-03-31 14:00:00	QQQ	ETF	57.3499	57.46	57.34	57.35	2693776.0

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

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