PREVIEW / etf_1min / 2011-01-07

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-01-07.parquet
  size:    2.1 MB
  rows:    105,766

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-01-07 04:00:00	SPY	ETF	127.15	127.15	127.12	127.12	500.0
2011-01-07 04:02:00	SPY	ETF	127.11	127.11	127.11	127.11	100.0
2011-01-07 04:21:00	SPY	ETF	127.22	127.22	127.22	127.22	100.0
2011-01-07 04:34:00	SPY	ETF	127.2	127.2	127.2	127.2	100.0
2011-01-07 05:18:00	SPY	ETF	127.18	127.18	127.18	127.18	100.0
2011-01-07 05:26:00	SPY	ETF	127.11	127.11	127.03	127.03	1400.0
2011-01-07 05:27:00	SPY	ETF	127.01	127.01	127.01	127.01	660.0
2011-01-07 05:45:00	SPY	ETF	127.2	127.2	127.2	127.2	500.0
2011-01-07 06:01:00	SPY	ETF	127.19	127.19	127.19	127.19	200.0
2011-01-07 06:04:00	SPY	ETF	127.17	127.17	127.17	127.17	2000.0
2011-01-07 06:09:00	SPY	ETF	127.15	127.15	127.15	127.15	100.0
2011-01-07 06:29:00	SPY	ETF	127.17	127.17	127.17	127.17	100.0
2011-01-07 06:43:00	SPY	ETF	127.27	127.27	127.27	127.27	500.0
2011-01-07 06:53:00	SPY	ETF	127.38	127.38	127.38	127.38	150.0
2011-01-07 06:55:00	SPY	ETF	127.42	127.42	127.42	127.42	1400.0
2011-01-07 06:56:00	SPY	ETF	127.42	127.44	127.42	127.44	4500.0
2011-01-07 06:57:00	SPY	ETF	127.44	127.44	127.44	127.44	1500.0
2011-01-07 06:58:00	SPY	ETF	127.44	127.44	127.44	127.44	1600.0
2011-01-07 07:00:00	SPY	ETF	127.45	127.45	127.45	127.45	700.0
2011-01-07 07:03:00	SPY	ETF	127.41	127.42	127.41	127.42	200.0
2011-01-07 07:04:00	SPY	ETF	127.43	127.43	127.43	127.43	5000.0
2011-01-07 07:07:00	SPY	ETF	127.42	127.42	127.42	127.42	200.0
2011-01-07 07:08:00	SPY	ETF	127.42	127.42	127.42	127.42	100.0
2011-01-07 07:11:00	SPY	ETF	127.37	127.37	127.37	127.37	1435.0
2011-01-07 07:12:00	SPY	ETF	127.38	127.38	127.38	127.38	200.0
2011-01-07 07:13:00	SPY	ETF	127.37	127.37	127.37	127.37	1365.0
2011-01-07 07:14:00	SPY	ETF	127.38	127.38	127.38	127.38	450.0
2011-01-07 07:17:00	SPY	ETF	127.41	127.41	127.41	127.41	200.0
2011-01-07 07:18:00	SPY	ETF	127.37	127.37	127.37	127.37	400.0
2011-01-07 07:19:00	SPY	ETF	127.36	127.36	127.35	127.35	200.0
2011-01-07 07:21:00	SPY	ETF	127.36	127.36	127.36	127.36	15000.0
2011-01-07 07:22:00	SPY	ETF	127.36	127.36	127.35	127.36	15500.0
2011-01-07 07:23:00	SPY	ETF	127.35	127.35	127.35	127.35	100.0
2011-01-07 07:24:00	SPY	ETF	127.39	127.4	127.39	127.4	1500.0
2011-01-07 07:25:00	SPY	ETF	127.41	127.41	127.41	127.41	170.0
2011-01-07 07:28:00	SPY	ETF	127.43	127.43	127.43	127.43	1000.0
2011-01-07 07:30:00	SPY	ETF	127.41	127.41	127.41	127.41	1615.0
2011-01-07 07:31:00	SPY	ETF	127.41	127.41	127.41	127.41	2970.0
2011-01-07 07:34:00	SPY	ETF	127.36	127.36	127.36	127.36	100.0
2011-01-07 07:36:00	SPY	ETF	127.36	127.36	127.36	127.36	1100.0
2011-01-07 07:38:00	SPY	ETF	127.34	127.34	127.3	127.3	5600.0
2011-01-07 07:39:00	SPY	ETF	127.3	127.31	127.3	127.31	15400.0
2011-01-07 07:40:00	SPY	ETF	127.32	127.33	127.32	127.33	5600.0
2011-01-07 07:41:00	SPY	ETF	127.33	127.33	127.33	127.33	9900.0
2011-01-07 07:44:00	SPY	ETF	127.36	127.36	127.33	127.33	4000.0
2011-01-07 07:45:00	SPY	ETF	127.36	127.36	127.36	127.36	870.0
2011-01-07 07:47:00	SPY	ETF	127.37	127.38	127.37	127.38	600.0
2011-01-07 07:50:00	SPY	ETF	127.36	127.38	127.36	127.38	11351.0
2011-01-07 07:51:00	SPY	ETF	127.37	127.37	127.37	127.37	700.0
2011-01-07 07:52:00	SPY	ETF	127.37	127.37	127.37	127.37	50000.0

> showing 50 of 105,766 rows — these rows as CSV

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