PREVIEW / etf_5min / 2009-09-29

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-29.parquet
  size:    685 KB
  rows:    29,342

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-09-29 04:15:00	SPY	ETF	106.23	106.23	106.18	106.18	200.0
2009-09-29 04:45:00	SPY	ETF	106.14	106.14	106.14	106.14	100.0
2009-09-29 05:00:00	SPY	ETF	106.18	106.18	106.18	106.18	100.0
2009-09-29 05:05:00	SPY	ETF	106.16	106.16	106.16	106.16	100.0
2009-09-29 05:10:00	SPY	ETF	106.14	106.14	106.14	106.14	5000.0
2009-09-29 05:15:00	SPY	ETF	106.11	106.11	106.11	106.11	100.0
2009-09-29 05:20:00	SPY	ETF	106.13	106.13	106.13	106.13	100.0
2009-09-29 05:25:00	SPY	ETF	106.15	106.15	106.15	106.15	5000.0
2009-09-29 05:35:00	SPY	ETF	106.2	106.2	106.2	106.2	100.0
2009-09-29 06:00:00	SPY	ETF	106.21	106.21	106.21	106.21	2100.0
2009-09-29 06:05:00	SPY	ETF	106.26	106.26	106.26	106.26	7500.0
2009-09-29 06:20:00	SPY	ETF	106.23	106.23	106.23	106.23	1100.0
2009-09-29 06:25:00	SPY	ETF	106.11	106.11	106.11	106.11	1000.0
2009-09-29 06:30:00	SPY	ETF	106.1	106.1	106.1	106.1	2500.0
2009-09-29 06:35:00	SPY	ETF	106.14	106.14	106.14	106.14	1000.0
2009-09-29 06:40:00	SPY	ETF	106.16	106.18	106.11	106.11	2700.0
2009-09-29 06:50:00	SPY	ETF	106.19	106.2	106.14	106.14	2600.0
2009-09-29 06:55:00	SPY	ETF	106.17	106.17	106.17	106.17	1000.0
2009-09-29 07:00:00	SPY	ETF	106.16	106.16	106.12	106.15	7801.0
2009-09-29 07:05:00	SPY	ETF	106.12	106.16	106.12	106.16	21600.0
2009-09-29 07:10:00	SPY	ETF	106.12	106.17	106.12	106.17	10425.0
2009-09-29 07:15:00	SPY	ETF	106.2	106.25	106.17	106.25	7600.0
2009-09-29 07:20:00	SPY	ETF	106.26	106.26	106.23	106.23	1535.0
2009-09-29 07:25:00	SPY	ETF	106.2	106.22	106.18	106.22	4800.0
2009-09-29 07:30:00	SPY	ETF	106.25	106.33	106.25	106.33	9100.0
2009-09-29 07:35:00	SPY	ETF	106.33	106.38	106.32	106.33	6806.0
2009-09-29 07:40:00	SPY	ETF	106.33	106.33	106.25	106.25	10900.0
2009-09-29 07:45:00	SPY	ETF	106.28	106.28	106.25	106.28	850.0
2009-09-29 07:50:00	SPY	ETF	106.3	106.3	106.23	106.23	21600.0
2009-09-29 07:55:00	SPY	ETF	106.23	106.28	106.19	106.19	7300.0
2009-09-29 08:00:00	SPY	ETF	106.18	106.19	106.1	106.13	113734.0
2009-09-29 08:05:00	SPY	ETF	106.13	106.16	106.08	106.15	501367.0
2009-09-29 08:10:00	SPY	ETF	106.15	106.18	106.15	106.17	45744.0
2009-09-29 08:15:00	SPY	ETF	106.15	106.28	106.15	106.27	161521.0
2009-09-29 08:20:00	SPY	ETF	106.27	106.35	106.22	106.31	108934.0
2009-09-29 08:25:00	SPY	ETF	106.3	106.35	106.28	106.34	37244.0
2009-09-29 08:30:00	SPY	ETF	106.33	106.33	106.31	106.33	76391.0
2009-09-29 08:35:00	SPY	ETF	106.31	106.31	106.27	106.27	35900.0
2009-09-29 08:40:00	SPY	ETF	106.27	106.35	106.26	106.3	111698.0
2009-09-29 08:45:00	SPY	ETF	106.33	106.34	106.28	106.28	116312.0
2009-09-29 08:50:00	SPY	ETF	106.29	106.32	106.26	106.27	181298.0
2009-09-29 08:55:00	SPY	ETF	106.27	106.38	106.27	106.36	175120.0
2009-09-29 09:00:00	SPY	ETF	106.36	106.57	106.36	106.43	342154.0
2009-09-29 09:05:00	SPY	ETF	106.43	106.51	106.39	106.49	155745.0
2009-09-29 09:10:00	SPY	ETF	106.51	106.77	106.03	106.74	728321.0
2009-09-29 09:15:00	SPY	ETF	106.74	106.74	106.62	106.65	68281.0
2009-09-29 09:20:00	SPY	ETF	106.66	106.67	106.57	106.6	165805.0
2009-09-29 09:25:00	SPY	ETF	106.6	106.62	106.5	106.5	391756.0
2009-09-29 09:30:00	SPY	ETF	106.51	106.65	106.37	106.58	3376553.0
2009-09-29 09:35:00	SPY	ETF	106.58	106.74	106.52	106.66	2516272.0

> showing 50 of 29,342 rows — these rows as CSV

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