PREVIEW / etf_1min / 2010-01-29

all etf 1-min files

  file:    by_date/etf_1min/2010/2010-01-29.parquet
  size:    2.0 MB
  rows:    101,822

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-01-29 04:15:00	SPY	ETF	108.52	108.52	108.52	108.52	200.0
2010-01-29 04:17:00	SPY	ETF	108.5	108.5	108.44	108.44	300.0
2010-01-29 04:19:00	SPY	ETF	108.52	108.52	108.47	108.47	200.0
2010-01-29 04:21:00	SPY	ETF	108.44	108.44	108.44	108.44	100.0
2010-01-29 04:23:00	SPY	ETF	108.44	108.44	108.44	108.44	100.0
2010-01-29 04:49:00	SPY	ETF	108.46	108.46	108.46	108.46	458.0
2010-01-29 04:58:00	SPY	ETF	108.35	108.35	108.33	108.33	600.0
2010-01-29 05:02:00	SPY	ETF	108.37	108.37	108.37	108.37	2500.0
2010-01-29 05:03:00	SPY	ETF	108.35	108.35	108.35	108.35	500.0
2010-01-29 05:07:00	SPY	ETF	108.37	108.37	108.37	108.37	500.0
2010-01-29 05:11:00	SPY	ETF	108.39	108.4	108.32	108.32	1000.0
2010-01-29 05:12:00	SPY	ETF	108.3	108.3	108.3	108.3	300.0
2010-01-29 05:19:00	SPY	ETF	108.25	108.25	108.24	108.24	2500.0
2010-01-29 05:22:00	SPY	ETF	108.19	108.19	108.19	108.19	300.0
2010-01-29 05:23:00	SPY	ETF	108.22	108.25	108.22	108.25	200.0
2010-01-29 05:35:00	SPY	ETF	108.33	108.33	108.33	108.33	500.0
2010-01-29 05:39:00	SPY	ETF	108.39	108.39	108.39	108.39	200.0
2010-01-29 05:47:00	SPY	ETF	108.46	108.5	108.46	108.5	77600.0
2010-01-29 05:48:00	SPY	ETF	108.5	108.5	108.5	108.5	300.0
2010-01-29 05:49:00	SPY	ETF	108.5	108.5	108.5	108.5	12000.0
2010-01-29 05:50:00	SPY	ETF	108.5	108.5	108.5	108.5	200.0
2010-01-29 05:53:00	SPY	ETF	108.6	108.6	108.59	108.59	800.0
2010-01-29 05:54:00	SPY	ETF	108.59	108.59	108.58	108.58	200.0
2010-01-29 05:55:00	SPY	ETF	108.65	108.67	108.65	108.67	9900.0
2010-01-29 05:56:00	SPY	ETF	108.63	108.63	108.63	108.63	100.0
2010-01-29 06:01:00	SPY	ETF	108.55	108.55	108.55	108.55	600.0
2010-01-29 06:09:00	SPY	ETF	108.6	108.6	108.6	108.6	1500.0
2010-01-29 06:10:00	SPY	ETF	108.63	108.63	108.63	108.63	1000.0
2010-01-29 06:12:00	SPY	ETF	108.67	108.67	108.67	108.67	100.0
2010-01-29 06:20:00	SPY	ETF	108.62	108.62	108.62	108.62	100.0
2010-01-29 06:22:00	SPY	ETF	108.76	108.76	108.76	108.76	200.0
2010-01-29 06:28:00	SPY	ETF	108.8	108.8	108.8	108.8	100.0
2010-01-29 06:31:00	SPY	ETF	108.78	108.78	108.78	108.78	1200.0
2010-01-29 06:33:00	SPY	ETF	108.82	108.85	108.82	108.85	11100.0
2010-01-29 06:34:00	SPY	ETF	108.84	108.84	108.82	108.82	500.0
2010-01-29 06:37:00	SPY	ETF	108.82	108.82	108.79	108.79	2600.0
2010-01-29 06:38:00	SPY	ETF	108.82	108.82	108.82	108.82	300.0
2010-01-29 06:39:00	SPY	ETF	108.82	108.85	108.82	108.85	6200.0
2010-01-29 06:42:00	SPY	ETF	108.82	108.82	108.82	108.82	500.0
2010-01-29 06:43:00	SPY	ETF	108.79	108.79	108.78	108.78	27400.0
2010-01-29 06:46:00	SPY	ETF	108.78	108.78	108.78	108.78	300.0
2010-01-29 06:53:00	SPY	ETF	108.72	108.72	108.72	108.72	1800.0
2010-01-29 06:56:00	SPY	ETF	108.7	108.7	108.7	108.7	200.0
2010-01-29 07:00:00	SPY	ETF	108.65	108.65	108.62	108.62	5150.0
2010-01-29 07:01:00	SPY	ETF	108.65	108.65	108.65	108.65	2368.0
2010-01-29 07:02:00	SPY	ETF	108.64	108.64	108.62	108.62	5000.0
2010-01-29 07:03:00	SPY	ETF	108.65	108.65	108.64	108.65	11700.0
2010-01-29 07:04:00	SPY	ETF	108.65	108.67	108.64	108.64	33200.0
2010-01-29 07:05:00	SPY	ETF	108.66	108.66	108.65	108.65	1800.0
2010-01-29 07:06:00	SPY	ETF	108.68	108.68	108.61	108.65	4400.0

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

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