PREVIEW / etf_5min / 2008-07-09

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-07-09.parquet
  size:    531 KB
  rows:    23,747

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-07-09 04:25:00	SPY	ETF	126.8	126.8	126.8	126.8	100.0
2008-07-09 05:40:00	SPY	ETF	126.93	126.93	126.9	126.9	25000.0
2008-07-09 05:55:00	SPY	ETF	127.09	127.1	127.09	127.1	2000.0
2008-07-09 06:00:00	SPY	ETF	127.1	127.1	127.1	127.1	2000.0
2008-07-09 06:25:00	SPY	ETF	127.01	127.01	127.01	127.01	1000.0
2008-07-09 06:30:00	SPY	ETF	126.96	126.96	126.96	126.96	25000.0
2008-07-09 06:35:00	SPY	ETF	126.89	126.9	126.8	126.8	33200.0
2008-07-09 06:40:00	SPY	ETF	126.79	126.79	126.79	126.79	55000.0
2008-07-09 06:45:00	SPY	ETF	126.78	126.78	126.78	126.78	100.0
2008-07-09 06:50:00	SPY	ETF	126.77	126.87	126.77	126.87	52500.0
2008-07-09 06:55:00	SPY	ETF	126.9	126.92	126.9	126.92	6500.0
2008-07-09 07:00:00	SPY	ETF	126.94	126.97	126.87	126.87	15300.0
2008-07-09 07:05:00	SPY	ETF	126.79	126.95	126.79	126.95	31500.0
2008-07-09 07:10:00	SPY	ETF	126.95	126.98	126.95	126.95	108000.0
2008-07-09 07:15:00	SPY	ETF	127.0	127.04	127.0	127.04	136000.0
2008-07-09 07:20:00	SPY	ETF	127.04	127.09	127.02	127.04	331814.0
2008-07-09 07:25:00	SPY	ETF	127.04	127.33	127.04	127.33	295700.0
2008-07-09 07:30:00	SPY	ETF	127.22	127.25	127.15	127.19	230917.0
2008-07-09 07:35:00	SPY	ETF	127.17	127.26	127.12	127.26	88492.0
2008-07-09 07:40:00	SPY	ETF	127.25	127.31	127.22	127.22	133500.0
2008-07-09 07:45:00	SPY	ETF	127.23	127.29	127.23	127.27	362611.0
2008-07-09 07:50:00	SPY	ETF	127.27	127.46	127.26	127.42	825213.0
2008-07-09 07:55:00	SPY	ETF	127.41	127.58	127.41	127.51	575570.0
2008-07-09 08:00:00	SPY	ETF	127.53	127.67	126.95	127.61	2910362.0
2008-07-09 08:05:00	SPY	ETF	127.6	127.61	127.45	127.47	132739.0
2008-07-09 08:10:00	SPY	ETF	127.48	127.68	127.47	127.63	166848.0
2008-07-09 08:15:00	SPY	ETF	127.63	127.68	127.6	127.68	399838.0
2008-07-09 08:20:00	SPY	ETF	127.68	127.71	127.66	127.71	770715.0
2008-07-09 08:25:00	SPY	ETF	127.69	127.69	127.66	127.69	179481.0
2008-07-09 08:30:00	SPY	ETF	127.66	127.7	127.62	127.68	183037.0
2008-07-09 08:35:00	SPY	ETF	127.69	127.69	127.64	127.66	298209.0
2008-07-09 08:40:00	SPY	ETF	127.66	127.74	127.64	127.71	475547.0
2008-07-09 08:45:00	SPY	ETF	127.71	127.75	127.67	127.68	255878.0
2008-07-09 08:50:00	SPY	ETF	127.67	127.71	127.63	127.68	155903.0
2008-07-09 08:55:00	SPY	ETF	127.67	127.69	127.62	127.62	192314.0
2008-07-09 09:00:00	SPY	ETF	127.63	127.64	127.49	127.52	328184.0
2008-07-09 09:05:00	SPY	ETF	127.51	127.55	127.43	127.45	528940.0
2008-07-09 09:10:00	SPY	ETF	127.45	127.51	127.4	127.46	589869.0
2008-07-09 09:15:00	SPY	ETF	127.45	127.5	127.43	127.46	741993.0
2008-07-09 09:20:00	SPY	ETF	127.46	127.54	127.44	127.52	544557.0
2008-07-09 09:25:00	SPY	ETF	127.5	127.57	127.44	127.51	470739.0
2008-07-09 09:30:00	SPY	ETF	127.5	127.67	127.47	127.62	4141176.0
2008-07-09 09:35:00	SPY	ETF	127.62	127.74	127.29	127.29	5248763.0
2008-07-09 09:40:00	SPY	ETF	127.3	127.5	127.08	127.21	6697884.0
2008-07-09 09:45:00	SPY	ETF	127.21	127.49	127.17	127.25	6729721.0
2008-07-09 09:50:00	SPY	ETF	127.25	127.31	126.92	126.97	6829334.0
2008-07-09 09:55:00	SPY	ETF	126.98	127.55	126.97	127.16	5579607.0
2008-07-09 10:00:00	SPY	ETF	127.16	127.18	126.9	126.95	5676767.0
2008-07-09 10:05:00	SPY	ETF	126.96	127.12	126.79	127.1	3596549.0
2008-07-09 10:10:00	SPY	ETF	127.1	127.19	126.99	127.12	5934458.0

> showing 50 of 23,747 rows — these rows as CSV

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