PREVIEW / etf_1min / 2012-08-23

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-08-23.parquet
  size:    1.9 MB
  rows:    100,785

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-23 04:00:00	SPY	ETF	142.24	142.24	142.24	142.24	840.0
2012-08-23 04:26:00	SPY	ETF	142.0	142.0	142.0	142.0	166.0
2012-08-23 04:51:00	SPY	ETF	142.04	142.04	142.04	142.04	1000.0
2012-08-23 05:06:00	SPY	ETF	142.09	142.09	142.09	142.09	100.0
2012-08-23 05:17:00	SPY	ETF	142.15	142.15	142.15	142.15	700.0
2012-08-23 05:20:00	SPY	ETF	142.22	142.22	142.22	142.22	150.0
2012-08-23 05:23:00	SPY	ETF	142.29	142.29	142.29	142.29	600.0
2012-08-23 05:46:00	SPY	ETF	142.25	142.25	142.25	142.25	200.0
2012-08-23 06:04:00	SPY	ETF	142.28	142.28	142.28	142.28	600.0
2012-08-23 06:06:00	SPY	ETF	142.27	142.27	142.27	142.27	200.0
2012-08-23 06:07:00	SPY	ETF	142.25	142.25	142.25	142.25	900.0
2012-08-23 06:08:00	SPY	ETF	142.24	142.24	142.23	142.23	300.0
2012-08-23 06:24:00	SPY	ETF	142.25	142.25	142.25	142.25	15000.0
2012-08-23 06:25:00	SPY	ETF	142.26	142.26	142.26	142.26	1000.0
2012-08-23 06:33:00	SPY	ETF	142.22	142.22	142.22	142.22	100.0
2012-08-23 06:37:00	SPY	ETF	142.21	142.21	142.2	142.2	400.0
2012-08-23 06:38:00	SPY	ETF	142.19	142.19	142.18	142.18	400.0
2012-08-23 06:40:00	SPY	ETF	142.17	142.17	142.14	142.14	1575.0
2012-08-23 06:41:00	SPY	ETF	142.13	142.13	142.11	142.13	1255.0
2012-08-23 06:42:00	SPY	ETF	142.14	142.14	142.14	142.14	800.0
2012-08-23 06:43:00	SPY	ETF	142.15	142.15	142.15	142.15	100.0
2012-08-23 06:45:00	SPY	ETF	142.14	142.14	142.14	142.14	600.0
2012-08-23 06:47:00	SPY	ETF	142.15	142.15	142.15	142.15	125.0
2012-08-23 06:53:00	SPY	ETF	142.15	142.18	142.15	142.18	1200.0
2012-08-23 06:55:00	SPY	ETF	142.18	142.18	142.18	142.18	1000.0
2012-08-23 06:56:00	SPY	ETF	142.18	142.19	142.18	142.19	9200.0
2012-08-23 06:59:00	SPY	ETF	142.18	142.18	142.18	142.18	9250.0
2012-08-23 07:00:00	SPY	ETF	142.18	142.18	142.18	142.18	1400.0
2012-08-23 07:01:00	SPY	ETF	142.18	142.18	142.18	142.18	300.0
2012-08-23 07:02:00	SPY	ETF	142.18	142.23	142.18	142.2	16750.0
2012-08-23 07:04:00	SPY	ETF	142.19	142.19	142.19	142.19	100.0
2012-08-23 07:06:00	SPY	ETF	142.21	142.21	142.14	142.14	800.0
2012-08-23 07:07:00	SPY	ETF	142.12	142.13	142.06	142.06	20900.0
2012-08-23 07:08:00	SPY	ETF	142.05	142.09	142.05	142.09	27100.0
2012-08-23 07:09:00	SPY	ETF	142.08	142.1	142.08	142.1	200.0
2012-08-23 07:10:00	SPY	ETF	142.08	142.08	142.04	142.04	700.0
2012-08-23 07:11:00	SPY	ETF	142.03	142.03	142.03	142.03	600.0
2012-08-23 07:12:00	SPY	ETF	142.03	142.03	142.01	142.01	1142.0
2012-08-23 07:13:00	SPY	ETF	141.99	141.99	141.94	141.96	4671.0
2012-08-23 07:14:00	SPY	ETF	141.97	141.97	141.97	141.97	200.0
2012-08-23 07:15:00	SPY	ETF	141.97	141.97	141.97	141.97	2000.0
2012-08-23 07:16:00	SPY	ETF	141.97	141.97	141.95	141.95	3083.0
2012-08-23 07:17:00	SPY	ETF	142.02	142.02	142.02	142.02	200.0
2012-08-23 07:18:00	SPY	ETF	142.01	142.01	142.01	142.01	100.0
2012-08-23 07:19:00	SPY	ETF	142.02	142.02	142.01	142.01	300.0
2012-08-23 07:21:00	SPY	ETF	142.02	142.02	142.02	142.02	200.0
2012-08-23 07:22:00	SPY	ETF	142.02	142.03	142.02	142.03	300.0
2012-08-23 07:27:00	SPY	ETF	142.02	142.02	142.02	142.02	20000.0
2012-08-23 07:28:00	SPY	ETF	142.02	142.06	142.02	142.06	2100.0
2012-08-23 07:29:00	SPY	ETF	142.05	142.05	142.05	142.05	400.0

> showing 50 of 100,785 rows — these rows as CSV

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