PREVIEW / etf_5min / 2008-06-25

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-06-25.parquet
  size:    496 KB
  rows:    22,865

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
2008-06-25 04:15:00	SPY	ETF	131.84	131.84	131.84	131.84	200.0
2008-06-25 05:55:00	SPY	ETF	132.0	132.0	132.0	132.0	100.0
2008-06-25 06:05:00	SPY	ETF	131.92	131.93	131.9	131.93	25200.0
2008-06-25 06:10:00	SPY	ETF	131.97	131.97	131.97	131.97	1800.0
2008-06-25 06:25:00	SPY	ETF	131.93	131.93	131.93	131.93	6000.0
2008-06-25 06:30:00	SPY	ETF	131.94	131.96	131.94	131.96	19600.0
2008-06-25 06:35:00	SPY	ETF	131.92	131.96	131.92	131.96	7000.0
2008-06-25 06:45:00	SPY	ETF	131.94	131.94	131.93	131.93	13000.0
2008-06-25 06:50:00	SPY	ETF	131.99	132.02	131.99	132.02	29900.0
2008-06-25 06:55:00	SPY	ETF	131.94	131.94	131.94	131.94	2000.0
2008-06-25 07:00:00	SPY	ETF	131.91	131.91	131.82	131.86	50200.0
2008-06-25 07:05:00	SPY	ETF	131.9	131.93	131.9	131.93	20798.0
2008-06-25 07:10:00	SPY	ETF	131.99	132.01	131.96	131.99	304150.0
2008-06-25 07:15:00	SPY	ETF	132.0	132.05	132.0	132.05	181900.0
2008-06-25 07:20:00	SPY	ETF	132.05	132.08	132.0	132.0	105100.0
2008-06-25 07:25:00	SPY	ETF	132.05	132.08	131.99	131.99	291445.0
2008-06-25 07:30:00	SPY	ETF	131.95	131.96	131.89	131.89	32700.0
2008-06-25 07:35:00	SPY	ETF	131.95	131.98	131.95	131.97	115535.0
2008-06-25 07:40:00	SPY	ETF	131.95	132.0	131.9	131.9	245511.0
2008-06-25 07:45:00	SPY	ETF	131.87	131.93	131.87	131.92	57000.0
2008-06-25 07:50:00	SPY	ETF	131.89	131.91	131.89	131.91	30902.0
2008-06-25 07:55:00	SPY	ETF	131.91	131.94	131.86	131.88	30220.0
2008-06-25 08:00:00	SPY	ETF	131.89	132.08	131.8	131.87	959409.0
2008-06-25 08:05:00	SPY	ETF	131.87	131.94	131.82	131.82	164547.0
2008-06-25 08:10:00	SPY	ETF	131.83	131.88	131.78	131.86	127044.0
2008-06-25 08:15:00	SPY	ETF	131.85	131.9	131.85	131.88	220331.0
2008-06-25 08:20:00	SPY	ETF	131.89	131.89	131.84	131.86	85186.0
2008-06-25 08:25:00	SPY	ETF	131.85	131.9	131.81	131.9	88569.0
2008-06-25 08:30:00	SPY	ETF	131.91	132.05	131.88	131.98	1025470.0
2008-06-25 08:35:00	SPY	ETF	131.97	131.98	131.83	131.94	566554.0
2008-06-25 08:40:00	SPY	ETF	131.94	132.02	131.94	131.98	101960.0
2008-06-25 08:45:00	SPY	ETF	132.0	132.04	131.94	132.0	76340.0
2008-06-25 08:50:00	SPY	ETF	131.96	132.02	131.85	131.9	160518.0
2008-06-25 08:55:00	SPY	ETF	131.92	131.93	131.88	131.9	75644.0
2008-06-25 09:00:00	SPY	ETF	131.91	131.95	131.78	131.79	527100.0
2008-06-25 09:05:00	SPY	ETF	131.79	131.81	131.73	131.77	119088.0
2008-06-25 09:10:00	SPY	ETF	131.77	131.82	131.77	131.77	228206.0
2008-06-25 09:15:00	SPY	ETF	131.77	131.8	131.76	131.78	15197.0
2008-06-25 09:20:00	SPY	ETF	131.76	131.81	131.76	131.81	75976.0
2008-06-25 09:25:00	SPY	ETF	131.82	131.82	131.68	131.71	381015.0
2008-06-25 09:30:00	SPY	ETF	131.72	131.87	131.66	131.69	2258454.0
2008-06-25 09:35:00	SPY	ETF	131.69	132.05	131.62	132.02	5102564.0
2008-06-25 09:40:00	SPY	ETF	132.02	132.3	132.01	132.19	5757986.0
2008-06-25 09:45:00	SPY	ETF	132.2	132.35	132.17	132.23	4012567.0
2008-06-25 09:50:00	SPY	ETF	132.23	132.27	132.1	132.16	2202253.0
2008-06-25 09:55:00	SPY	ETF	132.17	132.22	132.0	132.17	2357087.0
2008-06-25 10:00:00	SPY	ETF	132.17	132.38	132.14	132.2704	3976838.0
2008-06-25 10:05:00	SPY	ETF	132.28	132.29	132.08	132.11	2324166.0
2008-06-25 10:10:00	SPY	ETF	132.12	132.15	131.95	131.96	1664863.0
2008-06-25 10:15:00	SPY	ETF	131.97	132.1	131.94	132.02	1848807.0

> showing 50 of 22,865 rows — these rows as CSV

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