PREVIEW / etf_30min / 2012-08-08

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-08.parquet
  size:    278 KB
  rows:    9,383

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
2012-08-08 04:00:00	SPY	ETF	140.0	140.1	140.0	140.02	1654.0
2012-08-08 04:30:00	SPY	ETF	139.98	139.98	139.94	139.98	474.0
2012-08-08 05:00:00	SPY	ETF	139.96	139.96	139.89	139.92	1500.0
2012-08-08 05:30:00	SPY	ETF	139.97	139.97	139.83	139.83	700.0
2012-08-08 06:00:00	SPY	ETF	139.87	140.01	139.84	140.0	1162.0
2012-08-08 06:30:00	SPY	ETF	140.0	140.1	139.9	139.9	11638.0
2012-08-08 07:00:00	SPY	ETF	139.92	139.99	139.9	139.99	120263.0
2012-08-08 07:30:00	SPY	ETF	139.96	140.02	139.87	139.87	44038.0
2012-08-08 08:00:00	SPY	ETF	139.89	139.92	139.71	139.76	768942.0
2012-08-08 08:30:00	SPY	ETF	139.77	139.88	139.67	139.71	1003384.0
2012-08-08 09:00:00	SPY	ETF	139.71	139.89	139.7	139.85	521917.0
2012-08-08 09:30:00	SPY	ETF	139.85	140.18	139.81	140.065	12372172.0
2012-08-08 10:00:00	SPY	ETF	140.06	140.24	139.98	140.15	8178804.0
2012-08-08 10:30:00	SPY	ETF	140.15	140.21	139.98	140.15	7163955.0
2012-08-08 11:00:00	SPY	ETF	140.15	140.59	140.14	140.56	8519479.0
2012-08-08 11:30:00	SPY	ETF	140.56	140.65	140.47	140.48	5652180.0
2012-08-08 12:00:00	SPY	ETF	140.47	140.58	140.43	140.48	2738015.0
2012-08-08 12:30:00	SPY	ETF	140.48	140.51	140.24	140.42	3816459.0
2012-08-08 13:00:00	SPY	ETF	140.43	140.57	140.4	140.47	3499376.0
2012-08-08 13:30:00	SPY	ETF	140.47	140.53	140.36	140.39	2336529.0
2012-08-08 14:00:00	SPY	ETF	140.4	140.42	140.17	140.291	6042538.0
2012-08-08 14:30:00	SPY	ETF	140.28	140.38	140.23	140.275	3737382.0
2012-08-08 15:00:00	SPY	ETF	140.28	140.54	140.26	140.47	5892928.0
2012-08-08 15:30:00	SPY	ETF	140.48	140.56	140.33	140.47	8300234.0
2012-08-08 16:00:00	SPY	ETF	140.48	140.55	140.1	140.45	6525167.0
2012-08-08 16:30:00	SPY	ETF	140.45	140.565	140.34	140.4	141773.0
2012-08-08 17:00:00	SPY	ETF	140.4	140.4	140.33	140.35	34943.0
2012-08-08 17:30:00	SPY	ETF	140.35	140.37	140.32	140.34	15517.0
2012-08-08 18:00:00	SPY	ETF	140.36	140.4	140.35	140.37	1600.0
2012-08-08 18:30:00	SPY	ETF	140.41	140.42	140.35	140.36	12501.0
2012-08-08 19:00:00	SPY	ETF	140.35	140.37	140.32	140.32	35370.0
2012-08-08 19:30:00	SPY	ETF	140.32	140.35	140.31	140.35	55510.0
2012-08-08 20:00:00	SPY	ETF	140.35	140.35	140.35	140.35	1000.0
2012-08-08 07:00:00	QQQ	ETF	66.55	66.55	66.53	66.55	3600.0
2012-08-08 07:30:00	QQQ	ETF	66.54	66.54	66.5	66.51	11225.0
2012-08-08 08:00:00	QQQ	ETF	66.51	66.51	66.42	66.45	596900.0
2012-08-08 08:30:00	QQQ	ETF	66.44	66.49	66.41	66.41	39587.0
2012-08-08 09:00:00	QQQ	ETF	66.42	66.5	66.42	66.48	435693.0
2012-08-08 09:30:00	QQQ	ETF	66.48	66.66	66.41	66.48	3914649.0
2012-08-08 10:00:00	QQQ	ETF	66.48	66.61	66.445	66.46	1677012.0
2012-08-08 10:30:00	QQQ	ETF	66.47	66.54	66.37	66.49	1250174.0
2012-08-08 11:00:00	QQQ	ETF	66.49	66.74	66.45	66.71	2321836.0
2012-08-08 11:30:00	QQQ	ETF	66.72	66.76	66.69	66.71	1938433.0
2012-08-08 12:00:00	QQQ	ETF	66.7	66.762	66.68	66.6999	686553.0
2012-08-08 12:30:00	QQQ	ETF	66.699	66.7301	66.53	66.64	913941.0
2012-08-08 13:00:00	QQQ	ETF	66.64	66.69	66.57	66.642	853255.0
2012-08-08 13:30:00	QQQ	ETF	66.65	66.67	66.6	66.63	439776.0
2012-08-08 14:00:00	QQQ	ETF	66.64	66.65	66.53	66.58	723974.0
2012-08-08 14:30:00	QQQ	ETF	66.58	66.64	66.54	66.56	713782.0
2012-08-08 15:00:00	QQQ	ETF	66.56	66.66	66.55	66.63	890751.0

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

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