PREVIEW / etf_5min / 2009-09-24

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-24.parquet
  size:    779 KB
  rows:    32,166

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-24 04:15:00	SPY	ETF	105.87	105.9	105.87	105.88	6300.0
2009-09-24 04:20:00	SPY	ETF	105.83	105.83	105.83	105.83	100.0
2009-09-24 04:25:00	SPY	ETF	105.82	105.82	105.82	105.82	100.0
2009-09-24 04:40:00	SPY	ETF	105.95	105.95	105.95	105.95	207.0
2009-09-24 04:50:00	SPY	ETF	106.0	106.05	106.0	106.05	476.0
2009-09-24 05:00:00	SPY	ETF	106.11	106.11	106.11	106.11	700.0
2009-09-24 05:40:00	SPY	ETF	106.28	106.28	106.28	106.28	2000.0
2009-09-24 05:50:00	SPY	ETF	106.47	106.47	106.47	106.47	100.0
2009-09-24 05:55:00	SPY	ETF	106.42	106.5	106.42	106.5	1700.0
2009-09-24 06:00:00	SPY	ETF	106.4	106.4	106.4	106.4	300.0
2009-09-24 06:10:00	SPY	ETF	106.41	106.41	106.41	106.41	100.0
2009-09-24 06:30:00	SPY	ETF	106.32	106.39	106.32	106.39	300.0
2009-09-24 06:35:00	SPY	ETF	106.39	106.39	106.39	106.39	100.0
2009-09-24 06:40:00	SPY	ETF	106.39	106.39	106.37	106.37	7500.0
2009-09-24 06:45:00	SPY	ETF	106.37	106.37	106.31	106.31	3200.0
2009-09-24 06:50:00	SPY	ETF	106.32	106.32	106.32	106.32	199.0
2009-09-24 06:55:00	SPY	ETF	106.31	106.31	106.11	106.11	5900.0
2009-09-24 07:00:00	SPY	ETF	106.12	106.16	106.12	106.14	6697.0
2009-09-24 07:05:00	SPY	ETF	106.14	106.19	106.14	106.18	13603.0
2009-09-24 07:10:00	SPY	ETF	106.16	106.18	106.14	106.18	10974.0
2009-09-24 07:15:00	SPY	ETF	106.18	106.23	106.15	106.21	24402.0
2009-09-24 07:20:00	SPY	ETF	106.24	106.26	106.2	106.26	10713.0
2009-09-24 07:25:00	SPY	ETF	106.31	106.31	106.31	106.31	6552.0
2009-09-24 07:30:00	SPY	ETF	106.35	106.39	106.3	106.32	52900.0
2009-09-24 07:35:00	SPY	ETF	106.3	106.31	106.26	106.26	19407.0
2009-09-24 07:40:00	SPY	ETF	106.25	106.25	106.24	106.24	800.0
2009-09-24 07:45:00	SPY	ETF	106.26	106.3	106.26	106.3	8401.0
2009-09-24 07:50:00	SPY	ETF	106.3	106.37	106.28	106.37	49502.0
2009-09-24 07:55:00	SPY	ETF	106.37	106.41	106.35	106.36	20506.0
2009-09-24 08:00:00	SPY	ETF	106.37	106.45	106.36	106.42	213858.0
2009-09-24 08:05:00	SPY	ETF	106.41	106.45	106.4	106.43	65453.0
2009-09-24 08:10:00	SPY	ETF	106.42	106.42	106.33	106.37	139176.0
2009-09-24 08:15:00	SPY	ETF	106.37	106.48	106.37	106.48	133140.0
2009-09-24 08:20:00	SPY	ETF	106.47	106.55	106.45	106.55	632697.0
2009-09-24 08:25:00	SPY	ETF	106.55	106.57	106.46	106.54	130883.0
2009-09-24 08:30:00	SPY	ETF	106.55	106.69	106.26	106.65	1931191.0
2009-09-24 08:35:00	SPY	ETF	106.64	106.81	106.62	106.75	897405.0
2009-09-24 08:40:00	SPY	ETF	106.75	106.84	106.32	106.82	473173.0
2009-09-24 08:45:00	SPY	ETF	106.82	106.84	106.78	106.81	297820.0
2009-09-24 08:50:00	SPY	ETF	106.83	106.84	106.71	106.75	246973.0
2009-09-24 08:55:00	SPY	ETF	106.73	106.74	106.3	106.72	131651.0
2009-09-24 09:00:00	SPY	ETF	106.74	106.75	106.65	106.68	243720.0
2009-09-24 09:05:00	SPY	ETF	106.68	106.69	106.62	106.64	218961.0
2009-09-24 09:10:00	SPY	ETF	106.64	106.65	106.58	106.62	157665.0
2009-09-24 09:15:00	SPY	ETF	106.62	106.64	106.58	106.58	104668.0
2009-09-24 09:20:00	SPY	ETF	106.59	106.59	106.47	106.5	416219.0
2009-09-24 09:25:00	SPY	ETF	106.49	106.51	106.39	106.41	554586.0
2009-09-24 09:30:00	SPY	ETF	106.41	106.64	106.4	106.58	3679514.0
2009-09-24 09:35:00	SPY	ETF	106.59	106.6	106.32	106.361	3061979.0
2009-09-24 09:40:00	SPY	ETF	106.36	106.51	106.21	106.22	3643338.0

> showing 50 of 32,166 rows — these rows as CSV

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