PREVIEW / etf_5min / 2008-08-07

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-08-07.parquet
  size:    493 KB
  rows:    23,357

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-08-07 04:15:00	SPY	ETF	128.75	128.75	128.75	128.75	100.0
2008-08-07 04:45:00	SPY	ETF	128.86	128.86	128.86	128.86	500.0
2008-08-07 05:40:00	SPY	ETF	128.77	128.77	128.77	128.77	2000.0
2008-08-07 05:45:00	SPY	ETF	128.76	128.76	128.76	128.76	3000.0
2008-08-07 06:10:00	SPY	ETF	128.64	128.74	128.64	128.74	10000.0
2008-08-07 06:15:00	SPY	ETF	128.78	128.83	128.78	128.83	2500.0
2008-08-07 06:25:00	SPY	ETF	128.64	128.64	128.64	128.64	500.0
2008-08-07 06:30:00	SPY	ETF	128.65	128.65	128.65	128.65	71000.0
2008-08-07 06:35:00	SPY	ETF	128.59	128.6	128.54	128.54	16500.0
2008-08-07 06:50:00	SPY	ETF	128.56	128.56	128.55	128.55	31000.0
2008-08-07 06:55:00	SPY	ETF	128.55	128.56	128.55	128.56	27000.0
2008-08-07 07:00:00	SPY	ETF	128.55	128.63	128.53	128.63	28500.0
2008-08-07 07:05:00	SPY	ETF	128.63	128.73	128.51	128.56	46091.0
2008-08-07 07:10:00	SPY	ETF	128.53	128.53	128.33	128.36	125700.0
2008-08-07 07:15:00	SPY	ETF	128.34	128.35	128.24	128.3	260900.0
2008-08-07 07:20:00	SPY	ETF	128.32	128.35	128.3	128.34	49604.0
2008-08-07 07:25:00	SPY	ETF	128.32	128.39	128.32	128.39	123800.0
2008-08-07 07:30:00	SPY	ETF	128.35	128.37	128.27	128.32	44445.0
2008-08-07 07:35:00	SPY	ETF	128.32	128.38	128.3	128.38	49047.0
2008-08-07 07:40:00	SPY	ETF	128.38	128.39	128.35	128.37	215900.0
2008-08-07 07:45:00	SPY	ETF	128.4	128.51	128.38	128.51	129781.0
2008-08-07 07:50:00	SPY	ETF	128.52	128.52	128.33	128.36	156469.0
2008-08-07 07:55:00	SPY	ETF	128.36	128.41	128.31	128.41	117644.0
2008-08-07 08:00:00	SPY	ETF	128.41	128.51	128.24	128.3	1219892.0
2008-08-07 08:05:00	SPY	ETF	128.29	128.39	128.28	128.28	618549.0
2008-08-07 08:10:00	SPY	ETF	128.29	128.31	128.25	128.28	347435.0
2008-08-07 08:15:00	SPY	ETF	128.29	128.32	128.27	128.32	292255.0
2008-08-07 08:20:00	SPY	ETF	128.33	128.38	128.28	128.38	206548.0
2008-08-07 08:25:00	SPY	ETF	128.37	128.4	128.35	128.35	255750.0
2008-08-07 08:30:00	SPY	ETF	128.36	128.36	127.89	128.05	3120390.0
2008-08-07 08:35:00	SPY	ETF	128.05	128.12	127.97	128.0	591516.0
2008-08-07 08:40:00	SPY	ETF	127.99	128.14	127.98	128.12	323376.0
2008-08-07 08:45:00	SPY	ETF	128.12	128.18	128.09	128.09	450443.0
2008-08-07 08:50:00	SPY	ETF	128.07	128.15	128.05	128.1	352568.0
2008-08-07 08:55:00	SPY	ETF	128.11	128.12	128.07	128.1	229181.0
2008-08-07 09:00:00	SPY	ETF	128.07	128.07	127.96	128.04	349228.0
2008-08-07 09:05:00	SPY	ETF	128.04	128.12	128.03	128.08	83963.0
2008-08-07 09:10:00	SPY	ETF	128.1	128.1	128.02	128.05	97128.0
2008-08-07 09:15:00	SPY	ETF	128.05	128.13	128.03	128.03	910506.0
2008-08-07 09:20:00	SPY	ETF	128.04	128.05	127.99	128.0	200375.0
2008-08-07 09:25:00	SPY	ETF	128.0	128.01	127.95	127.96	300953.0
2008-08-07 09:30:00	SPY	ETF	127.96	128.1	127.75	127.76	4831725.0
2008-08-07 09:35:00	SPY	ETF	127.76	127.8	127.33	127.5899	7000027.0
2008-08-07 09:40:00	SPY	ETF	127.6	127.68	127.54	127.6	2701958.0
2008-08-07 09:45:00	SPY	ETF	127.59	127.76	127.48	127.72	4763263.0
2008-08-07 09:50:00	SPY	ETF	127.71	128.93	127.69	127.87	4272521.0
2008-08-07 09:55:00	SPY	ETF	127.86	128.04	127.74	127.92	2631567.0
2008-08-07 10:00:00	SPY	ETF	127.91	128.1	127.84	128.08	6578585.0
2008-08-07 10:05:00	SPY	ETF	128.09	128.3	128.088	128.21	5362738.0
2008-08-07 10:10:00	SPY	ETF	128.21	128.24	128.01	128.1	3329947.0

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

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