PREVIEW / etf_5min / 2007-06-19

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-06-19.parquet
  size:    304 KB
  rows:    16,567

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
2007-06-19 06:35:00	SPY	ETF	152.76	152.76	152.76	152.76	2000.0
2007-06-19 07:00:00	SPY	ETF	152.84	152.84	152.82	152.83	42500.0
2007-06-19 07:05:00	SPY	ETF	152.85	152.85	152.85	152.85	5000.0
2007-06-19 07:10:00	SPY	ETF	152.88	152.88	152.87	152.87	2500.0
2007-06-19 07:15:00	SPY	ETF	152.88	152.88	152.88	152.88	5000.0
2007-06-19 07:20:00	SPY	ETF	152.85	152.85	152.84	152.84	1500.0
2007-06-19 07:25:00	SPY	ETF	152.82	152.82	152.77	152.8	7300.0
2007-06-19 07:30:00	SPY	ETF	152.78	152.82	152.78	152.82	146000.0
2007-06-19 07:35:00	SPY	ETF	152.82	152.82	152.75	152.75	88800.0
2007-06-19 07:45:00	SPY	ETF	152.74	152.74	152.73	152.73	600.0
2007-06-19 07:50:00	SPY	ETF	152.72	152.75	152.72	152.75	4000.0
2007-06-19 07:55:00	SPY	ETF	152.81	152.81	152.81	152.81	9900.0
2007-06-19 08:00:00	SPY	ETF	152.72	152.81	152.69	152.7	492400.0
2007-06-19 08:05:00	SPY	ETF	152.72	152.72	152.62	152.65	113400.0
2007-06-19 08:10:00	SPY	ETF	152.63	152.65	152.61	152.63	169900.0
2007-06-19 08:15:00	SPY	ETF	152.63	152.67	152.5	152.51	64200.0
2007-06-19 08:20:00	SPY	ETF	152.52	152.57	152.48	152.57	111500.0
2007-06-19 08:25:00	SPY	ETF	152.54	152.58	152.52	152.58	39100.0
2007-06-19 08:30:00	SPY	ETF	152.58	152.7	152.56	152.6	348900.0
2007-06-19 08:35:00	SPY	ETF	152.59	152.66	152.59	152.65	71800.0
2007-06-19 08:40:00	SPY	ETF	152.65	152.65	152.58	152.59	130600.0
2007-06-19 08:45:00	SPY	ETF	152.6	152.61	152.58	152.6	158200.0
2007-06-19 08:50:00	SPY	ETF	152.6	152.64	152.52	152.55	238400.0
2007-06-19 08:55:00	SPY	ETF	152.54	152.58	152.52	152.56	56100.0
2007-06-19 09:00:00	SPY	ETF	152.55	152.56	152.53	152.56	28700.0
2007-06-19 09:05:00	SPY	ETF	152.57	152.6	152.56	152.57	41700.0
2007-06-19 09:10:00	SPY	ETF	152.56	152.61	152.54	152.6	181200.0
2007-06-19 09:15:00	SPY	ETF	152.6	152.65	152.48	152.53	146400.0
2007-06-19 09:20:00	SPY	ETF	152.53	152.63	152.53	152.61	214100.0
2007-06-19 09:25:00	SPY	ETF	152.62	152.65	152.58	152.64	278400.0
2007-06-19 09:30:00	SPY	ETF	152.64	152.72	152.59	152.69	2339700.0
2007-06-19 09:35:00	SPY	ETF	152.69	152.71	152.59	152.59	1470500.0
2007-06-19 09:40:00	SPY	ETF	152.6	152.69	152.55	152.63	1466520.0
2007-06-19 09:45:00	SPY	ETF	152.63	152.66	152.47	152.48	1400806.0
2007-06-19 09:50:00	SPY	ETF	152.47	152.54	152.36	152.49	3963200.0
2007-06-19 09:55:00	SPY	ETF	152.49	152.57	152.43	152.51	2362100.0
2007-06-19 10:00:00	SPY	ETF	152.52	152.59	152.39	152.53	1128280.0
2007-06-19 10:05:00	SPY	ETF	152.54	152.6	152.48	152.49	1427099.0
2007-06-19 10:10:00	SPY	ETF	152.488	152.54	152.4	152.42	918800.0
2007-06-19 10:15:00	SPY	ETF	152.415	152.58	152.41	152.58	1146300.0
2007-06-19 10:20:00	SPY	ETF	152.58	152.77	152.54	152.7	2064301.0
2007-06-19 10:25:00	SPY	ETF	152.69	152.72	152.65	152.7	814500.0
2007-06-19 10:30:00	SPY	ETF	152.7	152.9	152.7	152.84	2639611.0
2007-06-19 10:35:00	SPY	ETF	152.84	152.94	152.78	152.81	2500800.0
2007-06-19 10:40:00	SPY	ETF	152.81	152.87	152.75	152.79	876400.0
2007-06-19 10:45:00	SPY	ETF	152.79	152.9	152.77	152.82	1199800.0
2007-06-19 10:50:00	SPY	ETF	152.82	152.88	152.77	152.79	661000.0
2007-06-19 10:55:00	SPY	ETF	152.8	152.92	152.79	152.87	1329200.0
2007-06-19 11:00:00	SPY	ETF	152.86	152.88	152.75	152.77	635700.0
2007-06-19 11:05:00	SPY	ETF	152.77	152.8	152.69	152.76	768560.0

> showing 50 of 16,567 rows — these rows as CSV

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