PREVIEW / etf_1min / 2010-06-09

all etf 1-min files

  file:    by_date/etf_1min/2010/2010-06-09.parquet
  size:    1.9 MB
  rows:    101,473

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
2010-06-09 04:16:00	SPY	ETF	106.39	106.39	106.39	106.39	100.0
2010-06-09 04:25:00	SPY	ETF	106.41	106.41	106.41	106.41	100.0
2010-06-09 04:28:00	SPY	ETF	106.31	106.31	106.31	106.31	100.0
2010-06-09 04:29:00	SPY	ETF	106.33	106.33	106.33	106.33	2000.0
2010-06-09 04:33:00	SPY	ETF	106.26	106.26	106.21	106.21	250.0
2010-06-09 04:52:00	SPY	ETF	106.32	106.32	106.32	106.32	100.0
2010-06-09 04:59:00	SPY	ETF	106.23	106.23	106.23	106.23	100.0
2010-06-09 05:05:00	SPY	ETF	106.2	106.2	106.2	106.2	2000.0
2010-06-09 05:10:00	SPY	ETF	106.13	106.13	106.13	106.13	100.0
2010-06-09 05:20:00	SPY	ETF	106.28	106.28	106.28	106.28	100.0
2010-06-09 05:26:00	SPY	ETF	106.23	106.23	106.23	106.23	2000.0
2010-06-09 05:28:00	SPY	ETF	106.11	106.11	106.11	106.11	100.0
2010-06-09 05:29:00	SPY	ETF	106.01	106.01	106.01	106.01	100.0
2010-06-09 05:32:00	SPY	ETF	105.98	105.98	105.98	105.98	2000.0
2010-06-09 05:37:00	SPY	ETF	106.0	106.0	106.0	106.0	2000.0
2010-06-09 05:50:00	SPY	ETF	106.12	106.14	106.12	106.14	10000.0
2010-06-09 05:59:00	SPY	ETF	106.2	106.22	106.2	106.22	3200.0
2010-06-09 06:00:00	SPY	ETF	106.19	106.19	106.16	106.16	200.0
2010-06-09 06:01:00	SPY	ETF	106.24	106.24	106.19	106.19	1500.0
2010-06-09 06:08:00	SPY	ETF	106.2	106.2	106.2	106.2	5000.0
2010-06-09 06:14:00	SPY	ETF	106.18	106.18	106.18	106.18	1000.0
2010-06-09 06:21:00	SPY	ETF	106.4	106.4	106.4	106.4	1400.0
2010-06-09 06:22:00	SPY	ETF	106.38	106.38	106.38	106.38	100.0
2010-06-09 06:25:00	SPY	ETF	106.39	106.39	106.38	106.38	7000.0
2010-06-09 06:26:00	SPY	ETF	106.47	106.48	106.47	106.48	600.0
2010-06-09 06:30:00	SPY	ETF	106.4	106.4	106.4	106.4	2000.0
2010-06-09 06:33:00	SPY	ETF	106.5	106.5	106.5	106.5	2100.0
2010-06-09 06:40:00	SPY	ETF	106.44	106.44	106.44	106.44	100.0
2010-06-09 06:41:00	SPY	ETF	106.41	106.41	106.41	106.41	250.0
2010-06-09 06:45:00	SPY	ETF	106.5	106.5	106.46	106.46	2800.0
2010-06-09 06:46:00	SPY	ETF	106.53	106.53	106.53	106.53	600.0
2010-06-09 06:47:00	SPY	ETF	106.55	106.57	106.55	106.57	4700.0
2010-06-09 06:48:00	SPY	ETF	106.58	106.58	106.58	106.58	3000.0
2010-06-09 06:50:00	SPY	ETF	106.6	106.6	106.6	106.6	2000.0
2010-06-09 06:51:00	SPY	ETF	106.62	106.62	106.62	106.62	1000.0
2010-06-09 06:52:00	SPY	ETF	106.65	106.65	106.65	106.65	700.0
2010-06-09 06:53:00	SPY	ETF	106.65	106.65	106.65	106.65	500.0
2010-06-09 06:56:00	SPY	ETF	106.65	106.67	106.64	106.64	4400.0
2010-06-09 06:58:00	SPY	ETF	106.65	106.65	106.65	106.65	3150.0
2010-06-09 06:59:00	SPY	ETF	106.64	106.64	106.64	106.64	650.0
2010-06-09 07:00:00	SPY	ETF	106.57	106.62	106.55	106.62	13600.0
2010-06-09 07:01:00	SPY	ETF	106.63	106.67	106.63	106.67	100000.0
2010-06-09 07:02:00	SPY	ETF	106.7	106.71	106.7	106.71	1750.0
2010-06-09 07:03:00	SPY	ETF	106.75	106.77	106.74	106.74	2900.0
2010-06-09 07:04:00	SPY	ETF	106.77	106.77	106.76	106.76	3500.0
2010-06-09 07:06:00	SPY	ETF	106.76	106.77	106.76	106.77	4000.0
2010-06-09 07:07:00	SPY	ETF	106.74	106.74	106.69	106.69	605.0
2010-06-09 07:09:00	SPY	ETF	106.74	106.77	106.74	106.77	2500.0
2010-06-09 07:10:00	SPY	ETF	106.77	106.78	106.77	106.78	1900.0
2010-06-09 07:11:00	SPY	ETF	106.72	106.72	106.72	106.72	150.0

> showing 50 of 101,473 rows — these rows as CSV

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