PREVIEW / etf_1min / 2009-07-27

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-07-27.parquet
  size:    1.6 MB
  rows:    89,941

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
2009-07-27 04:38:00	SPY	ETF	98.3	98.3	98.3	98.3	150.0
2009-07-27 05:16:00	SPY	ETF	98.25	98.25	98.25	98.25	12600.0
2009-07-27 05:27:00	SPY	ETF	98.25	98.25	98.25	98.25	12400.0
2009-07-27 05:52:00	SPY	ETF	98.4	98.4	98.4	98.4	600.0
2009-07-27 05:58:00	SPY	ETF	98.5	98.5	98.5	98.5	120.0
2009-07-27 06:29:00	SPY	ETF	98.5	98.5	98.5	98.5	6000.0
2009-07-27 06:33:00	SPY	ETF	98.48	98.48	98.48	98.48	100.0
2009-07-27 06:39:00	SPY	ETF	98.5	98.5	98.5	98.5	5000.0
2009-07-27 06:43:00	SPY	ETF	98.54	98.54	98.54	98.54	250.0
2009-07-27 06:58:00	SPY	ETF	98.64	98.64	98.64	98.64	5000.0
2009-07-27 07:00:00	SPY	ETF	98.6	98.6	98.55	98.55	24000.0
2009-07-27 07:02:00	SPY	ETF	98.56	98.56	98.56	98.56	160.0
2009-07-27 07:03:00	SPY	ETF	98.56	98.59	98.55	98.59	2600.0
2009-07-27 07:05:00	SPY	ETF	98.56	98.56	98.56	98.56	500.0
2009-07-27 07:07:00	SPY	ETF	98.52	98.52	98.52	98.52	700.0
2009-07-27 07:08:00	SPY	ETF	98.5	98.5	98.48	98.48	44200.0
2009-07-27 07:09:00	SPY	ETF	98.48	98.48	98.48	98.48	5800.0
2009-07-27 07:11:00	SPY	ETF	98.47	98.47	98.46	98.46	220.0
2009-07-27 07:12:00	SPY	ETF	98.46	98.46	98.46	98.46	150.0
2009-07-27 07:13:00	SPY	ETF	98.45	98.45	98.41	98.41	494.0
2009-07-27 07:14:00	SPY	ETF	98.38	98.38	98.38	98.38	900.0
2009-07-27 07:15:00	SPY	ETF	98.39	98.39	98.36	98.36	250.0
2009-07-27 07:16:00	SPY	ETF	98.33	98.33	98.33	98.33	3500.0
2009-07-27 07:17:00	SPY	ETF	98.36	98.36	98.36	98.36	100.0
2009-07-27 07:18:00	SPY	ETF	98.36	98.36	98.36	98.36	400.0
2009-07-27 07:19:00	SPY	ETF	98.38	98.38	98.38	98.38	100.0
2009-07-27 07:20:00	SPY	ETF	98.39	98.39	98.39	98.39	800.0
2009-07-27 07:21:00	SPY	ETF	98.44	98.44	98.44	98.44	500.0
2009-07-27 07:22:00	SPY	ETF	98.4	98.44	98.4	98.44	600.0
2009-07-27 07:23:00	SPY	ETF	98.41	98.44	98.41	98.44	1300.0
2009-07-27 07:24:00	SPY	ETF	98.39	98.39	98.37	98.37	900.0
2009-07-27 07:26:00	SPY	ETF	98.38	98.38	98.38	98.38	100.0
2009-07-27 07:27:00	SPY	ETF	98.39	98.39	98.39	98.39	2220.0
2009-07-27 07:28:00	SPY	ETF	98.37	98.37	98.36	98.36	800.0
2009-07-27 07:29:00	SPY	ETF	98.32	98.32	98.28	98.28	800.0
2009-07-27 07:30:00	SPY	ETF	98.29	98.29	98.26	98.26	1100.0
2009-07-27 07:32:00	SPY	ETF	98.23	98.23	98.16	98.16	15400.0
2009-07-27 07:33:00	SPY	ETF	98.17	98.21	98.17	98.21	300.0
2009-07-27 07:35:00	SPY	ETF	98.21	98.24	98.21	98.24	1440.0
2009-07-27 07:36:00	SPY	ETF	98.24	98.25	98.22	98.22	54650.0
2009-07-27 07:37:00	SPY	ETF	98.25	98.29	98.25	98.26	13000.0
2009-07-27 07:39:00	SPY	ETF	98.29	98.29	98.29	98.29	200.0
2009-07-27 07:40:00	SPY	ETF	98.21	98.23	98.21	98.23	400.0
2009-07-27 07:41:00	SPY	ETF	98.21	98.21	98.19	98.21	21300.0
2009-07-27 07:42:00	SPY	ETF	98.21	98.21	98.21	98.21	500.0
2009-07-27 07:43:00	SPY	ETF	98.18	98.21	98.18	98.21	17800.0
2009-07-27 07:45:00	SPY	ETF	98.24	98.24	98.2	98.2	6800.0
2009-07-27 07:47:00	SPY	ETF	98.21	98.24	98.21	98.23	13071.0
2009-07-27 07:48:00	SPY	ETF	98.24	98.24	98.23	98.23	1120.0
2009-07-27 07:49:00	SPY	ETF	98.24	98.24	98.24	98.24	2331.0

> showing 50 of 89,941 rows — these rows as CSV

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