PREVIEW / etf_1min / 2009-10-30

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-10-30.parquet
  size:    2.0 MB
  rows:    103,545

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-10-30 04:15:00	SPY	ETF	106.24	106.24	106.23	106.23	500.0
2009-10-30 04:16:00	SPY	ETF	106.19	106.19	106.16	106.16	200.0
2009-10-30 04:17:00	SPY	ETF	106.15	106.15	106.15	106.15	100.0
2009-10-30 04:18:00	SPY	ETF	106.12	106.12	106.12	106.12	200.0
2009-10-30 04:20:00	SPY	ETF	106.1	106.1	106.1	106.1	1100.0
2009-10-30 04:23:00	SPY	ETF	106.08	106.08	106.08	106.08	106.0
2009-10-30 04:49:00	SPY	ETF	106.31	106.31	106.31	106.31	100.0
2009-10-30 04:50:00	SPY	ETF	106.32	106.33	106.32	106.33	400.0
2009-10-30 05:01:00	SPY	ETF	106.38	106.38	106.38	106.38	100.0
2009-10-30 05:18:00	SPY	ETF	106.43	106.43	106.43	106.43	100.0
2009-10-30 05:22:00	SPY	ETF	106.5	106.5	106.5	106.5	100.0
2009-10-30 05:44:00	SPY	ETF	106.3	106.3	106.3	106.3	1000.0
2009-10-30 05:46:00	SPY	ETF	106.25	106.25	106.25	106.25	100.0
2009-10-30 05:56:00	SPY	ETF	106.22	106.22	106.21	106.21	1100.0
2009-10-30 06:05:00	SPY	ETF	106.28	106.28	106.28	106.28	2000.0
2009-10-30 06:26:00	SPY	ETF	106.27	106.27	106.27	106.27	100.0
2009-10-30 06:49:00	SPY	ETF	106.25	106.25	106.25	106.25	450.0
2009-10-30 07:00:00	SPY	ETF	106.28	106.28	106.27	106.27	2800.0
2009-10-30 07:01:00	SPY	ETF	106.29	106.32	106.29	106.32	2413.0
2009-10-30 07:02:00	SPY	ETF	106.33	106.34	106.28	106.28	2600.0
2009-10-30 07:03:00	SPY	ETF	106.31	106.32	106.3	106.32	1200.0
2009-10-30 07:04:00	SPY	ETF	106.31	106.31	106.25	106.25	3200.0
2009-10-30 07:06:00	SPY	ETF	106.27	106.27	106.24	106.25	1300.0
2009-10-30 07:07:00	SPY	ETF	106.27	106.27	106.27	106.27	500.0
2009-10-30 07:09:00	SPY	ETF	106.27	106.27	106.23	106.23	6840.0
2009-10-30 07:11:00	SPY	ETF	106.28	106.28	106.28	106.28	900.0
2009-10-30 07:13:00	SPY	ETF	106.29	106.29	106.28	106.28	1957.0
2009-10-30 07:14:00	SPY	ETF	106.28	106.28	106.27	106.27	22743.0
2009-10-30 07:15:00	SPY	ETF	106.27	106.27	106.27	106.27	2600.0
2009-10-30 07:16:00	SPY	ETF	106.32	106.32	106.32	106.32	2500.0
2009-10-30 07:17:00	SPY	ETF	106.28	106.28	106.25	106.25	4100.0
2009-10-30 07:19:00	SPY	ETF	106.25	106.25	106.23	106.23	5299.0
2009-10-30 07:20:00	SPY	ETF	106.23	106.3	106.23	106.3	9693.0
2009-10-30 07:22:00	SPY	ETF	106.26	106.27	106.26	106.27	2000.0
2009-10-30 07:23:00	SPY	ETF	106.28	106.28	106.28	106.28	100.0
2009-10-30 07:24:00	SPY	ETF	106.29	106.29	106.29	106.29	100.0
2009-10-30 07:26:00	SPY	ETF	106.28	106.29	106.27	106.29	2300.0
2009-10-30 07:27:00	SPY	ETF	106.29	106.29	106.26	106.26	26478.0
2009-10-30 07:28:00	SPY	ETF	106.27	106.27	106.27	106.27	800.0
2009-10-30 07:29:00	SPY	ETF	106.26	106.27	106.26	106.26	12744.0
2009-10-30 07:30:00	SPY	ETF	106.24	106.24	106.15	106.15	18400.0
2009-10-30 07:31:00	SPY	ETF	106.15	106.15	106.1	106.13	16113.0
2009-10-30 07:32:00	SPY	ETF	106.1	106.12	106.1	106.12	21802.0
2009-10-30 07:33:00	SPY	ETF	106.12	106.12	106.1	106.12	3180.0
2009-10-30 07:34:00	SPY	ETF	106.12	106.12	106.12	106.12	3200.0
2009-10-30 07:35:00	SPY	ETF	106.12	106.12	106.1	106.11	3900.0
2009-10-30 07:36:00	SPY	ETF	106.1	106.12	106.08	106.12	3500.0
2009-10-30 07:37:00	SPY	ETF	106.12	106.15	106.1	106.15	7703.0
2009-10-30 07:39:00	SPY	ETF	106.13	106.15	106.13	106.15	7501.0
2009-10-30 07:40:00	SPY	ETF	106.17	106.18	106.15	106.15	81100.0

> showing 50 of 103,545 rows — these rows as CSV

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