PREVIEW / etf_30min / 2011-03-30

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-30.parquet
  size:    281 KB
  rows:    9,329

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-30 04:00:00	SPY	ETF	132.45	132.61	132.45	132.45	6744.0
2011-03-30 04:30:00	SPY	ETF	132.44	132.48	132.39	132.48	600.0
2011-03-30 05:00:00	SPY	ETF	132.59	132.6	132.55	132.55	500.0
2011-03-30 05:30:00	SPY	ETF	132.56	132.56	132.45	132.45	17200.0
2011-03-30 06:00:00	SPY	ETF	132.51	132.55	132.51	132.55	17925.0
2011-03-30 06:30:00	SPY	ETF	132.56	132.85	132.56	132.67	59139.0
2011-03-30 07:00:00	SPY	ETF	132.69	132.83	132.66	132.77	175203.0
2011-03-30 07:30:00	SPY	ETF	132.77	132.82	132.7	132.75	240315.0
2011-03-30 08:00:00	SPY	ETF	132.75	132.81	132.62	132.62	969966.0
2011-03-30 08:30:00	SPY	ETF	132.63	132.74	131.86	132.62	631289.0
2011-03-30 09:00:00	SPY	ETF	132.62	132.69	132.48	132.53	941471.0
2011-03-30 09:30:00	SPY	ETF	132.55	132.74	132.46	132.7	17424479.0
2011-03-30 10:00:00	SPY	ETF	132.7	132.74	132.36	132.38	8515918.0
2011-03-30 10:30:00	SPY	ETF	132.38	132.74	132.37	132.73	11563436.0
2011-03-30 11:00:00	SPY	ETF	132.72	132.74	132.57	132.64	7157018.0
2011-03-30 11:30:00	SPY	ETF	132.635	132.8	132.63	132.72	5502665.0
2011-03-30 12:00:00	SPY	ETF	132.72	133.06	132.7081	132.98	11748216.0
2011-03-30 12:30:00	SPY	ETF	132.98	133.02	132.91	132.98	4521905.0
2011-03-30 13:00:00	SPY	ETF	132.98	133.16	132.97	133.02	6069206.0
2011-03-30 13:30:00	SPY	ETF	133.03	133.07	132.9	132.96	6212243.0
2011-03-30 14:00:00	SPY	ETF	132.965	133.05	132.93	133.04	3663518.0
2011-03-30 14:30:00	SPY	ETF	133.04	133.08	132.89	132.93	7160525.0
2011-03-30 15:00:00	SPY	ETF	132.93	133.01	132.85	132.89	7145537.0
2011-03-30 15:30:00	SPY	ETF	132.89	133.01	132.69	132.76	16900760.0
2011-03-30 16:00:00	SPY	ETF	132.75	133.0	132.55	132.83	11608587.0
2011-03-30 16:30:00	SPY	ETF	132.82	132.9181	132.78	132.79	4132585.0
2011-03-30 17:00:00	SPY	ETF	132.81	132.83	132.78	132.78	137930.0
2011-03-30 17:30:00	SPY	ETF	132.78	132.82	132.78	132.8	44440.0
2011-03-30 18:00:00	SPY	ETF	132.79	132.82	132.7	132.75	137269.0
2011-03-30 18:30:00	SPY	ETF	132.74	132.76	132.7	132.75	11607.0
2011-03-30 19:00:00	SPY	ETF	132.74	132.74	132.7	132.71	44790.0
2011-03-30 19:30:00	SPY	ETF	132.71	132.8	132.71	132.74	52948.0
2011-03-30 04:00:00	QQQ	ETF	57.23	57.4	57.23	57.4	4420.0
2011-03-30 05:00:00	QQQ	ETF	57.38	57.38	57.35	57.35	200.0
2011-03-30 05:30:00	QQQ	ETF	57.32	57.37	57.31	57.33	20200.0
2011-03-30 06:30:00	QQQ	ETF	57.39	57.4	57.39	57.4	4165.0
2011-03-30 07:00:00	QQQ	ETF	57.39	57.54	57.39	57.54	41086.0
2011-03-30 07:30:00	QQQ	ETF	57.52	57.53	57.48	57.49	19046.0
2011-03-30 08:00:00	QQQ	ETF	57.47	57.5	57.41	57.42	196113.0
2011-03-30 08:30:00	QQQ	ETF	57.42	57.47	57.4	57.4	151786.0
2011-03-30 09:00:00	QQQ	ETF	57.4	57.41	57.32	57.32	376236.0
2011-03-30 09:30:00	QQQ	ETF	57.33	57.42	57.16	57.3	5838964.0
2011-03-30 10:00:00	QQQ	ETF	57.3	57.31	57.08	57.08	3932259.0
2011-03-30 10:30:00	QQQ	ETF	57.09	57.31	57.09	57.2806	3411475.0
2011-03-30 11:00:00	QQQ	ETF	57.2825	57.285	57.19	57.21	2229303.0
2011-03-30 11:30:00	QQQ	ETF	57.2075	57.27	57.2	57.2338	2969534.0
2011-03-30 12:00:00	QQQ	ETF	57.24	57.41	57.23	57.38	3705766.0
2011-03-30 12:30:00	QQQ	ETF	57.37	57.39	57.33	57.365	1168527.0
2011-03-30 13:00:00	QQQ	ETF	57.368	57.43	57.36	57.38	2053901.0
2011-03-30 13:30:00	QQQ	ETF	57.38	57.4	57.32	57.34	1378349.0

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

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