PREVIEW / etf_1min / 2012-08-24

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-08-24.parquet
  size:    1.8 MB
  rows:    92,030

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-24 04:00:00	SPY	ETF	140.38	140.6	140.38	140.6	600.0
2012-08-24 04:22:00	SPY	ETF	140.59	140.59	140.59	140.59	200.0
2012-08-24 04:34:00	SPY	ETF	140.5	140.5	140.5	140.5	100.0
2012-08-24 05:11:00	SPY	ETF	140.71	140.71	140.71	140.71	200.0
2012-08-24 05:55:00	SPY	ETF	140.66	140.66	140.66	140.66	400.0
2012-08-24 05:57:00	SPY	ETF	140.66	140.66	140.66	140.66	550.0
2012-08-24 06:12:00	SPY	ETF	140.64	140.64	140.64	140.64	200.0
2012-08-24 06:28:00	SPY	ETF	140.55	140.55	140.55	140.55	250.0
2012-08-24 06:34:00	SPY	ETF	140.54	140.54	140.54	140.54	100.0
2012-08-24 06:45:00	SPY	ETF	140.53	140.53	140.53	140.53	100.0
2012-08-24 06:50:00	SPY	ETF	140.53	140.53	140.53	140.53	425.0
2012-08-24 06:53:00	SPY	ETF	140.49	140.49	140.48	140.48	200.0
2012-08-24 06:55:00	SPY	ETF	140.51	140.51	140.51	140.51	200.0
2012-08-24 06:57:00	SPY	ETF	140.51	140.51	140.51	140.51	200.0
2012-08-24 06:58:00	SPY	ETF	140.54	140.54	140.54	140.54	200.0
2012-08-24 07:00:00	SPY	ETF	140.5	140.52	140.5	140.52	395.0
2012-08-24 07:01:00	SPY	ETF	140.5	140.5	140.48	140.48	400.0
2012-08-24 07:02:00	SPY	ETF	140.48	140.48	140.48	140.48	100.0
2012-08-24 07:03:00	SPY	ETF	140.48	140.48	140.48	140.48	100.0
2012-08-24 07:04:00	SPY	ETF	140.48	140.48	140.47	140.48	800.0
2012-08-24 07:05:00	SPY	ETF	140.5	140.5	140.5	140.5	10000.0
2012-08-24 07:07:00	SPY	ETF	140.48	140.48	140.48	140.48	800.0
2012-08-24 07:13:00	SPY	ETF	140.54	140.54	140.54	140.54	300.0
2012-08-24 07:15:00	SPY	ETF	140.59	140.59	140.59	140.59	400.0
2012-08-24 07:16:00	SPY	ETF	140.57	140.57	140.57	140.57	2100.0
2012-08-24 07:17:00	SPY	ETF	140.57	140.57	140.54	140.54	700.0
2012-08-24 07:18:00	SPY	ETF	140.5	140.5	140.5	140.5	100.0
2012-08-24 07:21:00	SPY	ETF	140.49	140.49	140.49	140.49	1000.0
2012-08-24 07:22:00	SPY	ETF	140.46	140.46	140.41	140.42	1225.0
2012-08-24 07:23:00	SPY	ETF	140.41	140.45	140.41	140.45	1600.0
2012-08-24 07:24:00	SPY	ETF	140.43	140.43	140.43	140.43	1000.0
2012-08-24 07:25:00	SPY	ETF	140.41	140.42	140.4	140.4	1600.0
2012-08-24 07:26:00	SPY	ETF	140.37	140.37	140.36	140.36	495.0
2012-08-24 07:27:00	SPY	ETF	140.36	140.36	140.31	140.31	6607.0
2012-08-24 07:28:00	SPY	ETF	140.31	140.31	140.28	140.28	4000.0
2012-08-24 07:29:00	SPY	ETF	140.27	140.33	140.27	140.33	1491.0
2012-08-24 07:30:00	SPY	ETF	140.31	140.35	140.31	140.35	101100.0
2012-08-24 07:31:00	SPY	ETF	140.35	140.35	140.33	140.33	5500.0
2012-08-24 07:32:00	SPY	ETF	140.33	140.33	140.31	140.33	1350.0
2012-08-24 07:33:00	SPY	ETF	140.31	140.33	140.3	140.3	12250.0
2012-08-24 07:34:00	SPY	ETF	140.3	140.34	140.3	140.34	1500.0
2012-08-24 07:36:00	SPY	ETF	140.37	140.37	140.36	140.36	1800.0
2012-08-24 07:38:00	SPY	ETF	140.35	140.36	140.35	140.36	1500.0
2012-08-24 07:39:00	SPY	ETF	140.36	140.38	140.36	140.38	1600.0
2012-08-24 07:40:00	SPY	ETF	140.4	140.4	140.38	140.38	800.0
2012-08-24 07:41:00	SPY	ETF	140.38	140.38	140.38	140.38	150.0
2012-08-24 07:42:00	SPY	ETF	140.39	140.39	140.39	140.39	4000.0
2012-08-24 07:44:00	SPY	ETF	140.39	140.39	140.39	140.39	200.0
2012-08-24 07:45:00	SPY	ETF	140.39	140.39	140.39	140.39	100.0
2012-08-24 07:46:00	SPY	ETF	140.39	140.39	140.39	140.39	800.0

> showing 50 of 92,030 rows — these rows as CSV

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